2.7

• New columns= argument for the .insert(), .insert_all(), .upsert() and .upsert_all() methods, for over-riding the auto-detected types for columns and specifying additional columns that should be added when the table is created. See Custom column order and column types. (#100)

2.6

• New table.rows_where(..., order_by="age desc") argument, see Listing rows. (#76)

2.5

• Panda’s Timestamp is now stored as a SQLite TEXT column. Thanks, b0b5h4rp13! (#96)
• table.last_pk is now only available for inserts or upserts of a single record. (#98)
• New Database(filepath, recreate=True) parameter for deleting and recreating the database. (#97)

2.4.4

• Fixed bug where columns with only null values were not correctly created. (#95)

2.4.3

• Column type suggestion code is no longer confused by null values. (#94)

2.4.2

• table.column_dicts now works with all column types - previously it would throw errors on types other than TEXT, BLOB, INTEGER or FLOAT. (#92)
• Documentation for NotFoundError thrown by table.get(pk) - see Retrieving a specific record.

2.4.1

• table.enable_fts() now works with columns that contain spaces. (#90)

2.4

• table.disable_fts() can now be used to remove FTS tables and triggers that were created using table.enable_fts(...). (#88)
• The sqlite-utils disable-fts command can be used to remove FTS tables and triggers from the command-line. (#88)
• Trying to create table columns with square braces ([ or ]) in the name now raises an error. (#86)
• Subclasses of dict, list and tuple are now detected as needing a JSON column. (#87)

2.3.1

table.create_index() now works for columns that contain spaces. (#85)

2.3

table.exists() is now a method, not a property. This was not a documented part of the API before so I’m considering this a non-breaking change. (#83)