sqflite-common-api

Depend on sqflite_common in your package and add sqflite_common_ffi as a dev dependency. Call sqfliteFfiInit in setUpAll, then pass databaseFactoryFfi to your code; inMemoryDatabasePath gives an isolated in-memory database per test.

sqflite is the Flutter plugin providing a SQLite engine on Android, iOS, and macOS, while sqflite_common defines the pure-Dart API with no Flutter dependency and no engine. Libraries should depend on sqflite_common and accept a DatabaseFactory from the caller.

Libraries should import package:sqflite_common/sqlite_api.dart, which exposes only the types like DatabaseFactory, Database, and Transaction. Importing sqflite.dart additionally reads the global databaseFactory, which forces the consuming app to initialize it.

The global databaseFactory in sqflite.dart throws StateError until an implementation package sets it. The application must assign databaseFactory first, for example databaseFactory = databaseFactoryFfi from sqflite_common_ffi, before calling the global openDatabase.

No, inside db.transaction((txn) async {...}) you must use only the txn object for all operations. The transaction commits when the callback returns and rolls back when it throws; onCreate and onUpgrade callbacks are already inside a transaction.

Use queryIterate or rawQueryIterate with a bufferSize (default 100) and an onRow callback, or use queryCursor with moveNext and close. Returning false from onRow stops iteration early.