drift_duckdb

A Drift database implementation for DuckDB.

This package allows you to use DuckDB as a backend for your Drift databases in Dart and Flutter applications.

简体中文

Features

• Drift Backend: Seamlessly integrate DuckDB with the Drift ORM.
• In-Memory & File-Based: Supports both :memory: and local file storage.
• Schema Versioning: Built-in support for Drift's schema versioning.
• Batched Statements: Supports running multiple statements in a transaction.

Getting started

Add drift_duckdb to your pubspec.yaml:

dependencies:
  drift_duckdb: any
  drift: ^2.31.0
  dart_duckdb: ^1.4.4

Make sure you have the DuckDB dynamic library available on your system. For macOS users using Homebrew:

import 'package:dart_duckdb/open.dart';
// ...
open.overrideFor(OperatingSystem.macOS, '/opt/homebrew/lib/libduckdb.dylib');

Usage

import 'package:drift/drift.dart';
import 'package:drift_duckdb/drift_duckdb.dart';

// Use an in-memory database
final executor = DuckdbQueryExecutor.inMemory();

// Or use a file-based database
// final executor = DuckdbQueryExecutor('path/to/my_database.db');

// Use it with your Drift database class
// final database = MyDriftDatabase(executor);