dart-drift

Comprehensive guide for using drift database library in Dart applications. Dart Drift skill provides complete guidance for implementing persistent storage in Dart applications (CLI tools, backend services, non-Flutter desktop apps) using the drift library. Drift is a reactive persistence library for Dart built on SQLite, with optional PostgreSQL support, offering type-safe queries, auto-updating streams, schema migrations, and cross-platform database connections. Add dependencies to pubspec.yaml : Define database: Open database: Run code generator: Add PostgreSQL dependencies: Configure for PostgreSQL in build.yaml : Open PostgreSQL connection: See detailed documentation for each topic: Uses sqlite3 package with file-based storage. Uses postgres package with connection pooling. Uses in-memory database for fast unit tests. Increase pool size or reduce connection lifetime: Verify dialect is configured in build.yaml . - setup.md - Dart setup with sqlite3 or PostgreSQL - postgres.md - PostgreSQL-specific features, connection pooling - 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 - Connection pooling for PostgreSQL in production - In-memory databases for fast unit tests - Transactions for data...