From 2b309097ca145651618234476160fb30405eabe7 Mon Sep 17 00:00:00 2001 From: Linnnus Date: Mon, 17 Feb 2025 20:28:59 +0100 Subject: Initial commit --- app/src/lib/server/db.ts | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) create mode 100644 app/src/lib/server/db.ts (limited to 'app/src/lib/server/db.ts') diff --git a/app/src/lib/server/db.ts b/app/src/lib/server/db.ts new file mode 100644 index 0000000..dcfcfd0 --- /dev/null +++ b/app/src/lib/server/db.ts @@ -0,0 +1,20 @@ +import pg from "pg"; +import { env } from "$env/dynamic/private"; + +const pool = new pg.Pool({ + database: env.POSTGRES_DB || "postgres", + user: env.POSTGRES_USERNAME || "postgres", + host: env.POSTGRES_HOST || "localhost", + port: Number(env.POSTGRES_PORT || 5432), +}); + +// Prevent errors in idle clients from terminating Node process. +// See: https://node-postgres.com/features/pooling +// See: https://nodejs.org/api/events.html#error-events +pool.on("error", (err, client) => { + console.error("Database error: ", err, client); +}); + +export function getDbConnection(): Promise { + return pool.connect(); +} -- cgit v1.2.3