asyncpg v0.28.0 Minor fixes and improvements. Changes ======= * Do not try to cleanup statements (MagicStack#981) (by @fvannee in d2e710f for MagicStack#981) * Add Pool.is_closing() method (MagicStack#973) (by @singingwolfboy in 9cb2c1c for MagicStack#973) * Fix test_tls_version for LibreSSL (MagicStack#974) (by @CyberTailor in 7df9812 for MagicStack#974) * Handle environments without home dir (MagicStack#1011) (by @LeonardBesson in 172b8f6 for MagicStack#1011) * fix: salt and iterations parsing for scram (MagicStack#1026) (by @trigonometr in 7443a9e for MagicStack#1026) * Add support for target_session_attrs (MagicStack#987) (by @JesseDeLoore in bf74e88 for MagicStack#987) * Add support for READ UNCOMMITTED (MagicStack#1039) (by @benwah in 2f20bae for MagicStack#1039) * Update benchmarks, add psycopg3 (MagicStack#1042) (by @elprans in 7d4fcf0 for MagicStack#1042)

asyncpg v0.27.0 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 7bd6c49 for MagicStack#954) * Add Python 3.11 to the test matrix (by @elprans in 5f908e6 for MagicStack#948) * Exclude .venv from flake8 (MagicStack#958) (by @jparise in 40b16ea for MagicStack#958) * Upgrade to flake8 5.0.4 (from 3.9.2) (MagicStack#961) (by @jparise in 0e73fec for MagicStack#961) * Show an example of a custom Record class (MagicStack#960) (by @jparise in 84c99bf for MagicStack#960) * Use the exact type name in Record.__repr__ (MagicStack#959) (by @jparise in eccdf61 for MagicStack#959) * Drop Python 3.6 support (MagicStack#940) (by @bryanforbes in bb0cb39 for MagicStack#940) * Test on Python 3.11 and PostgreSQL 15, fix workflow deprecations (MagicStack#968) (by @elprans in eab7fdf for MagicStack#968)

asyncpg v0.26.0 Changes ------- * Add support to use awaitable object in password function. (MagicStack#889) (by @kwarunek in fb3b6bf for MagicStack#889) * Support direct TLS connections (i.e. no STARTTLS) (MagicStack#923) (by @jackwotherspoon in f2a937d for MagicStack#923) Fixes ----- * Fix invalid `pyproject.toml` (MagicStack#900) (by @Rongronggg9 in eddb649 for MagicStack#900) * Add `record_class` parameter Pool.fetch and Pool.fetchrow (MagicStack#896) (by @baltitenger in 2519cf3 for MagicStack#896) * Domain basetypes are introspected (MagicStack#886) (MagicStack#887) (by @QuantumTM in cca4a2d for MagicStack#886) * Properly handle exceptions raised while handling server auth messages (MagicStack#862) (by @elprans in bd19262 for MagicStack#862)

asyncpg v0.25.0 Changes ------- * Improve SSL option compatibility in URIs (by @fantix in 383c711 for MagicStack#827) * Add `Pool` methods to determine its min, max, current and idle size (by @elprans in 603e386 for MagicStack#849) * Make it possible to specify a statement name in `Connection.prepare()` (by @elprans in 03a3d18 for MagicStack#846) * Implement support for `multirange` types (by @elprans in d64a44a for MagicStack#851) Fixes ----- * Make sure timeout callbacks always get cleaned up (by @elprans in dad2691 for MagicStack#831) * Update `__all__` statements to a simpler form that is better supported by typecheckers (by @bschnurr in 0a3ae7f for MagicStack#828) * Fix `test_timetz_encoding` on Python 3.10 (by @elprans in 3a90fef) * Fix a bunch of `ResourceWarnings` in the test suite (by @elprans in 2f4fe53) * Fix `SSLContext` deprecation warnings (by @elprans in 4d39a05) * Fix the description of the database argument to `connect()` (by @elprans in a2a9237 for MagicStack#847) * Fix parsing of IPv6 addresses in the connection URI (by @elprans in f900b73 for MagicStack#845) * Improve diagnostics of invalid `executemany()` input (by @elprans in a8fc21e for MagicStack#848)

asyncpg v0.24.0 Changes ------- * Drop support for Python 3.5 (MagicStack#777) (by @and-semakin in da58cd2 for MagicStack#777) * Add support for Python 3.10 (MagicStack#795) (by @elprans in abf5569 for MagicStack#795) * Add support for asynchronous iterables to `copy_records_to_table()` (MagicStack#713) (by @elprans in 1d33ff6 for MagicStack#713) * Add support for coroutine functions as listener callbacks (MagicStack#802) (by @elprans in 41da093 for MagicStack#802) * Add support for sslcert, sslkey and sslrootcert parameters to DSN (MagicStack#768) (by @jdobes and @elprans in c674e86 for MagicStack#768) * Add copy_ wrappers to Pool (MagicStack#661) (by @elprans in a6b0f28 for MagicStack#661) * Add issubset and issuperset methods to the Range type (MagicStack#563) (by @kdorsel in de07d0a for MagicStack#563) Fixes ----- * Break connection internal circular reference (MagicStack#774) (by @fantix in d08a9b8 for MagicStack#774) * Make Server Version Extraction More Flexible (MagicStack#778) (by @Natrinicle in d076169 for MagicStack#778)

asyncpg v0.23.0 Fixes ----- * Avoid TypeError in `Transaction.__repr__` (MagicStack#703) (by @BeatButton in d6eea8e for MagicStack#703) * Feed memoryview to `writelines()` (MagicStack#715) (by @fantix in 359a34c for MagicStack#715) * Add sslmode=allow support and fix =prefer retry (MagicStack#720) (by @fantix in 075114c for MagicStack#720) * Loosen message test in `test_invalid_input` (MagicStack#751) (by @musicinmybrain in bc4127f for MagicStack#751) * Support readonly and deferrable for non-serializable transactions (MagicStack#747) (by @pauldraper in 5cf4089 for MagicStack#747) * Fix asyncpg with `Py_DEBUG` mode (MagicStack#719) (by @shadchin in a113d90 for MagicStack#719) * Fix docs/Makefile and docs/_static/theme_overrides.css missing from PyPI package (MagicStack#708) (by @musicinmybrain in c306068 for MagicStack#708)

asyncpg v0.22.0 A new asyncpg release is here. Notable additions include Python 3.9 support, support for recently added PostgreSQL types like `jsonpath`, and last but not least, vastly improved `executemany()` performance. Importantly, `executemany()` is also now _atomic_, which means that either all iterations succeed, or none at all, whereas previously partial results would have remained in place, unless `executemany()` was called in a transaction. There is also the usual assortment of improvements and bugfixes, see the details below. This is the last release of asyncpg that supports Python 3.5, which has reached EOL last September. Improvements ------------ * Vastly speedup executemany by batching protocol messages (MagicStack#295) (by @fantix in 690048d for MagicStack#295) * Allow using custom `Record` class (by @elprans in db4f1a6 for MagicStack#577) * Add Python 3.9 support (MagicStack#610) (by @elprans in c05d726 for MagicStack#610) * Prefer SSL connections by default (MagicStack#660) (by @elprans in 16183aa for MagicStack#660) * Add codecs for a bunch of new builtin types (MagicStack#665) (by @elprans in b53f038 for MagicStack#665) * Expose Pool as `asyncpg.Pool` (MagicStack#669) (by @rugleb in 0e0eb8d for MagicStack#669) * Avoid unnecessary overhead during connection reset (MagicStack#648) (by @kitogo in ff5da5f for MagicStack#648) Fixes ----- * Add a workaround for bpo-37658 (by @elprans in 2bac166 for #21894) * Fix wrong default transaction isolation level (MagicStack#622) (by @fantix in 4a627d5 for MagicStack#622) * Fix `set_type_codec()` to accept standard SQL type names (MagicStack#619) (by @elprans in 68b40cb for MagicStack#619) * Ignore custom data codec for internal introspection (MagicStack#618) (by @fantix in e064f59 for MagicStack#618) * Fix null/NULL quoting in array text encoder (MagicStack#627) (by @fantix in 92aa806 for MagicStack#627) * Fix link in connect docstring (MagicStack#653) (by @samuelcolvin in 8b313bd for MagicStack#653) * Make asyncpg work with pyinstaller (MagicStack#651) (by @Atem18 in 5ddabb1 for MagicStack#651) * Fix possible `AttributeError` exception in `ConnectionSettings` (MagicStack#632) (by @petriborg in 0d23182 for MagicStack#632) * Prohibit custom codecs on domains (by @elprans in 50f964f for MagicStack#457) * Raise proper error on anonymous composite input (tuple arguments) (MagicStack#664) (by @elprans in 7252dbe for MagicStack#664) * Fix incorrect application of custom codecs in some cases (MagicStack#662) (by @elprans in 50f65fb for MagicStack#662)

v0.21.0 Improvements ------------ * Add support for password functions (useful for RDS IAM auth) (MagicStack#554) (by Harvey Frye in 1d9457f for MagicStack#554) * Add support for connection termination listeners (MagicStack#525) (by @iomintz in 8141b93 for MagicStack#525) * Update CI matrix, aarch64 builds (MagicStack#595) (by @Gelbpunkt in ac6a2fc for MagicStack#595) Fixes ----- * Fix possible uninitalized pointer access on unexpected array message data (CVE-2020-17446, by @elprans in 69bcdf5, reported by @risicle) * Fix Connection class _copy_in private method (by @ABCDeath in 7f5c2a2 for MagicStack#555) * Bump pgproto to fix compilation issues (by @elprans in aa67d61 for MagicStack#565) * Improve pool documentation examples (MagicStack#491) (by @nyurik in 745f8f8 for MagicStack#491) * Update usage.rst (MagicStack#572) (by @xuedong09 in f5b425a for MagicStack#572) * Fix links in connection documentation (MagicStack#584) (by @samuelcolvin in b081320 for MagicStack#584) * Fix usage documentation for hstore (MagicStack#515) (by @aaliddell in 39040b3 for MagicStack#515) * Fix compiler warnings (by @elprans in 6cb5ba1)

v0.20.1 Bug Fixes ========= * Add back ensure future for connector (by Martin Asell in 2c99beb) * Fix errors in numeric binary decoder (by @elprans in 851d586 for MagicStack#520)

v0.20.0 New Features * Support Python 3.8 (by @1st1 in MagicStack#504) Bug Fixes * Handle IP values with prefix in "inet" type as `ipaddress.IPvXInterface` (by @elprans in 5a4daf7 for MagicStack#497) * Close transport if connection times out (by @hexrain in 926f483 for MagicStack#468) * Use faster UUID codecs; make UUID decoding/encoding/operations 2-7x faster (by @1st1 in edde3ff) * Use `loop.start_tls()` to upgrade connections to SSL (by @1st1 in bdba7ce) Build * Bump Cython to 0.29.14 (by @1st1 in 7cb31bc)