Moor

Important notice: Moor has been renamed to Drift. This package will continue to be supported for a while, but we encourage users to migrate to drift. Automated tooling to help you make the switch is available! For more information, see the documentation. Thanks yor your understanding!

Proudly Sponsored by Stream 💙


Try the Flutter Chat Tutorial  💬

Moor is a reactive persistence library for Flutter and Dart, built on top of sqlite. Moor is

  • Flexible: Moor let's 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: Moor 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, moor helps you keep your database code simple.
  • 🛡️ Safe: Moor generates typesafe code based on your tables and queries. If you make a mistake in your queries, moor will find it at compile time and provide helpful and descriptive lints.
  • ⚡ Fast: Even though moor lets you write powerful queries, it can keep up with the performance of key-value stores. Moor 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: Moor 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: Moor is stable and well tested with a wide range of unit and integration tests. It powers production Flutter apps.

With moor, persistence on Flutter is fun!

To start using moor, 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.

For the web

For information to use this library on the web (including Flutter web), follow the instructions here. Keep in mind that web support is still experimental.

Libraries

backends
Utility classes to implement custom database backends that work together with moor.
extensions/json1
Experimental bindings to the json1 sqlite extension.
extensions/moor_ffi
High-level bindings to mathematical functions that are only available in moor_ffi.
ffi
Moor implementation using package:sqlite3/.
isolate
Contains utils to run moor databases in a background isolate. This API is not supported on the web.
moor
moor_web
A version of moor that runs on the web by using sql.js You manually need to include that library into your website to use the web version of moor. See the documentation for a more detailed instruction.
remote
Library support for accessing remote databases.
sqlite_keywords
Provides utilities around sql keywords, like optional escaping etc.