- Support for creating tables in SQLite STRICT mode. Thanks, Taj Khattra. (#344)
- CLI commands
create-table
,insert
andupsert
all now accept a--strict
option. - Python methods that can create a table -
table.create()
andinsert/upsert/insert_all/upsert_all
all now accept an optionalstrict=True
parameter. - The
transform
command andtable.transform()
method preserve strict mode when transforming a table.
- CLI commands
- The
sqlite-utils create-table
command now acceptsstr
,int
andbytes
as aliases fortext
,integer
andblob
respectively. (#606)