postgres

• 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

https://github.com/porsager/postgres/compare/v3.4.3...v3.4.4

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

https://github.com/porsager/postgres/compare/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

https://github.com/porsager/postgres/compare/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

https://github.com/porsager/postgres/compare/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

https://github.com/porsager/postgres/compare/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