src/db/db.ts


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

import { drizzle } from "drizzle-orm/node-postgres";

import * as schema from "./schema";
import { logger } from "../lib/pino";
import { redisCache } from "./redis/cache";
import { redis } from "./redis/client";

logger.info("Initializing database connection...");

/** Main database instance with Redis caching and query logging */
export const db = drizzle(process.env.DATABASE_URL!, {
  schema,
  cache: redisCache({ global: true, defaultTtl: 120, redis }),
  logger: {
    logQuery: (query, params) => {
      logger.debug({ query, params }, "Database query executed");
    },
  },
});

logger.info("Database connection initialized");