ORM

Learn Dart database with the drift ORM.

drift ORM

drift is a reactive ORM for Dart. It is built on top of sqflite. You define tables as Dart classes; drift offers type-safe queries and code generation. Instead of raw SQL you use a Dart API.

A table is defined as class Notes extends Table { TextColumn get title => text()(); }. Table is the base class; TextColumn is a text column, text()() is the column-producing helper. In this lesson we learn drift table definitions.

Table definition

In drift a table is a Dart class extending Table. Each column is a getter: TextColumn get title => text()(); is a text column, IntColumn get id => integer().autoIncrement()(); is an auto-incrementing integer column.

From this definition drift generates type-safe query methods via code generation. You query with calls like db.select(notes).get(); no SQL needed. In this lesson we define the Notes table.

Exercise Define the Notes table

Add import 'package:drift/drift.dart';. Define class Notes extends Table { ... } with TextColumn get title => text()(); inside. In main add print('drift: Notes table') and print('Column: title (text)').

Show example solution

import 'package:drift/drift.dart';

class Notes extends Table {
  TextColumn get title => text()();
}

void main() {
  print('drift: Notes table');
  print('Column: title (text)');
}

Test yourself

The drift import

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

Show answer

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

Match the drift parts

drift

Reactive ORM
Table

Table class
TextColumn

Text column
text()()

Column builder
What does drift provide?
- Web server
- HTTP client
- Type-safe ORM
- File compression
Show answer

Type-safe ORM — drift provides a type-safe ORM.

Next lesson: Summary - Database

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies