porsager/postgres

View on GitHub

Postgres.js - The Fastest full featured PostgreSQL client for Node.js, Deno, Bun and CloudFlare

Stars: 8.7k
Forks: 374
Open beginner issues: 0
Indexed issues: 244
Avg merge: 11d 16h
Merged PRs (30d): 1

Dominant language: JavaScript
License: Unlicense
Last GitHub push: Sep 2, 2026
Latest indexed: Sep 19, 2026
Contributing guide: No contributing guide
Code of conduct: No code of conduct
Beginner labels: help wanted

Beginner friendly Everything

Open All

244 open issues indexed

fetch_types: false, deadlocks reserve() and alternatively pulls ~10KB from server before any work and can burn GBs of egress per month Open

Difficulty 4/5 3-5 days Newbie friendliness 55/100

porsager/postgres#1219 · 3 comments · Opened Sep 10, 2026
sql.begin() resolves when COMMIT returns ROLLBACK after a caught savepoint failure Open

Difficulty 4/5 3-5 days Newbie friendliness 68/100

porsager/postgres#1217 · Opened Sep 9, 2026
Disconnected transaction handles can read another user's rows through RLS Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

porsager/postgres#1216 · Opened Sep 9, 2026
Cloudflare build: a failed TLS handshake (untrusted CA, e.g. Supabase) surfaces as CONNECT_TIMEOUT instead of the real error Open

Difficulty 3/5 1-2 days Newbie friendliness 70/100

porsager/postgres#1213 · Opened Sep 5, 2026
sql.begin() always throws UNSAFE_TRANSACTION when max_pipeline is 0 Open

Difficulty 3/5 1-2 days Newbie friendliness 78/100

porsager/postgres#1210 · Opened Sep 2, 2026
nextWrite() throws an uncaughtException when a reserved connection's backend dies Open

Difficulty 2/5 1-3 hours Newbie friendliness 84/100

porsager/postgres#1208 · 2 comments · Opened Sep 1, 2026
Unhandled rejection kills the process when the internal array-types query is cancelled (57014) - repro for #279 Open

Difficulty 3/5 1-2 days Newbie friendliness 78/100

porsager/postgres#1205 · Opened Aug 31, 2026
Connection of one in-process transaction being handed to a separate transaction, causing corruption Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

porsager/postgres#1204 · Opened Aug 30, 2026
Cloudflare/workerd: sql.reserve() never resolves on a pool that has not yet opened a connection Open

Difficulty 3/5 1-2 days Newbie friendliness 68/100

porsager/postgres#1203 · Opened Aug 28, 2026
Cloudflare/workerd: every sql.end() leaves an unhandled rejection (Stream was cancelled) Open

Difficulty 2/5 1-3 hours Newbie friendliness 82/100

porsager/postgres#1202 · Opened Aug 28, 2026
Timestamp ordering and cursor pagination with 13-digit Unix timestamps Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

porsager/postgres#1200 · Opened Aug 27, 2026
bug: pool never recovers after releasing a reserved connection whose backend was terminated. Open

Difficulty 3/5 1-2 days Newbie friendliness 68/100

porsager/postgres#1199 · Opened Aug 22, 2026
Cloudflare polyfill: unhandled rejection when a connection closes (read() emits 'error' after listeners are removed) Open

Difficulty 3/5 1-2 days Newbie friendliness 68/100

porsager/postgres#1196 · Opened Aug 20, 2026
reserve() permanently stranded when a pooled connection is terminated server-side while the reserve is queued (3.4.9) Open

Difficulty 4/5 3-5 days Newbie friendliness 55/100

porsager/postgres#1195 · Opened Aug 20, 2026
Clean socket close with a pending initial query never settles it and spins an unbounded zero-delay reconnect loop Open

Difficulty 4/5 3-5 days Newbie friendliness 55/100

porsager/postgres#1193 · 2 comments · Opened Aug 14, 2026
fetchArrayTypes() promise is discarded in ReadyForQuery: a failing fetch_types query crashes the process via unhandled rejection Open

Difficulty 2/5 1-3 hours Newbie friendliness 78/100

porsager/postgres#1192 · Opened Aug 13, 2026
BEGIN can reach PostgreSQL without reserving the transaction connection Open

Difficulty 4/5 3-5 days Newbie friendliness 48/100

porsager/postgres#1189 · Opened Aug 9, 2026
Transaction-local queued queries never settle when the reserved connection closes Open

Difficulty 4/5 3-5 days Newbie friendliness 68/100

porsager/postgres#1186 · 1 comment · Opened Aug 7, 2026
Bigint values are converted to string in JSON Open

Difficulty 3/5 1-2 days Newbie friendliness 55/100

porsager/postgres#1182 · 1 comment · Opened Jul 19, 2026
Pipelined query resolves with a sparse result array when the previous query errors mid-stream (`rows` counter not reset on ErrorResponse) Open

Difficulty 2/5 1-3 hours Newbie friendliness 75/100

porsager/postgres#1181 · 2 comments · 1 reaction · Opened Jul 16, 2026
Failed connection establishment retries with no backoff and stampedes the whole pool (pathological against proxied/serverless Postgres) Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

porsager/postgres#1179 · 1 comment · Opened Jul 16, 2026
Types for "infinite" connection timer options Open

Difficulty 3/5 1-2 days Newbie friendliness 48/100

porsager/postgres#1178 · Opened Jul 15, 2026
Multi-host: `retries` never increments — prefer-standby loops forever, all-hosts-down hangs queries Open

Difficulty 4/5 3-5 days Newbie friendliness 55/100

porsager/postgres#1174 · 2 comments · Opened Jun 12, 2026
Failed COPY FROM STDIN never settles the writable, skips ROLLBACK in sql.begin(), and permanently leaks the connection as 'idle in transaction (aborted)' Open

Difficulty 4/5 3-5 days Newbie friendliness 48/100

porsager/postgres#1173 · 2 comments · Opened Jun 12, 2026
Add `TracingChannel` for observability Open

Difficulty 5/5 Over a week Newbie friendliness 35/100

porsager/postgres#1171 · 2 comments · 5 reactions · Opened Jun 2, 2026
`.cursor()` async iterator swallows error when promise rejects between resolution of batch `n` and requesting batch `n+1` Open

Difficulty 3/5 1-2 days Newbie friendliness 58/100

porsager/postgres#1166 · Opened Apr 23, 2026
Feature request: Static array types with fetch_types false Open

Difficulty 4/5 3-5 days Newbie friendliness 45/100

porsager/postgres#1164 · 1 reaction · Opened Apr 10, 2026
error TS2345: Argument of type 'TransactionSql<{}>' is not assignable to parameter of type 'Sql<{}>' Open

Typescript

Difficulty 3/5 1-2 days Newbie friendliness 55/100

porsager/postgres#1163 · 15 comments · Opened Apr 7, 2026
Missing TypeScript type for `sslnegotiation` option Open

Difficulty 1/5 Under an hour Newbie friendliness 55/100

porsager/postgres#1158 · 2 reactions · Opened Mar 5, 2026
`DELETE ... RETURNING` result not camel cased Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

porsager/postgres#1157 · Opened Mar 5, 2026
Error when attempting to write to a null socket Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

porsager/postgres#1154 · 2 comments · 2 reactions · Opened Jan 26, 2026
Use a fractions for sql numeric Open

Difficulty 5/5 Over a week Newbie friendliness 20/100

porsager/postgres#1153 · Opened Jan 20, 2026
Migration tools in readme are all outdated (no update last 2 years) Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

porsager/postgres#1151 · Opened Jan 19, 2026
The type ‘TransactionSql<{}>’ has no call signature. Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

porsager/postgres#1150 · 5 comments · 13 reactions · Opened Jan 19, 2026
[BUG] `str.replace is not a function` with 2 `values` CTEs Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

porsager/postgres#1149 · Opened Jan 16, 2026
Improved errorhandling Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

porsager/postgres#1140 · 2 comments · 1 reaction · Opened Dec 15, 2025
JSONB double-encoding when used with Drizzle ORM Open

Difficulty 3/5 1-2 days Newbie friendliness 52/100

porsager/postgres#1139 · 3 comments · 2 reactions · Opened Dec 14, 2025
Missing documentation on how to handle refcursors Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

porsager/postgres#1134 · 1 comment · Opened Nov 28, 2025
Uncatchable exception on idle in transcation timeout Open

Difficulty 4/5 3-5 days Newbie friendliness 45/100

porsager/postgres#1133 · 1 comment · 2 reactions · Opened Nov 24, 2025
Improve error handling documentation and TypeScript support Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

porsager/postgres#1132 · Opened Nov 24, 2025
Changelog not updated since long Open

Difficulty 2/5 1-3 hours Newbie friendliness 35/100

porsager/postgres#1131 · 1 comment · 1 reaction · Opened Oct 29, 2025
BUG: If a query fails, it never ends Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

porsager/postgres#1130 · 1 reaction · Opened Oct 17, 2025
Custom type handling does not work as documented Open

Difficulty 3/5 1-2 days Newbie friendliness 42/100

porsager/postgres#1129 · 2 reactions · Opened Oct 14, 2025
JSONB field name incorrectly handled by `sql()` Open

Difficulty 3/5 1-2 days Newbie friendliness 42/100

porsager/postgres#1126 · 2 comments · Opened Oct 10, 2025
nulls in result of array_agg are parsed to the string literal 'NULL' rather than the JS null Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

porsager/postgres#1124 · 1 reaction · Opened Oct 9, 2025
invalid query results: rows count not cleared after partially streamed query fails on the same connection Open

Difficulty 3/5 1-2 days Newbie friendliness 70/100

porsager/postgres#1119 · 1 comment · 4 reactions · Opened Oct 2, 2025
Deferred constraint errors not properly detected Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

porsager/postgres#1117 · Opened Sep 26, 2025
Fetch custom type oids - use case: pgvector extension Open

Difficulty 4/5 3-5 days Newbie friendliness 52/100

porsager/postgres#1115 · 1 comment · 2 reactions · Opened Sep 22, 2025
Any way to run a safe query? Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

porsager/postgres#1114 · Opened Sep 21, 2025
Using type for unknown instead of any Open

Difficulty 2/5 1-3 hours Newbie friendliness 48/100

porsager/postgres#1113 · 1 reaction · Opened Sep 21, 2025

porsager/postgres

Get new issues in your inbox