Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Comprehensive dump module #529

Open
14 tasks
rogerbinns opened this issue Jun 18, 2024 · 0 comments
Open
14 tasks

Comprehensive dump module #529

rogerbinns opened this issue Jun 18, 2024 · 0 comments

Comments

@rogerbinns
Copy link
Owner

Currently you have to do shenanigans via the shell to get dumps. Add a module that lets you configure what you want in the dump, acting as a generator. Have some presets for eg full fidelity dump, mysql/postgres etc compatible, just the data etc

  • Header fields like page_size, encoding, auto vacuum
  • application id / user_version
  • drop table if already exists
  • A schema so it can be run against attached database
  • include/exclude virtual tables and their backing data tables
  • comments at the top or not
  • multiple values clauses
  • include/omit views and indexes
  • rename indexes?
  • include/exclude sqlite_stat and similar tables
  • run analyze at the end
  • Include rowid in insert
  • insert or replace so it can run against existing table to merge into it
  • foreign key state handling
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant