Skip to content

Latest commit

 

History

History
141 lines (116 loc) · 6.32 KB

CHANGELOG.md

File metadata and controls

141 lines (116 loc) · 6.32 KB
Raw

Changelog

v3.2.4 - 25 May 2022

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

v3.2.3 - 23 May 2022

  • 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

v3.2.2 - 15 May 2022

  • Properly handle errors thrown on commit 99ddae4

v3.2.1 - 15 May 2022

  • Exclude target_session_attrs from connection obj 43f1442

v3.2.0 - 15 May 2022

  • 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

v3.1.0 - 22 Apr 2022

  • 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

v3.0.6 - 19 Apr 2022

  • Properly close connections in Deno cbc6a75
  • Only write end message if socket is open 13950af
  • Improve query cancellation 01c2c68
  • Use monotonically increasing time for timeout - fixes #316 9d7a21d
  • Add support for dynamic columns with returning - fixes #317 04644c0
  • Fix type errors in TypeScript deno projects (#313) 822fb21
  • Execute forEach instantly 44e9fbe

v3.0.5 - 6 Apr 2022

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

v3.0.4 - 5 Apr 2022

  • Ensure drain only dequeues if ready - fixes #303 2e5f017

v3.0.3 - 4 Apr 2022

  • 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

v3.0.2 - 31 Mar 2022

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

v3.0.1 - 30 Mar 2022

  • Improve connection queue handling + fix leak cee1a57
  • Use publications option - fixes #295 b5ceecc
  • 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

v3.0.0 - 24 Mar 2022

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

v1.0.2 - 21 Jan 2020

  • 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

v1.0.1 - 3 Jan 2020

  • 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

v1.0.0 - 22 Dec 2019

  • Initial release