db-to-sqlite
db-to-sqlite copied to clipboard
simonw
CLI tool for exporting tables or queries from any SQL database to a SQLite file
I have the case where I run this CLI in batch in several databases with a list of tables I want to import. At the moment the tables I am...
I'm trying to use `db-to-sqlite` to convert a set of MySQL DDL files into an SQLite database. Some of my tables use the `BIT(1)` type to encode boolean values but...
I noticed while running the tests locally that the MySQL tests started failing with an error (complete summary at the bottom): > `MySQLdb.IntegrityError: (1062, "Duplicate entry '1' for key 'vendors.PRIMARY'")`...
I just tried the tool, and it worked perfectly except for the views I had in my PostgreSQL database. They don't seem to be present in the SQLite database. Is...
I get the following error when I try to use the [db-to-sqlite](https://datasette.io/tools/db-to-sqlite#user-content-usage) command to export my postgres db into a .db file: `sqlite3.OperationalError: table sqlite_master may not be modified` I'm...
Thank you for making such a handy tool. Recently, I ran into a problem. The SQLite version generated by the tool (3.12.99) doesn't support the [RETURNING](https://www.sqlite.org/lang_returning.html) clause. Is there a...
Hello, when i run following command: db-to-sqlite "postgresql://username:password@localhost/databaseName" databaseName.db \ --all It dump my database with all table but it does not copy all constraints. How can i copy all...
I'm trying to back up a postgres db to sqlite, but running in to this issue: `ValueError: year 275760 is out of range` This database has a expires_at which is...
