Function openLocalLibsql

apps/local/src/db/libsql.ts:23–37

(path: string)

 * PRAGMAs (foreign_keys + WAL). Used for the long-lived FumaDB handle.
 */
export const openLocalLibsql = async (path: string): Promise<Client> => {
  const client = createClient({ url: toLibsqlFileUrl(path) });
  // foreign_keys is strictly per-connection; WAL is a file-level mode set on
  // first enabling. Re-apply both since libSQL gives no shared handle.
  await client.execute("PRAGMA foreign_keys = ON");
  await client.execute("PRAGMA journal_mode = WAL");
  // busy_timeout is per-connection (default 0 = fail immediately on a lock).
  // Under the supervised-daemon model a single process owns this file, but a
  // second OS process can still transiently hold the write lock (e.g. a CLI
  // tool, the v1→v2 migration reader, or a launchd restart racing the old
  // pid). Give writers a 5s retry window instead of an instant SQLITE_BUSY.
  // Matches the self-host open path (self-host-db.ts).
  await client.execute("PRAGMA busy_timeout = 5000");
  return client;
};

const asRows = <T>(result: ResultSet): readonly T[] =>
  // oxlint-disable-next-line executor/no-double-cast -- boundary: SQLite result columns are the schema contract for T; libSQL rows are narrowed once here