Asyncpg

Minor fixes and improvements.

Improvements
============

* Python 3.12 and PostgreSQL 16 support (1084)
(by elprans in deea86ce)

* Add support for tuple-format custom codecs on composite types (1061)
(by elprans in 922fcd10)

* Support `target_session_attrs` in URL format, add tests (1073)
(by elprans in 7cb4e70d)

* Infinity numeric support (1067)
(by krokoziabla in 0c3bf600 for 1020)

* Add support for the `WHERE` clause in `copy_to` methods (941)
(by kaylynn234 in b7ffab6c)

* Add query logging callbacks and context manager (1043)
(by dcwatson in b2697ffd)

Fixes
=====

* When prepared statements are disabled, avoid relying on them harder (1065)
(by elprans in cbf64e18)

* Handle environments with HOME set to a not-a-directory (1063)
(by elprans in af922bcf)

* Fix handling of non-ASCII passwords (1062)
(by elprans in 89d5bd03)

* Disable JIT while doing type introspection (1082)
(by elprans in f21ebf64)

* Remove connection parameter caching in `Pool` (1053)
(by ermakov-oleg in 4ddb0397)

* Switch to Python 3.12-style `wait_for` (1086)
(by elprans in 4bdd8a7e)

* Update automatic PostGIS type conversion for Shapely 2.0 (1085)
(by ChimneySwift in 8b45beb4)

* Use the `timeout` context manager in the connection path (1087)
(by elprans in 313b2b2b)

* Small fix for documentation on using SSL in Connection (995)
(by ScottFred in ccc7baf9)

* Use cleanup_ctx in pool usage doc (878)
(by ir4y in 70c8bd81)

* Close cursor portals once the iterator is exhausted (1088)
(by elprans in ca9f03be)

* Cut BaseProtocol circular reference on close. (1049)
(by pteromys in 93a6f79a)

* Allow passing hosts as tuples to `connect()` (in addition to lists) (1021)
(by lezram in d7faaff5)

Other
=====

* Drop support for Python 3.7 (1064)
(by bryanforbes in 87ab1431)

Minor fixes and improvements.

Changes
=======

* Do not try to cleanup statements (981)
(by fvannee in d2e710fe for 981)

* Add Pool.is_closing() method (973)
(by singingwolfboy in 9cb2c1ce for 973)

* Fix test_tls_version for LibreSSL (974)
(by CyberTailor in 7df9812a for 974)

* Handle environments without home dir (1011)
(by LeonardBesson in 172b8f69 for 1011)

* fix: salt and iterations parsing for scram (1026)
(by trigonometr in 7443a9e7 for 1026)

* Add support for target_session_attrs (987)
(by JesseDeLoore in bf74e88b for 987)

* Add support for READ UNCOMMITTED (1039)
(by benwah in 2f20bae7 for 1039)

* Update benchmarks, add psycopg3 (1042)
(by elprans in 7d4fcf04 for 1042)

Support Python 3.11 and PostgreSQL 15. This release also drops support
for Python 3.6.

Changes
=======

* Add arm64 mac and linux wheels
(by ddelange in 7bd6c49f for 954)

* Add Python 3.11 to the test matrix
(by elprans in 5f908e67 for 948)

* Exclude .venv from flake8 (958)
(by jparise in 40b16ea6 for 958)

* Upgrade to flake8 5.0.4 (from 3.9.2) (961)
(by jparise in 0e73fec2 for 961)

* Show an example of a custom Record class (960)
(by jparise in 84c99bfd for 960)

* Use the exact type name in Record.__repr__ (959)
(by jparise in eccdf61a for 959)

* Drop Python 3.6 support (940)
(by bryanforbes in bb0cb39d for 940)

* Test on Python 3.11 and PostgreSQL 15, fix workflow deprecations (968)
(by elprans in eab7fdf2 for 968)

Changes
-------

* Add support to use awaitable object in password function. (889)
(by kwarunek in fb3b6bf7 for 889)

* Support direct TLS connections (i.e. no STARTTLS) (923)
(by jackwotherspoon in f2a937d2 for 923)

Fixes
-----

* Fix invalid `pyproject.toml` (900)
(by Rongronggg9 in eddb649c for 900)

* Add `record_class` parameter Pool.fetch and Pool.fetchrow (896)
(by baltitenger in 2519cf38 for 896)

* Domain basetypes are introspected (886) (887)
(by QuantumTM in cca4a2d3 for 886)

* Properly handle exceptions raised while handling server auth messages (862)
(by elprans in bd192623 for 862)

Changes
-------

* Improve SSL option compatibility in URIs
(by fantix in 383c711e for 827)

* Add `Pool` methods to determine its min, max, current and idle size
(by elprans in 603e3868 for 849)

* Make it possible to specify a statement name in `Connection.prepare()`
(by elprans in 03a3d18f for 846)

* Implement support for `multirange` types
(by elprans in d64a44a1 for 851)

Fixes
-----

* Make sure timeout callbacks always get cleaned up
(by elprans in dad26913 for 831)

* Update `__all__` statements to a simpler form that is better supported by typecheckers
(by bschnurr in 0a3ae7f5 for 828)

* Fix `test_timetz_encoding` on Python 3.10
(by elprans in 3a90fef0)

* Fix a bunch of `ResourceWarnings` in the test suite
(by elprans in 2f4fe539)

* Fix `SSLContext` deprecation warnings
(by elprans in 4d39a052)

* Fix the description of the database argument to `connect()`
(by elprans in a2a92374 for 847)

* Fix parsing of IPv6 addresses in the connection URI
(by elprans in f900b737 for 845)

* Improve diagnostics of invalid `executemany()` input
(by elprans in a8fc21e0 for 848)

Changes
-------

* Drop support for Python 3.5 (777)
(by and-semakin in da58cd26 for 777)

* Add support for Python 3.10 (795)
(by elprans in abf55699 for 795)

* Add support for asynchronous iterables to `copy_records_to_table()` (713)
(by elprans in 1d33ff62 for 713)

* Add support for coroutine functions as listener callbacks (802)
(by elprans in 41da093e for 802)

* Add support for sslcert, sslkey and sslrootcert parameters to DSN (768)
(by jdobes and elprans in c674e86a for 768)

* Add copy_ wrappers to Pool (661)
(by elprans in a6b0f283 for 661)

* Add issubset and issuperset methods to the Range type (563)
(by kdorsel in de07d0ab for 563)

Fixes
-----

* Break connection internal circular reference (774)
(by fantix in d08a9b8b for 774)

* Make Server Version Extraction More Flexible (778)
(by Natrinicle in d0761694 for 778)