smaltdbSmall. Alternate. Fast.

A fast alternative database for the browser, written in TypeScript.

smaltdb

smaltdb

Off the main thread

The engine runs in Web Workers, so queries never block the page.

Durable on OPFS

Data lives in the Origin Private File System. Commits are atomic and durable through a write-ahead log.

SQLite-flavoured SQL

The dialect is based on SQLite, so existing SQL knowledge carries over.

Introspection

An information_schema, plus sqlite_schema and PRAGMA compatibility.

Quick start

ts

import { open } from 'smaltdb';

const db = await open('app'); // engine runs in a worker, data lives in OPFS
await db.exec('CREATE TABLE IF NOT EXISTS todo(id INTEGER PRIMARY KEY, title TEXT NOT NULL, done INT DEFAULT 0)');
await db.exec('INSERT INTO todo(title) VALUES (?)', ['write docs']);
const rows = await db.query('SELECT id, title FROM todo WHERE done = 0');