Store.sqlite

Creates an atomic store from a SQLite database's prepared statements.

Usage

import { Store } from 'mppx'
import { DatabaseSync } from 'node:sqlite'
 
const db = new DatabaseSync('mppx.db')
const store = Store.sqlite(db) 
 
await store.put('usage:customer-42', { requests: 1 })
console.log(await store.get('usage:customer-42'))
{ requests: 1 }

Supports node:sqlite, better-sqlite3, and bun:sqlite with SQLite 3.35+ (RETURNING). For asynchronous libSQL or Turso, use Store.sql.

Return type

type ReturnType = Store.AtomicStore

• Provides get, put, delete, atomic update, and replay claims; see the AtomicStore contract.
• Keep update callbacks synchronous and side-effect-free: conflicts rerun them.

Parameters

database

• Type: Store.sqlite.Database

Database exposing prepare(sql).all(...params). Statements may expose reader and run(...params); the adapter calls run when reader === false, as better-sqlite3 requires.

options (optional)

• Type: Store.sql.Options

See Store.sql for schema, migrations, serialization, and conflict errors.