postgres

This page explains how to use ts-sql-query with the postgres (aka Postgres.js) driver. It covers two approaches: using a connection pool or using a single connection directly.

Supported databases

• PostgreSQL

Do not share connections between requests

A ts-sql-query connection object — along with the query runner instances passed to its constructor — represents a dedicated connection to the database.

Therefore, you must not share the same connection object between concurrent HTTP requests. Instead, create a new connection object for each request, along with its own query runners.

Even if the query runner internally uses a connection pool, the ts-sql-query connection still represents a single active connection, acquired from the pool. It must be treated as such and never reused across requests.

Using a connection pool

Executes queries through a postgres (aka Postgres.js) connection obtained from a pool.

import * as postgres from 'postgres';
import { PostgresQueryRunner } from '../queryRunners/PostgresQueryRunner';

const sql = postgres({
    user: 'dbuser',
    host: 'database.server.com',
    database: 'mydb',
    password: 'secretpassword',
    port: 3211,
});

async function main() {
    const connection = new DBConnection(new PostgresQueryRunner(sql));
    // Do your queries here
}

Limitation

Low-level transaction management functions (connection.beginTransaction, connection.commit, connection.rollback) are not supported; you must use connection.transaction instead.