src/server/db/index.ts


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

import { Pool } from 'pg';
import { drizzle } from 'drizzle-orm/node-postgres';

import { env } from '@/env';
import * as schema from './schema';

const pool = new Pool({
  connectionString: env.DATABASE_URL,
});

export const db = drizzle({
  client: pool,
  schema,
  casing: 'snake_case',
});