Skip to content
Projets

kysely-org/kysely-postgres-js

Voir sur GitHub

kysely-org/kysely-postgres-js has 144 GitHub stars and 9 forks. GitHot measured 0 stars in 24 hours and +1 in 7 days. Last checked 2026-11-21 23:06 UTC. Last push 2026-11-19.

Comment ces chiffres sont mesurés

Progression mesurée des étoiles

in 24h
0
in 7 days
+1
in 15 days
Historique en cours
in 1 month
Historique en cours

Variations nettes sur des périodes qui se chevauchent, pas des totaux quotidiens. Les mesures absentes restent vides. Les étoiles indiquent l’intérêt, pas la qualité.

À propos

Kysely dialect for PostgreSQL that supports the Postgres.js client and Bun's SQL native binding.

Données

README.md

Original

A Kysely-branded yellow duck canoeing with a Postgres.js-branded grey elephant in the river

NPM Version Tests License Issues Pull Requests GitHub contributors Downloads

Join the discussion ⠀⠀⠀⠀⠀⠀⠀

Discord Bluesky

kysely-postgres-js offers a Kysely dialect for PostgreSQL that supports the Postgres.js client library (version >= 3.4, including 4.x) and Bun's (version >= 1.2) SQL native binding.

This dialect should not be confused with Kysely's core PostgreSQL dialect, which supports the significantly more adopted pg client library and Neon's WebSockets Pool instead. Both of these dialects are maintained by members of the Kysely core team and are production ready.

Installation

Node.js

npm install kysely-postgres-js postgres kysely
pnpm add kysely-postgres-js postgres kysely
yarn add kysely-postgres-js postgres kysely

Other runtimes

deno add npm:kysely-postgres-js npm:postgres npm:kysely
bun add kysely-postgres-js kysely

Usage

Node.js

import { type GeneratedAlways, Kysely } from 'kysely'
import { PostgresJSDialect } from 'kysely-postgres-js'
import postgres from 'postgres'

interface Database {
	person: {
		id: GeneratedAlways<number>
		first_name: string | null
		last_name: string | null
		age: number
	}
}

const db = new Kysely<Database>({
	dialect: new PostgresJSDialect({
		postgres: postgres({
			database: 'test',
			host: 'localhost',
			max: 10,
			port: 5434,
			user: 'admin',
		}),
	}),
})

const people = await db.selectFrom('person').selectAll().execute()

Bun

import { SQL } from 'bun'
import { type GeneratedAlways, Kysely } from 'kysely'
import { PostgresJSDialect } from 'kysely-postgres-js'

interface Database {
	person: {
		id: GeneratedAlways<number>
		first_name: string | null
		last_name: string | null
		age: number
	}
}

const db = new Kysely<Database>({
	dialect: new PostgresJSDialect({
		postgres: new SQL({
			database: 'test',
			host: 'localhost',
			max: 10,
			port: 5434,
			user: 'admin',
		}),
	}),
})

const people = await db.selectFrom('person').selectAll().execute()

Aborting queries

This dialect supports Kysely's AbortSignal integration, including the 'cancel query' and 'kill session' values of inflightQueryAbortStrategy, which stop the aborted query on the database side:

await db
	.selectFrom('person')
	.selectAll()
	.execute({
		signal: AbortSignal.timeout(5_000),
		inflightQueryAbortStrategy: 'kill session',
	})

Under the hood, 'cancel query' uses Postgres.js' native wire-protocol cancellation when running on Postgres.js, and pg_cancel_backend on a control connection when running on Bun's SQL (whose cancel() doesn't cancel queries on the database side). 'kill session' executes pg_terminate_backend on a control connection in both cases.

controlPostgres

By default, control queries (e.g. pg_terminate_backend) are executed on a connection acquired from the postgres pool. This might mean waiting for an idle connection, and with a small, saturated pool (e.g. max: 1), it can wait forever - the aborted query's connection is only returned to the pool after the control query runs.

To avoid this, provide controlPostgres. You can pass postgres or Bun's SQL directly - it is invoked with the main instance's resolved options, with max overridden to 1. A custom factory receiving those options works too. Both libraries' pools are lazy, so the control instance doesn't hold a connection until the first control query runs.

Node.js

import { Kysely } from 'kysely'
import { PostgresJSDialect } from 'kysely-postgres-js'
import postgres from 'postgres'

const db = new Kysely<Database>({
	dialect: new PostgresJSDialect({
		controlPostgres: postgres,
		postgres: postgres({
			database: 'test',
			host: 'localhost',
			max: 10,
			port: 5434,
			user: 'admin',
		}),
	}),
})

Bun

import { SQL } from 'bun'
import { Kysely } from 'kysely'
import { PostgresJSDialect } from 'kysely-postgres-js'

const db = new Kysely<Database>({
	dialect: new PostgresJSDialect({
		controlPostgres: SQL,
		postgres: new SQL({
			database: 'test',
			host: 'localhost',
			max: 10,
			port: 5434,
			user: 'admin',
		}),
	}),
})

Prepared statements

postgres prepares statements by default when using it's template literal form, and supports connection max lifetime settings that effectively evict memory.

This dialect makes use of prepared statements starting from version 5, to match upstream.

When running in a long running server, be mindful of https://github.com/kysely-org/kysely-postgres-js/issues/468.

Explorer des projets similaires

Chargement…