Closed renovate[bot] closed 2 months ago
stale[bot]
commented
3 months ago This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.
renovate[bot]
commented
2 months ago Because you closed this PR without merging, Renovate will ignore this update (8.12.0). You will get a PR once a newer version is released. To ignore this dependency forever, add it to the ignoreDeps array of your Renovate config.
If you accidentally closed this PR, or if you changed your mind: rename this PR to get a fresh replacement PR.
This PR contains the following updates:
8.7.1->8.12.0Release Notes
brianc/node-postgres (pg)
### [`v8.12.0`](https://togithub.com/brianc/node-postgres/blob/HEAD/CHANGELOG.md#pg8120) [Compare Source](https://togithub.com/brianc/node-postgres/compare/pg@8.11.6...pg@8.12.0) - Add `queryMode` config option to [force use of the extended query protocol](https://togithub.com/brianc/node-postgres/pull/3214) on queries without any parameters. ### [`v8.11.6`](https://togithub.com/brianc/node-postgres/compare/pg@8.11.5...pg@8.11.6) [Compare Source](https://togithub.com/brianc/node-postgres/compare/pg@8.11.5...pg@8.11.6) ### [`v8.11.5`](https://togithub.com/brianc/node-postgres/compare/pg@8.11.4...pg@8.11.5) [Compare Source](https://togithub.com/brianc/node-postgres/compare/pg@8.11.4...pg@8.11.5) ### [`v8.11.4`](https://togithub.com/brianc/node-postgres/compare/pg@8.11.3...b03c071d2d15af259e1e008e9628191c865e58fa) [Compare Source](https://togithub.com/brianc/node-postgres/compare/pg@8.11.3...pg@8.11.4) ### [`v8.11.3`](https://togithub.com/brianc/node-postgres/compare/pg@8.11.2...pg@8.11.3) [Compare Source](https://togithub.com/brianc/node-postgres/compare/pg@8.11.2...pg@8.11.3) ### [`v8.11.2`](https://togithub.com/brianc/node-postgres/compare/pg@8.11.1...pg@8.11.2) [Compare Source](https://togithub.com/brianc/node-postgres/compare/pg@8.11.1...pg@8.11.2) ### [`v8.11.1`](https://togithub.com/brianc/node-postgres/compare/pg@8.11.0...pg@8.11.1) [Compare Source](https://togithub.com/brianc/node-postgres/compare/pg@8.11.0...pg@8.11.1) ### [`v8.11.0`](https://togithub.com/brianc/node-postgres/compare/pg@8.10.0...pg@8.11.0) [Compare Source](https://togithub.com/brianc/node-postgres/compare/pg@8.10.0...pg@8.11.0) ### [`v8.10.0`](https://togithub.com/brianc/node-postgres/blob/HEAD/CHANGELOG.md#pg-pool8100) [Compare Source](https://togithub.com/brianc/node-postgres/compare/pg@8.9.0...pg@8.10.0) - Emit `release` event when client is returned to [the pool](https://togithub.com/brianc/node-postgres/pull/2845). ### [`v8.9.0`](https://togithub.com/brianc/node-postgres/blob/HEAD/CHANGELOG.md#pg890) [Compare Source](https://togithub.com/brianc/node-postgres/compare/pg@8.8.0...pg@8.9.0) - Add support for [stream factory](https://togithub.com/brianc/node-postgres/pull/2898). - [Better errors](https://togithub.com/brianc/node-postgres/pull/2901) for SASL authentication. - [Use native crypto module](https://togithub.com/brianc/node-postgres/pull/2815) for SASL authentication. ### [`v8.8.0`](https://togithub.com/brianc/node-postgres/blob/HEAD/CHANGELOG.md#pg880) [Compare Source](https://togithub.com/brianc/node-postgres/compare/pg@8.7.3...pg@8.8.0) - Bump minimum required version of [native bindings](https://togithub.com/brianc/node-postgres/pull/2787). - Catch previously uncatchable errors thrown in [`pool.query`](https://togithub.com/brianc/node-postgres/pull/2569). - Prevent the pool from blocking the event loop if all clients are [idle](https://togithub.com/brianc/node-postgres/pull/2721) (and `allowExitOnIdle` is enabled). - Support `lock_timeout` in [client config](https://togithub.com/brianc/node-postgres/pull/2779). - Fix errors thrown in callbacks from [interfering with cleanup](https://togithub.com/brianc/node-postgres/pull/2753). ##### pg-pool@3.5.0 - Add connection [lifetime limit](https://togithub.com/brianc/node-postgres/pull/2698) config option. ##### pg@8.7.0 - Add optional config to [pool](https://togithub.com/brianc/node-postgres/pull/2568) to allow process to exit if pool is idle. ##### pg-cursor@2.7.0 - Convert to [es6 class](https://togithub.com/brianc/node-postgres/pull/2553) - Add support for promises [to cursor methods](https://togithub.com/brianc/node-postgres/pull/2554) ##### pg@8.6.0 - Better [SASL](https://togithub.com/brianc/node-postgres/pull/2436) error messages & more validation on bad configuration. - Export [DatabaseError](https://togithub.com/brianc/node-postgres/pull/2445). - Add [ParameterDescription](https://togithub.com/brianc/node-postgres/pull/2464) support to protocol parsing. - Fix typescript [typedefs](https://togithub.com/brianc/node-postgres/pull/2490) with `--isolatedModules`. ##### pg-query-stream@4.0.0 - Library has been [converted](https://togithub.com/brianc/node-postgres/pull/2376) to Typescript. The behavior is identical, but there could be subtle breaking changes due to class names changing or other small inconsistencies introduced by the conversion. ##### pg@8.5.0 - Fix bug forwarding [ssl key](https://togithub.com/brianc/node-postgres/pull/2394). - Convert pg-query-stream internals to [typescript](https://togithub.com/brianc/node-postgres/pull/2376). - Performance [improvements](https://togithub.com/brianc/node-postgres/pull/2286). ##### pg@8.4.0 - Switch to optional peer dependencies & remove [semver](https://togithub.com/brianc/node-postgres/commit/a02dfac5ad2e2abf0dc3a9817f953938acdc19b1) package which has been a small thorn in the side of a few users. - Export `DatabaseError` from [pg-protocol](https://togithub.com/brianc/node-postgres/commit/58258430d52ee446721cc3e6611e26f8bcaa67f5). - Add support for `sslmode` in the [connection string](https://togithub.com/brianc/node-postgres/commit/6be3b9022f83efc721596cc41165afaa07bfceb0). ##### pg@8.3.0 - Support passing a [string of command line options flags](https://togithub.com/brianc/node-postgres/pull/2216) via the `{ options: string }` field on client/pool config. ##### pg@8.2.0 - Switch internal protocol parser & serializer to [pg-protocol](https://togithub.com/brianc/node-postgres/tree/master/packages/pg-protocol). The change is backwards compatible but results in a significant performance improvement across the board, with some queries as much as 50% faster. This is the first work to land in an on-going performance improvment initiative I'm working on. Stay tuned as things are set to get much faster still! :rocket: ##### pg-cursor@2.2.0 - Switch internal protocol parser & serializer to [pg-protocol](https://togithub.com/brianc/node-postgres/tree/master/packages/pg-protocol). The change is backwards compatible but results in a significant performance improvement across the board, with some queries as much as 50% faster. ##### pg-query-stream@3.1.0 - Switch internal protocol parser & serializer to [pg-protocol](https://togithub.com/brianc/node-postgres/tree/master/packages/pg-protocol). The change is backwards compatible but results in a significant performance improvement across the board, with some queries as much as 50% faster. ##### pg@8.1.0 - Switch to using [monorepo](https://togithub.com/brianc/node-postgres/tree/master/packages/pg-connection-string) version of `pg-connection-string`. This includes better support for SSL argument parsing from connection strings and ensures continuity of support. - Add `&ssl=no-verify` option to connection string and `PGSSLMODE=no-verify` environment variable support for the pure JS driver. This is equivalent of passing `{ ssl: { rejectUnauthorized: false } }` to the client/pool constructor. The advantage of having support in connection strings and environment variables is it can be "externally" configured via environment variables and CLI arguments much more easily, and should remove the need to directly edit any application code for [the SSL default changes in 8.0](https://node-postgres.com/announcements#2020-02-25). This should make using `pg@8.x` significantly less difficult on environments like Heroku for example. ##### pg-pool@3.2.0 - Same changes to `pg` impact `pg-pool` as they both use the same connection parameter and connection string parsing code for configuring SSL. ##### pg-pool@3.1.0 - Add [maxUses](https://togithub.com/brianc/node-postgres/pull/2157) config option. ##### pg@8.0.0 ##### note: for detailed release notes please [check here](https://node-postgres.com/announcements#2020-02-25) - Remove versions of node older than `6 lts` from the test matrix. `pg>=8.0` may still work on older versions but it is no longer officially supported. - Change default behavior when not specifying `rejectUnauthorized` with the SSL connection parameters. Previously we defaulted to `rejectUnauthorized: false` when it was not specifically included. We now default to `rejectUnauthorized: true.` Manually specify `{ ssl: { rejectUnauthorized: false } }` for old behavior. - Change [default database](https://togithub.com/brianc/node-postgres/pull/1679) when not specified to use the `user` config option if available. Previously `process.env.USER` was used. - Change `pg.Pool` and `pg.Query` to [be](https://togithub.com/brianc/node-postgres/pull/2126) an [es6 class](https://togithub.com/brianc/node-postgres/pull/2063). - Make `pg.native` non enumerable. - `notice` messages are [no longer instances](https://togithub.com/brianc/node-postgres/pull/2090) of `Error`. - Passwords no longer [show up](https://togithub.com/brianc/node-postgres/pull/2070) when instances of clients or pools are logged. ##### pg@7.18.0 - This will likely be the last minor release before pg@8.0. - This version contains a few bug fixes and adds a deprecation warning for [a pending change in 8.0](https://togithub.com/brianc/node-postgres/issues/2009#issuecomment-579371651) which will flip the default behavior over SSL from `rejectUnauthorized` from `false` to `true` making things more secure in the general use case. ##### pg-query-stream@3.0.0 - [Rewrote stream internals](https://togithub.com/brianc/node-postgres/pull/2051) to better conform to node stream semantics. This should make pg-query-stream much better at respecting [highWaterMark](https://nodejs.org/api/stream.html#stream_new_stream_readable_options) and getting rid of some edge case bugs when using pg-query-stream as an async iterator. Due to the size and nature of this change (effectively a full re-write) it's safest to bump the semver major here, though almost all tests remain untouched and still passing, which brings us to a breaking change to the API.... - Changed `stream.close` to `stream.destroy` which is the [official](https://nodejs.org/api/stream.html#stream_readable_destroy_error) way to terminate a readable stream. This is a **breaking change** if you rely on the `stream.close` method on pg-query-stream...though should be just a find/replace type operation to upgrade as the semantics remain very similar (not exactly the same, since internals are rewritten, but more in line with how streams are "supposed" to behave). - Unified the `config.batchSize` and `config.highWaterMark` to both do the same thing: control how many rows are buffered in memory. The `ReadableStream` will manage exactly how many rows are requested from the cursor at a time. This should give better out of the box performance and help with efficient async iteration. ##### pg@7.17.0 - Add support for `idle_in_transaction_session_timeout` [option](https://togithub.com/brianc/node-postgres/pull/2049). ##### 7.16.0 - Add optional, opt-in behavior to test new, [faster query pipeline](https://togithub.com/brianc/node-postgres/pull/2044). This is experimental, and not documented yet. The pipeline changes will grow significantly after the 8.0 release. ##### 7.15.0 - Change repository structure to support lerna & future monorepo [development](https://togithub.com/brianc/node-postgres/pull/2014). - [Warn about deprecation](https://togithub.com/brianc/node-postgres/pull/2021) for calling constructors without `new`. ##### 7.14.0 - Reverts 7.13.0 as it contained [an accidental breaking change](https://togithub.com/brianc/node-postgres/pull/2010) for self-signed SSL cert verification. 7.14.0 is identical to 7.12.1. ##### 7.13.0 - Add support for [all tls.connect()](https://togithub.com/brianc/node-postgres/pull/1996) options. ##### 7.12.0 - Add support for [async password lookup](https://togithub.com/brianc/node-postgres/pull/1926). ##### 7.11.0 - Add support for [connection_timeout](https://togithub.com/brianc/node-postgres/pull/1847/files#diff-5391bde944956870128be1136e7bc176R63) and [keepalives_idle](https://togithub.com/brianc/node-postgres/pull/1847). ##### 7.10.0 - Add support for [per-query types](https://togithub.com/brianc/node-postgres/pull/1825). ##### 7.9.0 - Add support for [sasl/scram authentication](https://togithub.com/brianc/node-postgres/pull/1835). ##### 7.8.0 - Add support for passing [secureOptions](https://togithub.com/brianc/node-postgres/pull/1804) SSL config. - Upgrade [pg-types](https://togithub.com/brianc/node-postgres/pull/1806) to 2.0. ##### 7.7.0 - Add support for configurable [query timeout](https://togithub.com/brianc/node-postgres/pull/1760) on a client level. ##### 7.6.0 - Add support for ["bring your own promise"](https://togithub.com/brianc/node-postgres/pull/1518) ##### 7.5.0 - Better [error message](https://togithub.com/brianc/node-postgres/commit/11a4793452d618c53e019416cc886ad38deb1aa7) when passing `null` or `undefined` to `client.query`. - Better [error handling](https://togithub.com/brianc/node-postgres/pull/1503) on queued queries. ##### 7.4.0 - Add support for [Uint8Array](https://togithub.com/brianc/node-postgres/pull/1448) values. ##### 7.3.0 - Add support for [statement timeout](https://togithub.com/brianc/node-postgres/pull/1436). ##### 7.2.0 - Pinned pg-pool and pg-types to a tighter semver range. This is likely not a noticeable change for you unless you were specifically installing older versions of those libraries for some reason, but making it a minor bump here just in case it could cause any confusion. ##### 7.1.0 ##### Enhancements - [You can now supply both a connection string and additional config options to clients.](https://togithub.com/brianc/node-postgres/pull/1363) ##### 7.0.0 ##### Breaking Changes - Drop support for node < `4.x`. - Remove `pg.connect` `pg.end` and `pg.cancel` singleton methods. - `Client#connect(callback)` now returns `undefined`. It used to return an event emitter. - Upgrade [pg-pool](https://togithub.com/brianc/node-pg-pool) to `2.x`. - Upgrade [pg-native](https://togithub.com/brianc/node-pg-native) to `2.x`. - Standardize error message fields between JS and native driver. The only breaking changes were in the native driver as its field names were brought into alignment with the existing JS driver field names. - Result from multi-statement text queries such as `SELECT 1; SELECT 2;` are now returned as an array of results instead of a single result with 1 array containing rows from both queries. [Please see here for a migration guide](https://node-postgres.com/guides/upgrading) ##### Enhancements - Overhauled documentation:Configuration
📅 Schedule: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined).
🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.
♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about this update again.
This PR was generated by Mend Renovate. View the repository job log.