@alineo-labs/sqlite

SQLite storage adapter for alineo. Stores the sandbox ledger in a local .db file — zero infrastructure, works out of the box.

bun add @alineo-labs/sqlite

For production workloads that need durability across multiple processes or machines, use @alineo-labs/postgres instead.

Usage

import { Sandbox } from "@alineo-labs/sandbox";
import { SQLiteAdapter } from "@alineo-labs/sqlite";

const client = new Sandbox({
  baseUrl: "http://localhost:8080",
  adapter: new SQLiteAdapter("./ledger.db"),
});

The adapter initialises lazily on first use — no connect() call needed. On process exit, beforeExit closes the connection automatically.

WAL mode is enabled by default for better concurrent read performance.

License

Apache 2.0