huncholane/defi_propertyPublic

main

defi_property/server/db/index.js

26 lines599 BJavaScript

RawDownloadHistory

1	const { Pool } = require('pg');
2
3	if (!process.env.DATABASE_URL) {
4	console.error('DATABASE_URL environment variable is not set');
5	process.exit(1);
6	}
7
8	const pool = new Pool({
9	connectionString: process.env.DATABASE_URL,
10	max: 20,
11	idleTimeoutMillis: 30000,
12	connectionTimeoutMillis: 2000,
13	});
14
15	pool.on('connect', () => {
16	console.log('Connected to PostgreSQL');
17	});
18
19	pool.on('error', (err) => {
20	console.error('PostgreSQL pool error:', err);
21	});
22
23	const query = (text, params) => pool.query(text, params);
24	const getClient = () => pool.connect();
25
26	module.exports = { query, getClient, pool };