Skip to content
项目

kysely-org/kysely-postgres-js

在 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.

这些数字如何统计

实测星标增长

24小时
0
7天
+1
15天
正在收集历史
1个月
正在收集历史

各周期内的星标净变化,周期相互重叠,并非每日新增。缺失的测量保持空白。星标代表关注度,不代表软件质量。

关于

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

数据

README.md

原文

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.

探索相关项目

加载中…