# Magic Local Storage documentation

> Magic Local Storage is SQLite for Magic apps: DB and Schema facades, migrations, seeders, factories and a sync skeleton.

## Getting Started

- [Installation](https://anilcancakir.com/magic/docs/local_storage/getting-started/installation.md): Add magic_local_storage to a Magic app, register its provider and config, and check that the DB facade reaches an open SQLite connection.

## The Basics

- [Configuration](https://anilcancakir.com/magic/docs/local_storage/basics/configuration.md): Choose the database file with the database config, and learn how DatabaseManager opens SQLite on native platforms and on the web.
- [Models](https://anilcancakir.com/magic/docs/local_storage/basics/models.md): Persist a Magic Model to the local SQLite database with useLocal => true, and understand the LocalModelStore contract this package fulfils.
- [Queries](https://anilcancakir.com/magic/docs/local_storage/basics/queries.md): Run raw SQL, build queries with the fluent QueryBuilder and group writes in a transaction through the DB facade.
- [Migrations](https://anilcancakir.com/magic/docs/local_storage/basics/migrations.md): Define and change SQLite tables with Migration classes, the Schema facade and a Blueprint, and apply them with the Migrator.
- [Seeding](https://anilcancakir.com/magic/docs/local_storage/basics/seeding.md): Fill the local database with sample or default rows using Seeder classes and model Factory classes, and run them with Seeding.run.

## Guides

- [Generators](https://anilcancakir.com/magic/docs/local_storage/guides/generators.md): Scaffold migrations, seeders and factories with make:migration, make:seeder and make:factory, and wire the package into an app with local_storage:install.
- [Sync](https://anilcancakir.com/magic/docs/local_storage/guides/sync.md): Keep a local table consistent with a server across many devices with SyncFeed, a push-then-pull loop over one resource, and SyncLedger, its bookmark store.
- [Testing](https://anilcancakir.com/magic/docs/local_storage/guides/testing.md): Test code that persists to SQLite against an in-memory database per test, run migrations and factories in it, assert with DB, and fake the store when a test…

## Optional

- [Magic Local Storage](https://anilcancakir.com/magic/local_storage): the package landing page
- [Full documentation](https://anilcancakir.com/magic/docs/local_storage/llms-full.txt): every page in one file