16 lines
497 B
TypeScript
16 lines
497 B
TypeScript
// server/db/client.ts
|
|
import Database from "better-sqlite3";
|
|
import { drizzle } from "drizzle-orm/better-sqlite3";
|
|
import { mkdirSync } from "node:fs";
|
|
import { dirname } from "node:path";
|
|
import { env } from "../env.js";
|
|
import * as schema from "./schema.js";
|
|
|
|
mkdirSync(dirname(env.dbPath), { recursive: true });
|
|
const sqlite = new Database(env.dbPath);
|
|
sqlite.pragma("journal_mode = WAL");
|
|
sqlite.pragma("foreign_keys = ON");
|
|
|
|
export const db = drizzle(sqlite, { schema });
|
|
export { schema };
|