Studio

import type { Config } from 'drizzle-kit';

export default {
    // schema: './src/db/schemas/*.ts',
    // out: './src/db/migrations'
    driver: 'pg',
    dbCredentials: {
        host: 'db',
        port: 5432,
        user: process.env.DB_USER!,
        password: process.env.DB_PASSWORD!,
        database: process.env.DB_NAME!,
        ssl: false
    },
    verbose: true,
    out: './src/db/migrations',
    schema: './src/db/schemas.ts'
} satisfies Config;

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

const pool = new Pool({
    host: 'db',
    port: 5432,
    user: process.env.DB_USER!,
    password: process.env.DB_PASSWORD!,
    database: process.env.DB_NAME!,
    ssl: false
});

export const db = drizzle(pool, { logger: true, schema });