2.12.2 - Enable libpq-compatible "postgresql" URL schemes

What's Changed

Enable libpq-compatible "postgresql" URL schemes by @gwynne in #251

For libpq compatibility, the following additional schemes are now accepted in database URLs:

• "postgresql"
• "postgresql+tcp"
• "postgresql+uds"

Reviewers

Thanks to the reviewers for their help:

• @MahdiBM

This patch was released by @gwynne

Full Changelog: 2.12.1...2.12.2

2.12.1 - Remove use of legacy codepath when establishing Postgres connections

What's Changed

Remove use of legacy codepath when establishing Postgres connections by @gwynne in #249

Also tidies CI as usual.

Reviewers

Thanks to the reviewers for their help:

• @MahdiBM

This patch was released by @gwynne

Full Changelog: 2.12.0...2.12.1

2.12.0 - Support the sslmode URL query parameter and UDS URLs

What's Changed

Support the sslmode URL query parameter and UDS URLs by @gwynne in #248

Overhauls the URL parser for connection configurations to accept considerably more flexible syntax. See the documentation for details of the new syntax. (A screenshot of the new documentation is included below in case the website doesn’t update immediately.)

Reviewers

Thanks to the reviewers for their help:

• @0xTim

This patch was released by @gwynne.

Full Changelog: 2.11.4...2.12.0

2.11.4 - Add Postgres support for nested subpath (JSON) expressions

This patch was authored and released by @gwynne.

Implements SQLKit's new SQLDialect.nestedSubpathExpression(in:for:) method. #246

Remove the temporary workaround for PSQLError descriptions

This patch was authored and released by @gwynne.

The workaround didn't work very well anyway (I got it slightly wrong), and thanks to vapor/postgres-nio#372 is no longer needed at all.

This reverts #244, commit 875e8c1.

Temporary bandaid workaround for lack of PSQLError usefulness

This patch was authored and released by @gwynne.

This is a temporary workaround while waiting for vapor/postgres-nio#360 to be finished.

Add workaround for decoding `NUMERIC` as `Double`

This patch was authored and released by @gwynne.

The PostgresData implementation allowed this, and it's a halfway reasonable code path, so support it at the driver level.

Remove all use of deprecated PostgresNIO APIs

This patch was authored and released by @gwynne.

This is a major cleanup pass that deprecates PostgresDataEncoder, PostgresDataDecoder, and PostgresConfiguration in favor of working with the newer, better-designed APIs now available from PostgresNIO. As a side effect of this work, the minimum Swift version has been bumped to 5.7.

Every effort has been made to maintain backwards-compatible behavior whenever possible.

Require PostgresNIO 1.14.2 for CVE-2023-31136 fix

This patch was authored and released by @gwynne.

Update min Swift version to 5.6 and make platform versions consistent

This patch was authored and released by @gwynne.