@alt-javascript/jsdbc-pg

JSDBC driver for PostgreSQL via pg. Full PostgreSQL support through the async JSDBC interface.

Part of the @alt-javascript/jsdbc monorepo.

Install

npm install @alt-javascript/jsdbc-core @alt-javascript/jsdbc-pg

Usage

import { DataSource } from '@alt-javascript/jsdbc-core';
import '@alt-javascript/jsdbc-pg'; // self-registers with DriverManager

const ds = new DataSource({
  url: 'jsdbc:pg://localhost:5432/mydb',
  username: 'myuser',
  password: 'mypass',
});

const conn = await ds.getConnection();

const ps = await conn.prepareStatement('SELECT * FROM users WHERE id = ?');
ps.setParameter(1, 42);
const rs = await ps.executeQuery();
console.log(rs.getRows());

rs.close();
await conn.close();

URL Scheme

jsdbc:pg://<host>:<port>/<database>

| URL | Description | |---|---| | jsdbc:pg://localhost:5432/mydb | Local PostgreSQL on default port | | jsdbc:pg://db.example.com:5432/prod | Remote PostgreSQL |

Credentials are passed via DataSource config (username, password) or embedded in the URL (jsdbc:pg://user:pass@host:port/db).

Placeholder Conversion

JSDBC uses ? placeholders (JDBC convention). The driver converts them to PostgreSQL's $1, $2, ... syntax automatically.

// You write:
const ps = await conn.prepareStatement('SELECT * FROM users WHERE name = ? AND age > ?');
// Driver sends: SELECT * FROM users WHERE name = $1 AND age > $2

License

MIT