postgres

• Fix reserved queries failing on connect e34826d

v3.4.6...v3.4.7

• Fix failures in sql.reserve() connect shadowing real errors e8bb3b8
• Fix stuck queries on non busy connections 76c13f2
• Ensure non object errors thrown are handled properly a39dfef
• Fixed typings for generic error code variants ad0ed44
• support env.PGAPPNAME and env.PGUSERNAME ef7afdb 9f38ea1

v3.4.5...v3.4.6

• Fix for deno 2 5fb70c1
• Don't reassign to errors 4baef5e, f58cd4f
• Remove "worker" export as we now have "workerd" for cloudflare cc688c6

v3.4.4...v3.4.5

• Ensure retryRoutines are only used for prepared statements - fixes #830 3e28f3a
• update lsn on Primary Keep Alive Message a5cd811
• add subscribe onerror handler 3e3d5e8
• Patch: Connection stuck after a while (#738) 6f20a48

v3.4.3...v3.4.4

• Ensure reserved connections are initialized properly - fixes #718 c084a1c

v3.4.2...v3.4.3

• Ensure transactions throw if connection is closed while there is no active query - fixes #658 788c819
• Fix race conditions in auth startup - fixes #430 #668 33ae0ed
• adding support for sslrootcert option in connection string (#690) 0bee4c3
• Keep query error instead of creating creating new object (#698) f2fb819
• Add common parameter names to ConnectionParameters TS type (#707) ca2754c

v3.4.1...v3.4.2

• set "types" exports first as ts 4.7 requirement (#709) 00dd98a
• Ensure bun imports esm instead of cf worker - fixes #692 c1d8519
• Update Cloudflare createHash polyfill to support md5 and hex encoding 09e6cb5

v3.4.0...v3.4.1

• Add Support for Cloudflare Workers & Pages (#599) b88e261
• Add sql.reserve method 7f6e0cc
• Add sql.prepare(name) to allow custom names (#628) 8f6f4e3
• Allow for incomplete custom types 1df4286
• Allow array of Fragments in ParameterOrFragment 82908d3
• Allow a falsy url string e4b158b
• Fix crash on errors in logical streaming, but log and reconnect a4bf5fa
• Fix #674 TypeScript issues with dynamic inserts 5f569d8
• Fix connection on deno 1.36.3 (#673) bf082a5
• Fix replica identity changes when using subscribe 087c414
• Fix a bun issue with stack traces cae4d97
• Ensure number options are coerced from string - fixes #622 ba498fd
• Support notify for transactions and reserved connections as well. fixes #611 0dac913
• Use select helper inside parenthesis c2fe67b

v3.3.5...v3.4.0

• feat: use ; as a delimiter for _box 26d08c8
• feat: don't override array type if already exists 62a23bb
• Document sql.unsafe query fragments (#567) c9ded40
• Ensure queries are not pushed on connections with active cursors - fixes #411 4f987d5

https://github.com/porsager/postgres/compare/v3.3.4...v3.3.5

• Set servername on tls connect - fixes #543 498f2ae
• fix: unlisten channel names with period (#550) df0343d
• Fallback to escaping multiple identifiers if no builder found - fixes #532 58aac20
• Use final string for simple statements too - fixes #532 c6bf6be

https://github.com/porsager/postgres/compare/v3.3.3...v3.3.4

• Fix connection uri encoding (#497) 4467d11
• Fix logic reversal for target_session_attrs=primary|standby 4aa19d1
• Fix transform function logic for deeply nested jsonb (#530) a848ca6
• Fix writing host and port on connection timeouts f93d0d4

https://github.com/porsager/postgres/compare/v3.3.2...v3.3.3

• Fix null json array transform error b153202
• Fix nested json array transform - fixes #506 5dea953
• Allow period in listen channel names - fix #495 a12108a

https://github.com/porsager/postgres/compare/v3.3.1...v3.3.2

• Fix listen after reconnect - fixes #490 52dfe9a

https://github.com/porsager/postgres/compare/v3.3.0...v3.3.1

• Fix subscribe stream close 19c9684
• Support transform in subscribe messages 4e28de9
• Prevent transform of columns when using subscribe - fixes #474 4ea4a59
• Add simple() - fixes #472 e1a21ad
• Add nested transforms (#460) 65dcf0d
• Fix query being executed when using describe on unsafe - fixes #424 3e47f0a
• Support empty arrays in dynamic in - fixes #417 85bca49
• expose table oid and column number (#409) 599d0e7
• Ensure listen doesn't reconnect if first connect throws edfa360
• Only call setKeepAlive if present - fixes #404 84583e0

Typescript related

• Minor typescript organization (#416) 9a61b9f
• Fix some undefined types issues (#447) 097d272
• Add typescript support for "exports" (#439) 3415278
• Add .values() typings - fixes #385 (#393) ac1bca4
• Remove dead code that breaks types - fixes #382 (#383) 218a7d4

https://github.com/porsager/postgres/compare/v3.2.4...v3.3.0

• Allow setting keep_alive: false bee62f3
• Fix support for null in arrays - fixes #371 b04c853

https://github.com/porsager/postgres/compare/v3.2.3...v3.2.4

• Fix Only use setKeepAlive in Deno if available 28fbbaf
• Fix wrong helper match on multiple occurances 02f3854

Typescript related

• Fix Deno assertRejects compatibility (#365) 0f0af92
• Fix include missing boolean type in JSONValue union (#373) 1817387

https://github.com/porsager/postgres/compare/v3.2.2...v3.2.3

• Properly handle errors thrown on commit 99ddae4

https://github.com/porsager/postgres/compare/v3.2.1...v3.2.2

• Exclude target_session_attrs from connection obj 43f1442

https://github.com/porsager/postgres/compare/v3.2.0...v3.2.1

• Add sslmode=verify-full support e67da29
• Add support for array of fragments 342bf55
• Add uri decode of host in url - fixes #346 1adc113
• Add passing of rest url params to connection (ootb support cockroach urls) 41ed84f
• Fix Deno partial writes 452a30d
• Fix as dynamic helper 3300c40
• Fix some nested fragments usage 9bfa902
• Fix missing columns on Result when using simple protocol - fixes #350 1e2e298
• Fix fragments in transactions - fixes #333 75914c7

Typescript related

• Upgrade/fix types (#357) 1e6d312
• Add optional onlisten callback to listen() on TypeScript (#360) 6b749b2
• Add implicit custom type inference (#361) 28512bf
• Fix and improve sql() helper types (#338) c1de3d8
• Fix update query type def for .writable() and .readable() to return promises (#347) 51269ce
• Add bigint to typescript Serializable - fixes #330 f1e41c3

https://github.com/porsager/postgres/compare/v3.1.0...v3.2.0

• Add close method to close but not end connections forever 94fea8f
• Add .values() method to return rows as arrays of values 56873c2
• Support transform.undefined - fixes #314 eab71e5
• Support nested fragments values and dynamics - fixes #326 86445ca
• Fix deno close sequence f76af24
• Fix subscribe reconnect and add onsubscribe method - fixes #315 5097345
• Deno ts fix - fixes #327 50403a1

https://github.com/porsager/postgres/compare/v3.0.6...v3.1.0

• Properly close connections in Deno 13950af
• Only write end message if open 408a2fb
• Improve query cancellation d69e264
• Use monotonically increasing time for timeout - fixes #316 04644c0
• Add support for dynamic columns with returning - fixes #317 822fb21
• Fix type errors in TypeScript deno projects (#313) 6a631b7
• Execute forEach instantly ea6ccd4

https://github.com/porsager/postgres/compare/v3.0.5...v3.0.6

• Fix transaction execution timing 28bb0b3
• Add optional onlisten function to listen 1dc2fd2
• Fix dynamic in helper after insert #305 4d63a59

https://github.com/porsager/postgres/compare/v3.0.4...v3.0.5

• Ensure drain only dequeues if ready - fixes #303 3f9118b

https://github.com/porsager/postgres/compare/v3.0.3...v3.0.4

• Run tests with github actions b536d0d
• Add custom socket option - fixes #284 5413f0c
• Fix sql function overload type inference (#294) 3c4e90a
• Update deno std to 0.132 and enable last tests 50762d4
• Send proper client-encoding - Fixes #288 e5b8554

https://github.com/porsager/postgres/compare/v3.0.2...v3.0.3

• Fix BigInt handling 36a70df
• Fix unsubscribing (#300) b6c597f
• Parse update properly with identity full - Fixes #296 3ed11e7

https://github.com/porsager/postgres/compare/v3.0.1...v3.0.2

• Improve connection queue handling + fix leak cee1a57
• Use publications option - fixes #295 b5ceecc
• Add types to debug signature dbb668c
• Throw proper query error if destroyed e148a0a
• Transaction rejects with rethrown error - fixes #289 f7c8ae6
• Only create origin stacktrace for tagged and debug - fixes #290 a782edf
• Include types and readme in deno release - fixes #287 9068820
• Disable fetch_types for Subscribe options 72e0cdb
• Update TypeScript types with v3 changes (#293) db05836

https://github.com/porsager/postgres/compare/v3.0.0...v3.0.1

This is a complete rewrite to better support all the features that I was trying to get into v2. There are a few breaking changes from v2 beta, which some (myself included) was using in production, so I'm skipping a stable v2 release and going straight to v3.

Here are some of the new things available, but check the updated docs.

• Dynamic query builder based on raw sql
• Realtime subscribe to db changes through logical replication
• Multi-host support for High Availability setups
• Postgres input parameter types from ParameterDescription
• Deno support
• Cursors as async iterators
• .describe() to only get query input types and column definitions
• Support for Large Objects
• max_lifetime for connections
• Cancellation of requests
• Converted to ESM (with CJS support)
• Typescript support (Credit @minigugus)

Breaking changes from v2 -> v3

• Cursors are always called with Result arrays (previously cursor 1 would return a row object, where > 1 would return an array of rows)
• .writable() and .readable() is now async (returns a Promise that resolves to the stream)
• Queries now returns a lazy promise instead of being executed immediately. This means the query won't be sent until awaited (.then, .catch, .finally is called) or until .execute() is manually called.
• .stream() is renamed to .forEach
• Returned results are now it's own Result class extending Array instead of an Array with extra properties (actually shouldn't be breaking unless you're doing something funny)
• Parameters are now cast using the types returned from Postgres ParameterDescription with a fallback to the previously inferred types
• Only tested with node v12 and up
• Implicit array value to multiple parameter expansion removed (use sql([...]) instead)

Breaking changes from v1 -> v2 (v2 never moved on from beta)

• All identifiers from sql() in queries are now always quoted
• Undefined parameters are no longer allowed
• Rename timeout option to idle_timeout
• Default to 10 connections instead of number of CPUs
• Numbers that cannot be safely cast to JS Number are returned as string. This happens for eg, select count(*) because count() returns a 64 bit integer (int8), so if you know your count() won't be too big for a js number just cast in your query to int4 like select count(*)::int

https://github.com/porsager/postgres/compare/v1.0.2...v3.0.0

• Add a changelog e4e8ee8

https://github.com/porsager/postgres/compare/v2.0.0-beta.11...v3.0.0-rc.3

• Fix race condition with transactions on end 315407e

https://github.com/porsager/postgres/compare/v3.0.0-rc.1...v3.0.0-rc.2

This is a complete rewrite to better support all the features that I was trying to get into v2. There are a few breaking changes from v2 beta , which some (myself included) are using in production, so I'm skipping a stable v2 release and going to v3.

Here are some of the new things available..

• Converted to ESM with CJS support
• Deno support
• Dynamic query builder based on raw sql
• Realtime subscribe to db changes through logical replication
• Cursors as async iterators
• Multi-host support for High Availability setups
• Postgres input parameter types from ParameterDescription
• .describe() to only get query input types and column definitions
• Support for Large Objects
• max_lifetime for connections
• Cancellation of requests

Breaking changes from v2 -> v3

• Cursors are always called with Result arrays (previously cursor 1 would return a row object, where > 1 would return an array of rows)
• .writable() and .readable() is now async (returns a Promise that resolves to the stream)
• Queries now returns a lazy promise instead of being executed immediately. This means the query won't be sent until awaited (.then, .catch, .finally is called) or until .execute() is manually called.
• .stream() is renamed to .forEach
• Returned results are now it's own Result class extending Array instead of an Array with extra properties (actually shouldn't be breaking unless you're doing something funny)
• Parameters are now cast using the types returned from Postgres ParameterDescription with a fallback to the previously inferred types
• Only tested with node v12 and up
• Implicit array value to multiple parameter expansion removed (use sql([...]) instead)

Breaking changes from v1 -> v2 (v2 never moved on from beta)

• All identifiers from sql() in queries are now always quoted
• Undefined parameters are no longer allowed
• Numbers that cannot be safely cast to JS Number are returned as string. This happens for eg, select count(*) because count() returns a 64 bit integer (int8), so if you know your count() won't be too big for a js number just cast in your query to int4 like select count(*)::int

https://github.com/porsager/postgres/compare/v2.0.0-beta.11...v3.0.0-rc.1

• Fix listen reconnect on connection errors + simple backoff 09592ea

https://github.com/porsager/postgres/compare/v2.0.0-beta.10...v2.0.0-beta.11

• Remove unnecessary portal and flush 06cc8e4

https://github.com/porsager/postgres/compare/v2.0.0-beta.9...v2.0.0-beta.10

• Subscribe to changes using logical replication (#220) 51d033c
• Fix #85 ce80061
• Fix slow parsing of large messages (#229) 2c3353b
• Expose PostgresError on module (#227) e954dba
• transform.column.to support (#212) a02de67

https://github.com/porsager/postgres/compare/v2.0.0-beta.8...v2.0.0-beta.9

• Call socket.write with correct arguments - fixes #216 f406426

https://github.com/porsager/postgres/compare/v2.0.0-beta.7...v2.0.0-beta.8

• Fix potential endless loop 8150005
• Recreate prepared statements if invalidated (#195) 591d47a
• Copy (#211) 8e675a3
• Add raw() method - fixes #194 (#196) 8b405b3
• Use correct SSL mode description (#210) 1e7713e
• Prevent obscuring errors when querying pg_catalog (#204) e3ace38
• Optionally disable fetching of array types. (#205) 779771a
• Fix return type definition f900c58

https://github.com/porsager/postgres/compare/v2.0.0-beta.6...v2.0.0-beta.7

• Use keepalive with 1 minute idle time 60c1f8e
• Include custom types when fetching array types. (#103) 174e4fd
• Make cursor work with unsafe - fixes #149 b15861d
• Properly throw initial cursor errors 1b7e9b9
• Include missing last set in cursor - fixes #150 #81 cea5f73
• Fix #188 Support escaping dynamic schemas and tables 2e3652b
• Handle disable and false sslmode url strings - fixes #177 0eff017
• Add support for prepared statements in sql.unsafe (#176) ae6c350

https://github.com/porsager/postgres/compare/v2.0.0-beta.5...v2.0.0-beta.6

• Feature: Add raw input property to error and debug parameters (#167) 9e83e7f
• Feature: Multihost support for High Availability setups (#158) 16bc7db
• Feature: Add unlisten support (#155) 6ef71c8
• Feature: Add sslmode prefer and require 0cb2981
• Fix: Catch connection errors in begin() (transactions) - fixes #162 fff6640
• Fix: Escaping columns for helpers and listen 00a10b2
• Fix: Properly cleanup sockets (#136) c5bfcf2

https://github.com/porsager/postgres/compare/v2.0.0-beta.4...v2.0.0-beta.5

• Better sql`` types (#84) f82d679
• Fallback to user for db name instead of 'postgres' - fixes #141 0b33b71

https://github.com/porsager/postgres/compare/v2.0.0-beta.3...v2.0.0-beta.4

• Fix parallel SCRAM-SHA-256 authentication (#145) 0709db4
• Expose the PostgresError type for TypeScript (#99) 4d5fdc1
• Fix type of timeout (#118) c2c0bf1

https://github.com/porsager/postgres/compare/v2.0.0-beta.2...v2.0.0-beta.3

• double precision can be represented safely as number in js 5e5ae5a
• Fix .end() hanging as pending forever a5daa3e
• Ensure end is called for connections not ready 219fa27
• Fix support for node 8 and 10 3f6bbab

https://github.com/porsager/postgres/compare/v2.0.0-beta.1...v2.0.0-beta.2

• Fix wrong api usage errors being swallowed a891603
• Fix connection config errors being swallowed 869ab9b
• Add no_prepare option - fixes #93 and #76 ce14949

https://github.com/porsager/postgres/compare/v2.0.0-beta.0...v2.0.0-beta.1

Potential Breaking changes

• Undefined values throws 758b5ee
• Treat postgres bigint as string by default 4958e80
• Default to 10 connections instead of number of cpus e61e8f4
• Don't force 1700 (numeric), postgres casts better - Fixes #41 844e7f2
• Fix unsafe queries wrongly making named prepared statements d354edf

Deprecated

• Rename timeout option to idle_timeout 90865cd

New

• Typescript support (#8) c55304e
• Add cursor support 4156c3f
• Better errors - include origin, query, parameters 7845fc7
• Update license to the Unlicense (#80) e8e86f8
• Add connect_timeout with a default of 30 seconds 2e01c2b
• Add columns to result - fixes #18 d89f824
• Add PostgresError type fc6804a
• Add async stack to end of error stack a74e015

Fixes

• Fix #49 and improve sql.array usage 22651e3
• Fix connection timeout leak 5e3fff8
• Fix stale connections after initial error 807f983
• Fetch os.username() optimistically - fixes #51 a519e18
• Fix some errors not throwing for current query 87b0943
• Fix CONNECTION_CLOSED false and no host + port if path is false 93ad859
• Fix end timeout race condition 60dc30f
• Register array types properly 7d3ce4b

https://github.com/porsager/postgres/compare/v1.0.2...v2.0.0-beta.0

• Fix standard postgres user env var (#20) cce5ad7
• Ensure url or options is not falsy bc549b0
• Add support for dynamic password b2ab9fb
• Fix hiding pass from options 3f76b98

https://github.com/porsager/postgres/compare/v1.0.1...v1.0.2

• Fix #3 url without db and trailing slash 45d4233
• Fix stream promise - resolve with correct result 730df2c
• Fix return value of unsafe query with multiple statements 748f198
• Fix destroy before connected f682ca1
• Fix params usage for file() call without options e4f12a4
• Various Performance improvements

https://github.com/porsager/postgres/compare/v1.0.0...v1.0.1

• Initial release