Introducing Magic Local Storage 1.0.1

A local SQLite database, ready for Magic.

DB and Schema facades, migrations, seeders, factories and a push-then-pull sync skeleton on one local SQLite connection.

Get started View on pub.dev

~/my_app

$ flutter pub add magic_local_storage

✓ magic, sqlite3 and path_provider resolved

dart run magic:dowel plugin:install magic_local_storage

✓ DatabaseServiceProvider registered, databaseConfig added to lib/main.dart

One connection. Every model.

Your Magic app gets a local SQLite database with facades, migrations and seeders that Laravel developers will find familiar. Listed targets: Android, iOS, macOS, Windows, Linux and web.

Migrations and Schema

Migration classes with up and down, the Schema facade (create, table, drop, dropIfExists, rename) and a Migrator that runs them with savepoints.
Learn more about Migrations and Schema
The DB facade

DB.table(name) returns a QueryBuilder, and the facade also runs raw SQL and DB.transaction.
Learn more about The DB facade
Local model storage

A Magic model that sets useLocal reads and writes the local database: the package binds a local_model_store behind the model methods.
Learn more about Local model storage
Seeders and factories

Seeder classes run with Seeding.run(list). Factory<T> classes (definition, count, create) build fake rows for seeds and tests.
Learn more about Seeders and factories
A sync skeleton

A push-then-pull skeleton: SyncFeed.run, a sync ledger and a cursors table on the same connection. It is a skeleton, not a finished sync.
Learn more about A sync skeleton
One SQLite engine

Native targets use the sqlite3 package over FFI, with the file in the application documents directory. The web uses sqlite3.wasm on an IndexedDB-backed file system.
Learn more about One SQLite engine

Add it in seconds

~/my_app

flutter pub add
                magic_local_storage

Or add to pubspec.yaml:

dependencies:
  magic_local_storage: ^1.0.1

Or give your AI agent this prompt:

Read   https://anilcancakir.com/magic/docs/local_storage/llms.txt   and   install   the   Magic   Local   Storage   package   in   this   project.

Docs

A local SQLite database, ready for Magic.

One connection. Every model.

Migrations and Schema

The DB facade

Local model storage

Seeders and factories

A sync skeleton

One SQLite engine

Add it in seconds