Releases: simonw/db-to-sqlite
Releases · simonw/db-to-sqlite
1.5
07 Feb 01:09
Compare
Sorry, something went wrong.
No results found
Upgraded for compatibility with SQLAlchemy 2.0. #46
Now documented to work with MS SQL Server. Thanks, Ryan Cheley. #37
1.4
11 Jun 22:55
Compare
Sorry, something went wrong.
No results found
New --postgres-schema option for specifying a different PostgreSQL schema, thanks Jeremy Dormitzer. #29
Correctly handles table names that need escaping, such as user in PostgreSQL. #25
Empty tables are now created in the SQLite database with a matching schema, rather than being skipped. #28
Connection strings starting with postgres:// are treated as if they started with postgresql://. #34
1.3
27 Jul 23:39
Compare
Sorry, something went wrong.
No results found
Added support for compound primary keys. #26
1.2.1
28 May 23:23
Compare
Sorry, something went wrong.
No results found
1.2
28 May 23:17
Compare
Sorry, something went wrong.
No results found
Bumped to sqlite-utils 2.9.1. This fixes two things:
Decimal columns are now supported. They become FLOAT columns in SQLite.
Fixed a bug where columns that were a combination of integers and nulls were incorrectly stored as TEXT, not INTEGER.
1.1.1
11 Feb 21:07
Compare
Sorry, something went wrong.
No results found
I made a mistake with the release of 1.1 to PyPI - this fixes it.
1.1
11 Feb 20:53
Compare
Sorry, something went wrong.
No results found
Fixed compatibility with sqlite-utils 2.x - #20
1.0.2
03 Aug 04:09
Compare
Sorry, something went wrong.
No results found
Fix for #18 - no longer throws error on empty tables
1.0.1
01 Jul 04:09
Compare
Sorry, something went wrong.
No results found
1.0
01 Jul 01:32
Compare
Sorry, something went wrong.
No results found
See the README for full usage instructions.
Instead of using --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
Foreign keys are now created with indexes, use --no-index-fks to disable this, #12
--table can now be used multiple times, #6
README and --help now include example connection strings
README also details how this can be used with Heroku Postgres