sqflite-common-ffi-desktop

Add sqflite_common_ffi to your dependencies, import package:sqflite_common_ffi/sqflite_ffi.dart, call sqfliteFfiInit() once, then open databases with databaseFactoryFfi.openDatabase(). This is the only way to use the sqflite API on the Dart VM.

Set databaseFactory = databaseFactoryFfi once before any global openDatabase() call, after calling sqfliteFfiInit(). Alternatively depend on the sqflite_ffi package, which registers the ffi factory automatically and shares the isolate between Flutter isolates.

No, databaseFactoryFfi throws UnsupportedError on the web. Use databaseFactoryFfiWeb from the sqflite_common_ffi_web package instead, which requires sqlite3.wasm and a worker file in your web directory.

This happens when running plain dart file.dart, which skips build hooks that download the bundled SQLite library. Run dart run bin/main.dart once from a terminal so hooks execute and the library is cached under .dart_tool/hooks_runner/.

Set hooks.user_defines.sqlite3 source to sqlcipher or sqlite3mc in your application pubspec.yaml, then send PRAGMA key = 'your key' as the first statement in onConfigure when opening the database.

Use databaseFactoryFfiNoIsolate inside a background isolate you already own, such as Isolate.run or compute, or in Flutter widget tests. In the main isolate of a UI app it runs SQLite synchronously and long queries block the UI.