Important notice:Moor has been renamed to Drift. Learn more here.

Supported platforms

All platforms supported by drift, and how to use them

Being built on top of the sqlite3 database, drift can run on almost every Dart platform. Since the initial release, the Dart and Flutter ecosystems have changed a lot. To clear confusion about different drift packages and when to use them, this document lists all supported platforms and how to use drift when building apps for them.

To achieve platform independence, drift separates its core apis from a platform-specific database implementation. The core apis are pure-Dart and run on all Dart platforms, even outside of Flutter. When writing drift apps, prefer to mainly use the apis in package:drift/drift.dart as they are guaranteed to work across all platforms. Depending on your platform, you can choose a different QueryExecutor.

Mobile (Android and iOS)

There are two drift implementations for mobile that you can use:

using moor_flutter

The original moor_flutter package uses sqflite and only works on Android and iOS. For new projects, we generally recommend the newer ffi-based implementation, but moor_flutter is still maintained and supported.

using drift/native

The new package:drift/native.dart implementation uses dart:ffi to bind to sqlite3's native C apis. This is the recommended approach for newer projects as described in the getting started guide.

To ensure that your app ships with the latest sqlite3 version, also add a dependency to the sqlite3_flutter_libs package when using package:drift/native.dart!

Web

Main article: Web

For apps that run on the web, you can use drift's experimental web implementation, located in package:drift/web.dart. As it binds to sql.js, special setup is required. Please read the main article for details.

Desktop

Drift also supports all major Desktop operating systems where Dart runs on by using the NativeDatabase from package:drift/native.dart. Depending on your operating system, further setup might be required:

Windows

On Windows, you can download sqlite and extract sqlite3.dll into a folder that's in your PATH environment variable to use drift.

You can also ship a custom sqlite3.dll along with your app. See the section below for details.

Linux

On most distributions, libsqlite3.so is installed already. If you only need to use drift for development, you can just install the sqlite3 libraries. On Ubuntu and other Debian-based distros, you can install the libsqlite3-dev package for this. Virtually every other distribution will also have a prebuilt package for sqlite.

You can also ship a custom libsqlite3.so along with your app. See the section below for details.

macOS

This one is easy! Just use the NativeDatabase from package:drift/native.dart. No further setup is necessary.

If you need a custom sqlite3 library, or want to make sure that your app will always use a specific sqlite3 version, you can also ship that version with your app. When depending on sqlite3_flutter_libs, drift will automatically use that version which is usually more recent than the sqlite3 version that comes with macOS.

Bundling sqlite with your app

If you don't want to use the sqlite3 version from the operating system (or if it's not available), you can also ship sqlite3 with your app. The best way to do that depends on how you ship your app. Here, we assume that you can install the dynamic library for sqlite next to your application executable.

This example shows how to do that on Linux, by using a custom sqlite3.so that we assume lives next to your application:

import 'dart:ffi';
import 'dart:io';
import 'package:sqlite3/sqlite3.dart';
import 'package:sqlite3/open.dart';

void main() {
  open.overrideFor(OperatingSystem.linux, _openOnLinux);

  // After setting all the overrides, you can use drift!
}

DynamicLibrary _openOnLinux() {
  final scriptDir = File(Platform.script.toFilePath()).parent;
  final libraryNextToScript = File('${scriptDir.path}/sqlite3.so');
  return DynamicLibrary.open(libraryNextToScript.path);
}
// _openOnWindows could be implemented similarly by opening `sqlite3.dll`

Be sure to use drift after you set the platform-specific overrides. When you usedrift in another isolate, you'll also need to apply the opening overrides on that background isolate. You can call them in the isolate's entrypoint before using any drift apis.