From f211ebcfac0a21e264b67c1226509896a11ed5ca Mon Sep 17 00:00:00 2001 From: nsfisis Date: Wed, 31 Dec 2025 19:35:17 +0900 Subject: refactor(db): replace DATABASE_URL with individual POSTGRES_* env vars MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Eliminates duplicate configuration by building the connection URL from POSTGRES_USER, POSTGRES_PASSWORD, POSTGRES_DB, POSTGRES_HOST, and POSTGRES_PORT instead of requiring a separate DATABASE_URL. 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 --- src/server/db/index.ts | 13 +++++-------- 1 file changed, 5 insertions(+), 8 deletions(-) (limited to 'src/server/db') diff --git a/src/server/db/index.ts b/src/server/db/index.ts index 0e69fad..4826710 100644 --- a/src/server/db/index.ts +++ b/src/server/db/index.ts @@ -2,15 +2,12 @@ import { drizzle } from "drizzle-orm/node-postgres"; import * as schema from "./schema.js"; import * as schemaCrdt from "./schema-crdt.js"; -const databaseUrl = process.env.DATABASE_URL; +const { POSTGRES_USER, POSTGRES_PASSWORD, POSTGRES_DB, POSTGRES_HOST, POSTGRES_PORT } = process.env; -if (!databaseUrl) { - throw new Error("DATABASE_URL environment variable is not set"); -} - -export const db = drizzle(databaseUrl, { - schema: { ...schema, ...schemaCrdt }, -}); +export const db = drizzle( + `postgresql://${POSTGRES_USER}:${POSTGRES_PASSWORD}@${POSTGRES_HOST}:${POSTGRES_PORT}/${POSTGRES_DB}`, + { schema: { ...schema, ...schemaCrdt } }, +); export * from "./schema.js"; export * from "./schema-crdt.js"; -- cgit v1.2.3-70-g09d2