- Potentially breaking change Migrate to version 3.x of the
sqlite3package.
To upgrade:- For the web, update
sqlite3.wasmfrom a 3.x release. - If you've previously used
sqlcipher_flutter_libs, see this for encryption support and note that SQLite3MultipleCiphers requires additional pragmas to be compatible with SQLCipher databases.
- For the web, update
serializableConnection(),json1andTableMigrationare no longer marked as experimental.- Improve performance of mapping large result sets through joined select statements.
- In drift files, imports and statements can now be parsed from SQL line comments. This makes drift files easier to use from some SQL editors:
-- import 'tables.drift';
-- deleteById:
DELETE FROM todos WHERE id = :id;
-- allTodos:
SELECT * FROM todos;