flutter-drift-persistence-engineering
Installation
SKILL.md
Flutter Drift Persistence Engineering
Treat Drift as a typed SQLite persistence system with generated APIs, reactive invalidation, platform-specific executors, and irreversible schema evolution—not as a generic key-value store.
Reference routing
Read only what the task requires:
| Need | Reference |
|---|---|
| Dependencies, database declaration, connection ownership, DAOs, generated-code layout | references/01-setup-and-architecture.md |
| Tables, constraints, relationships, indexes, Dart/SQL queries, joins, pagination | references/02-schema-and-queries.md |
| Writes, transactions, batches, streams, invalidation, profiling, large datasets | references/03-writes-streams-and-performance.md |
Native isolates, driftDatabase, NativeDatabase, WAL/read pools, Web/WASM |
references/04-platforms-and-concurrency.md |
| Migrations, migration tests, ordinary tests, backup, diagnostics, security, reviews | references/05-migrations-testing-and-operations.md |
| Version baseline and authoritative URLs | references/06-authoritative-sources.md |
The bundled research was checked on 2026-08-11 against Drift 2.34.3, drift_flutter 0.3.1, and current official Drift/SQLite documentation. Always inspect the project’s pubspec.lock, SDK constraints, generated code, and installed package source before relying on a signature or default.