Skip to content

Releases: simonw/db-to-sqlite

1.5

07 Feb 01:09
Compare
Choose a tag to compare
  • 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
Choose a tag to compare
1.4
  • 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
63e4ee9
Compare
Choose a tag to compare
1.3
  • Added support for compound primary keys. #26

1.2.1

28 May 23:23
045cbee
Compare
Choose a tag to compare

1.2

28 May 23:17
aa288d8
Compare
Choose a tag to compare
1.2

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
Choose a tag to compare

I made a mistake with the release of 1.1 to PyPI - this fixes it.

1.1

11 Feb 20:53
Compare
Choose a tag to compare
1.1

Fixed compatibility with sqlite-utils 2.x - #20

1.0.2

03 Aug 04:09
Compare
Choose a tag to compare

Fix for #18 - no longer throws error on empty tables

1.0.1

01 Jul 04:09
Compare
Choose a tag to compare
  • Improvements to README

1.0

01 Jul 01:32
Compare
Choose a tag to compare
1.0

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