import { drizzle } from 'drizzle-orm/node-postgres';
import { Pool } from 'pg';
import * as schema from './schema'; 

const pool = new Pool({
  connectionString: process.env.DATABASE_URL as string,
  // connectionString: "postgresql://dts:dujinDTS2@localhost:5432/evcp",
  max: Number(process.env.DB_POOL_MAX) || 4,
});

const db = drizzle(pool, { schema });


export default db;