sql-reactive-ormReactive ORM for SQLite, built on MobX

Entity fields are Promises. React `use()`-native. Aggregate queries that re-run — and re-render only the leaves whose data moved.

Get started

Live demo

GitHub

Reactive ORM bridging a SQLite database to React components via Promise-typed fields

Promises as fields

user.name is a Promise. user.posts is a Promise. Identity-map hits resolve synchronously; misses hydrate in the background.

React use() native

Drop a query straight into use(orm.findAll(...)) and get Suspense-friendly loading, stable row identity, and per-field reactivity.

Aggregates with Kysely

orm.sqlQuery(db => db.selectFrom('transactions')…) — typed, auto-invalidated on every write to the involved tables.

Any SQL driver

The ORM talks through a 3-method Driver interface. A SqlJsDriver ships in the box; plug your own into anything that can run SQL.

Reactive writes, too

The reactive driver parses each run / exec, extracts mutated tables, and fires table-scoped invalidations automatically. Batched inside transactions.

Pairs with sql-git

Hand the ORM a driver backed by sql-git's Store.db and you get replicated, reactive SQLite — in the browser.

At a glance

tsx

// orm.ts
import { Orm } from "sql-reactive-orm";
import { SqlJsDriver } from "sql-reactive-orm/drivers/sqljs";
import wasmUrl from "sql.js/dist/sql-wasm.wasm?url";
import { Account, Transaction } from "./entities";

const driver = await SqlJsDriver.open({ locateFile: () => wasmUrl });
export const orm = new Orm(driver);
await orm.register(Account, Transaction);

// TransactionList.tsx
import { use } from "react";
import { orm } from "./orm";
import { Transaction } from "./entities";

export function TransactionList() {
  const txs = use(
    orm.findAll(Transaction, {
      orderBy: [["id", "desc"]],
      with: { account: true },
      limit: 50,
    }),
  );
  return <ul>{txs.map(tx => <li key={tx.id}>{use(tx.amount)}</li>)}</ul>;
}