Sqflite Migrations with Multiverse Time Travel
This is an integration for db_migrations_with_multiverse_time_travel.
Usage
import 'package:sqflite_migrations_with_multiverse_time_travel/sqflite_migrations_with_multiverse_time_travel.dart';
import 'package:sqflite_common_ffi/sqflite_ffi.dart';
final migrations = [
Migration(
definedAt: DateTime.utc(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;
""",
),
];
Future<void> main() async {
sqfliteFfiInit();
var databaseFactory = databaseFactoryFfi;
var db = await databaseFactory.openDatabase(inMemoryDatabasePath);
await SqfliteDatabase(db).migrate(migrations);
for (final row in await db.query('users')) {
print(row);
}
await db.close();
}
Libraries
- sqflite_migrations_with_multiverse_time_travel
- A library for managing SQLite database migrations with multiverse time travel.