import { Database } from "bun:sqlite"; // Each entry is one migration. Add new ones at the end; never edit old ones. // SQLite's user_version remembers how many have run. const migrations = [ `CREATE TABLE messages ( id INTEGER PRIMARY KEY, author TEXT NOT NULL, body TEXT NOT NULL, created_at TEXT NOT NULL DEFAULT (datetime('now')) )`, ]; export type Message = { id: number; author: string; body: string; created_at: string }; export function openDb(path: string): Database { const db = new Database(path, { create: true, strict: true }); db.run("PRAGMA journal_mode = WAL"); // readers don't wait for writers db.run("PRAGMA synchronous = NORMAL"); // safe with WAL, and much faster writes db.run("PRAGMA busy_timeout = 5000"); const { user_version } = db.query("PRAGMA user_version").get() as { user_version: number }; for (let i = user_version; i < migrations.length; i++) { db.transaction(() => { db.run(migrations[i]!); db.run(`PRAGMA user_version = ${i + 1}`); })(); } return db; }