search

simonw / db-to-sqlite

CLI tool for exporting tables or queries from any SQL database to a SQLite file
Apache License 2.0
368 stars 28 forks source link

Handle large numbers of foreign keys better in --all #8

Closed simonw closed 5 years ago

simonw commented 5 years ago

--all currently spends a huge amount of time adding foreign keys thanks to the limitation described in https://github.com/simonw/sqlite-utils/issues/31

Once I add .add_foreign_keys(...) in that library I should use it here.

simonw commented 5 years ago

Version 1.3 of sqlite-utils shipped the feature I need for this: https://sqlite-utils.readthedocs.io/en/latest/python-api.html#adding-multiple-foreign-key-constraints-at-once