src/lib/db/pg/db.pg.ts

import { drizzle as drizzlePg } from "drizzle-orm/node-postgres";
import { Pool } from "pg";

const pool = new Pool({
  connectionString: process.env.POSTGRES_URL,
  ssl: { rejectUnauthorized: false },
  max: 3,
  idleTimeoutMillis: 300000,
});

export const pgDb = drizzlePg({ client: pool });