A reactive persistence library for Flutter and Dart, built on SQLite.
Field note
drift is a reactive persistence library for Flutter and Dart, built on SQLite. It provides type-safe SQL queries, migrations, and reactive streams.
Capabilities
Tags
Ways to use it
Dart / drift
Dart / drift_flutter
Not filed / Not filed
Product features
Companion classes for partial updates and inserts with Value.absent() support.
Generate methods from SQL files for type-safe queries.
Use onCreate callbacks to insert data on first app start.
Support for raw SQL queries with table tracking.
Annotate a class to define the database and trigger code generation.
Works with Flutter StreamBuilder and Riverpod StreamProvider.
Insert rows using companions, with support for auto-increment and default values.
Stores DateTime in ISO 8601 text format with UTC offset handling.
Support for inner and left outer joins.
Enable logStatements to print SQL statements executed.
Provides a manager-based query API.
Ability to manually mark tables as updated.
Guides for migrating between datetime storage modes.
Manage schema migrations and custom migration strategies.
Generate standalone library files to avoid name conflicts.
Include a pre-populated database asset in your app.
Core query builder for building queries.
Provides reactive queries that update automatically.
Supports advanced schema migrations with testing tools.
Required getter for migrations.
Provides get(), getSingle(), getSingleOrNull() and matching watch() methods.
Configure drift_dev to support PostgreSQL via build.yaml.
Use Companion.custom to apply SQL expressions during updates.
Ability to use subqueries in select statements.
Define tables using Dart classes extending Table.
Dart API for writing SQL queries with type safety.
Provides type-safe query building and result mapping.
Stores DateTime as SQL INTEGER containing unix timestamp in seconds.
Use generated classes to update or delete rows with optional where clauses.
Insert or update on conflict using insertOnConflictUpdate.