← back to Interiordesignershowroom

lib/db.js

15 lines

// Postgres pool. Local dev uses a dedicated `idshowroom` database; prod overrides via DATABASE_URL.
const { Pool } = require('pg');

const pool = new Pool({
  connectionString: process.env.DATABASE_URL || 'postgresql:///idshowroom?host=/tmp',
  max: 10,
});

pool.on('error', (err) => console.error('[db] idle client error', err.message));

module.exports = {
  pool,
  query: (text, params) => pool.query(text, params),
};