// src\db\index.ts
import { config } from "dotenv";
import { drizzle } from "drizzle-orm/node-postgres";
import { Pool } from "pg";
import * as schema from "@/db/schema";
config({
path:
process.env.NODE_ENV === "production"
? ".env.production"
: ".env.development",
});
export const pool = new Pool({
connectionString: process.env.DATABASE_URL!,
ssl: true,
});
const db = drizzle(pool, {
schema,
logger: true,
casing: "snake_case",
});
export default db;
// src\db\index.ts
import { config } from "dotenv";
import { drizzle } from "drizzle-orm/node-postgres";
import { Pool } from "pg";
import * as schema from "@/db/schema";
config({
path:
process.env.NODE_ENV === "production"
? ".env.production"
: ".env.development",
});
export const pool = new Pool({
connectionString: process.env.DATABASE_URL!,
ssl: true,
});
const db = drizzle(pool, {
schema,
logger: true,
casing: "snake_case",
});
export default db;