flutter-drift

Comprehensive guide for using drift database library in Flutter applications. Flutter Drift skill provides complete guidance for implementing persistent local storage in Flutter apps using the drift library. Drift is a reactive persistence library for Flutter built on SQLite, offering type-safe queries, auto-updating streams, schema migrations, and cross-platform support. Add dependencies to pubspec.yaml : Define database: Run code generator: See detailed documentation for each topic: Uses drift_flutter with getApplicationSupportDirectory . Place sqlite3.wasm and drift_worker.js in web/ folder. Use in-memory database for tests: Ensure operations go through drift APIs, not raw SQLite. - setup.md - Flutter-specific setup with drift_flutter - tables.md - Table definitions, columns, constraints - queries.md - SELECT, WHERE, JOIN, aggregations - writes.md - INSERT, UPDATE, DELETE, transactions - streams.md - Reactive stream queries - migrations.md - Database schema migrations - flutter-ui.md - Flutter UI integration patterns - Use drift_flutter for easy database setup across platforms - StreamBuilder for reactive UI updates - Provider/Riverpod for database access management - Close database on app/widget dispose - Use migrations when schema changes - Index columns used in WHERE clauses - Limit stream query size for performance - Use transactions for multi-step operations - Debounce...