CLI tool for exporting tables or queries from any SQL database to a SQLite file
APACHE-2.0 License
Bot releases are hidden (Show)
Published by simonw over 3 years ago
--postgres-schema
option for specifying a different PostgreSQL schema, thanks Jeremy Dormitzer. #29
user
in PostgreSQL. #25
postgres://
are treated as if they started with postgresql://
. #34
Published by simonw about 4 years ago
Published by simonw over 4 years ago
Published by simonw over 4 years ago
Bumped to sqlite-utils
2.9.1. This fixes two things:
Published by simonw over 4 years ago
I made a mistake with the release of 1.1 to PyPI - this fixes it.
Published by simonw over 4 years ago
Fixed compatibility with sqlite-utils
2.x - #20
Published by simonw about 5 years ago
Fix for #18 - no longer throws error on empty tables
Published by simonw over 5 years ago
Published by simonw over 5 years ago
See the README for full usage instructions.
--connection
the connection string is now a required positional argument, #14--sql
must now be accompanied by --output
specifying the table the query results should be written to--redact tablename columnname
option can be used to redact values, #2--no-index-fks
to disable this, #12--table
can now be used multiple times, #6--help
now include example connection stringsPublished by simonw over 5 years ago
--progress
option to show progress bars during import - #7Published by simonw over 5 years ago
pip install db-to-sqlite[postgresql]
#4pip install db-to-sqlite[mysql]
Published by simonw over 5 years ago
--all
can now add many foreign key relationships without a VACUUM
between each one, #8Published by simonw over 5 years ago
toposort
--all --skip=table
option for skipping one or more tables when running --all
Published by simonw over 5 years ago
--all
tables in toposort orderPublished by simonw over 5 years ago
Anchor to sqlite-utils==0.13 to pick up a breaking change.
Published by simonw over 5 years ago
--all
option can now be used to duplicate an entire database, including detecting foreign key relationships.
--table
option called without --sql
will now mirror the specified table.