api / src /db /index.ts
lljz66's picture
Put src/db/index.ts
c61f54b verified
Raw History Blame Contribute Delete
546 Bytes
import { drizzle } from "drizzle-orm/node-postgres";
import { Pool } from "pg";
const databaseUrl = process.env.DATABASE_URL;
if (!databaseUrl) {
throw new Error("DATABASE_URL is required");
}
const globalForDb = globalThis as typeof globalThis & {
__arenaNextJsPostgresqlPool?: Pool;
};
export const pool =
globalForDb.__arenaNextJsPostgresqlPool ??
new Pool({
connectionString: databaseUrl,
});
if (process.env.NODE_ENV !== "production") {
globalForDb.__arenaNextJsPostgresqlPool = pool;
}
export const db = drizzle(pool);