sqlite3_migrations_with_multiverse_time_travel 1.0.0

Runs database migrations for apps using sqlite3. Helps with checking out different branches during development by storing the instructions to run down migrations alongside the data in the db.

Sqlite3 Migrations with Multiverse Time Travel

This is an integration for db_migrations_with_multiverse_time_travel.

Usage

import 'package:sqlite3_migrations_with_multiverse_time_travel/sqlite3_migrations_with_multiverse_time_travel.dart';

final migrations = [
  Migration(
    definedAt: DateTime(2025, 3, 14, 1),
    up: """
create table users (
  id integer primary key autoincrement,
  name text not null
);

insert into users (name) values ('Alice');
insert into users (name) values ('Bob');
""",
    down: """
drop table users;
""",
  ),
];

final db = sqlite3.openInMemory();

Sqlite3Database(db).migrate(migrations);

for (final row in db.select('select * from users').rows) {
  print(row);
}