Skip to main content

pool

PostgreSQL connection pool instance for executing database queries.

Import​

import { pool } from '@evershop/evershop/lib/postgres';
import {select} from '@evershop/postgres-query-builder';

const product = await select().from('product').where('product_id', 123).load(pool);

Type​

Pool

The pool is a PostgreSQL connection pool instance from the pg library.

Configuration​

The pool is configured using environment variables or configuration file:

Environment Variables​

  • DB_HOST - Database host
  • DB_PORT - Database port
  • DB_USER - Database user
  • DB_PASSWORD - Database password
  • DB_NAME - Database name
  • DB_SSLMODE - SSL mode (disable, require, prefer, verify-ca, verify-full, no-verify)
  • DB_SSLROOTCERT - Path to SSL root certificate
  • DB_SSLCERT - Path to SSL certificate
  • DB_SSLKEY - Path to SSL key

See Also​