1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20

// db/index.ts — server-side Drizzle client over local SQLite (better-sqlite3).
// Imported by /api routes and server scripts. Never import from client components.
//
// The DB file lives at <repo>/data/dashboard.db (gitignored). No cloud, no network.

import Database from "better-sqlite3";
import { drizzle } from "drizzle-orm/better-sqlite3";
import { mkdirSync } from "node:fs";
import { dirname, resolve } from "node:path";
import * as schema from "./schema";

const dbPath = process.env.DATABASE_PATH ?? resolve(process.cwd(), "data/dashboard.db");
mkdirSync(dirname(dbPath), { recursive: true });

const sqlite = new Database(dbPath);
sqlite.pragma("journal_mode = WAL");
sqlite.pragma("foreign_keys = ON");

export const db = drizzle(sqlite, { schema });
export { schema };