Search packages, repositories and app categories

ducafecatFlutter ecosystem guide
Package detailsv0.3.1

drift_flutter

Easily set up drift databases across platforms in Flutter apps.

AndroidiOSWebmacOSWindowsLinux
pub.dev API documentation Source code
30-day downloads
615K
Likes
70
Pub points
160

Install package

flutter pub add drift_flutter

Package Overview

Package selection guidance compiled from public package information, community data, and project usage.

Drift Flutter is a powerful, cross-platform database solution for Flutter apps that simplifies the setup and management of SQLite databases. It provides a type-safe, reactive API for querying and modifying data, with support for migrations, background execution, and real-time updates. Built on top of Drift, it enables seamless integration across Android, iOS, Web, macOS, Windows, and Linux. The package enhances developer productivity by reducing boilerplate and offering intuitive syntax for complex database operations.

Use cases

  • Offline-first mobile applications
  • Real-time data synchronization
  • Cross-platform data persistence
  • Complex query handling
  • App state management with local storage
  • Offline data caching

Key features

  • Type-safe SQL queries
  • Reactive database streams
  • Automatic schema migrations
  • Support for multiple platforms
  • Background database operations
  • Intuitive Dart API

Suitable for

  • Developers building offline-capable apps
  • Teams needing consistent database behavior across platforms
  • Apps requiring real-time data updates
  • Projects with complex data models
  • Flutter developers seeking a robust alternative to shared_preferences

Considerations

  • Requires understanding of SQL and database design
  • Learning curve for advanced features like transactions
  • May increase app size due to SQLite inclusion
  • Not ideal for simple key-value storage needs
  • Limited documentation compared to mature alternatives

Original README

Original README snapshot from the linked source repository. Visit the repository for the latest content.

Drift

Build Status Using melos

Core Generator
Main version Generator version

Drift is a reactive persistence library for Flutter and Dart, built on top of SQLite. Drift is:

  • Flexible: Drift lets you write queries in both SQL and Dart, providing fluent apis for both languages. You can filter and order results or use joins to run queries on multiple tables. You can even use complex SQL features like WITH and WINDOW clauses.
  • 🔥 Feature rich: Drift has builtin support for transactions, schema migrations, complex filters and expressions, batched updates and joins. We even have a builtin IDE for SQL!
  • 📦 Modular: Thanks to builtin support for daos and imports in SQL files, drift helps you keep your database code simple.
  • 🛡️ Safe: Drift generates type-safe code based on your tables and queries. If you make a mistake in your queries, drift will find it at compile time and provide helpful and descriptive lints.
  • ⚡ Fast: Even though drift lets you write powerful queries, it can keep up with the performance of key-value stores like shared preferences and Hive. Drift is the only major persistence library with builtin threading support, allowing you to run database code across isolates with zero additional effort.
  • Reactive: Turn any SQL query into an auto-updating stream! This includes complex queries across many tables.
  • ⚙️ Cross-Platform support: Drift works on Android, iOS, macOS, Windows, Linux and the web. This template is a Flutter todo app that works on all platforms.
  • 🗡️ Battle tested and production ready: Drift is stable and well tested with a wide range of unit and integration tests. It powers production Flutter apps.

With drift, persistence on Flutter is fun!

To start using drift, read our detailed docs.

If you have any questions, feedback or ideas, feel free to create an issue. If you enjoy this project, I'd appreciate your 🌟 on GitHub.

Sponsors

Drift is proudly Sponsored by Stream 💙 and PowerSync.


Try the Flutter Chat Tutorial  💬
Try PowerSync with Supabase

Working on this project

This repository contains a number of packages making up the drift project, most notably:

  • drift: The main runtime for drift, which provides most APIs.
  • drift_dev: The compiler for drift tables, databases and daos. It also contains a fully-featured SQL IDE for the Dart analyzer.
  • sqlparser: A SQL parser and static analyzer, written in pure Dart. This package can be used without drift to perform analysis on SQL statements. It's on pub at sqlparser.

We use melos to manage the different packages in this repository.

You can install it with dart pub global activate melos. To activate it in this repository, run dart pub get in this directory followed by melos bootstrap.

Categories

Persistent SQL Database

Dependencies

Dependency list 7 items

Source repository

Projects using this package