spb/note-spboucher-ai

1import { drizzle } from "drizzle-orm/postgres-js";2import postgres from "postgres";3import * as schema from "./schema";45const globalForDb = globalThis as unknown as { __sql?: ReturnType<typeof postgres> };6export const sql = globalForDb.__sql ?? postgres(process.env.DATABASE_URL!, { max: 10, idle_timeout: 30, prepare: false, transform: { undefined: null } });7if (process.env.NODE_ENV !== "production") globalForDb.__sql = sql;8export const db = drizzle(sql, { schema, casing: "snake_case" });9export { schema };10export type DB = typeof db;11