Summary - Database

Combine sqflite, CRUD and transactions to write a user database.

Summary - Database

In this group we learned local database management with Dart. sqflite provides embedded SQLite; Database is the connection object; CRUD operations (insert/query/update/delete) manage data; transaction adds atomicity; drift builds a type-safe ORM on top.

In this summary we combine sqflite setup and a CRUD operation: a setupDb function opens the database and creates a table; an addNote function inserts a note. This is a small but working example of a real application's data layer.

Exercise Setup and add a note

The code below imports sqflite. Define setupDb(): open with openDatabase('notes.db'), create the table with db.execute('CREATE TABLE notes (id INTEGER PRIMARY KEY, title TEXT)') and return db. Define addNote(Database db): insert with db.insert('notes', {'title': 'Summary note'}). In main add print('Summary: sqflite + CRUD'), await setupDb(), await addNote(db), print('Added: Summary note') and await db.close().

Show example solution

import 'package:sqflite/sqflite.dart';

Future<Database> setupDb() async {
  final db = await openDatabase('notes.db');
  await db.execute('CREATE TABLE notes (id INTEGER PRIMARY KEY, title TEXT)');
  return db;
}

Future<void> addNote(Database db) async {
  await db.insert('notes', {'title': 'Summary note'});
}

void main() async {
  print('Summary: sqflite + CRUD');
  final db = await setupDb();
  await addNote(db);
  print('Added: Summary note');
  await db.close();
}

Test yourself

Which one is the atomic operation?
- db.close
- db.query
- db.execute
- Transaction
Show answer

Transaction — a transaction runs multiple operations atomically.
Match the database concepts

sqflite

Embedded SQLite
Database

Connection
CRUD

insert/query/update/delete
drift

ORM

The db.transaction call

await db.____((txn) async {
    await txn.insert('notes', {'title': 'Summary note'});
  });

Show answer

await db.transaction((txn) async {
    await txn.insert('notes', {'title': 'Summary note'});
  });

Next lesson: dart2js

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies