Function openDb

packages/persistence/src/sqlite.ts:94–101

(dir: string)

/** Open (and migrate) the SQLite database under `dir`. */
export function openDb(dir: string): Db {
  mkdirSync(dir, { recursive: true });
  const db = new DatabaseSync(join(dir, "app.db")) as Db;
  db.exec("PRAGMA journal_mode = WAL;");
  db.exec("PRAGMA foreign_keys = ON;");
  db.exec(MIGRATIONS);
  return db;
}