asyncpg v0.14.0

Backwards Incompatible Changes
------------------------------

asyncpg now reports the server version as x.0.y for PostgreSQL 10.0 and later.
This is in alignment with how upstream is interpreting the "minor" version
component now. (@elprans in 1fa12fe)

Improvements
------------

* Add CrateDB detection
  (by @mfussenegger in afc1038)

Bug Fixes
---------

* Fix custom codec example to not use the obsolete "binary" parameter
  (by @elprans in f4e17dd)

* Make prepared statement uid generator global
  (by @1st1 in 3e43fcf)

* Document pgbouncer-related prepared statement breakage
  (by @elprans in 4a3713f for #121)

* Fix unaligned access issues in host-network byte I/O on ARM
  (by @elprans in c04576d for #216)

* Fix issues with timetz type I/O
  (by Vitaliy Burovoy in 7b6c083)

* Consistently use postgres/postgres as database/user pair in tests
  (by @elprans in b4ce740)

* Bump Cython and uvloop in .ci/requirements.txt
  (by @elprans in fd3a3b8)

* Support timeouts in Connection.close() and Pool.release()
  (by @elprans in bdfdd89 for #220)

* Catch exceptions in asynchronous tasks when testing
  (by @elprans in 695b8f0)

* fix Range.__hash__
  (by @eumiro in 46f468c)

* Guard transaction methods against underlying connection release
  (by @elprans in 59e2878 for #232)

* Fix python examples + typo
  (by @vitaly-burovoy in b10e883)

* Invalidate type cache on schema changes affecting statement result.
  (by @vitaly-burovoy in b04556e)

asyncpg v0.13.0

Backwards Incompatible Changes
------------------------------

* Drop support for PostgreSQL 9.1
  (by @elprans in eaf298b)

* Remove the deprecated "binary" parameter from `Connection.set_type_codec()`
  (by @elprans in 9ad6625)

New Features
------------

* Add support for PostgreSQL 10
  (by @elprans)

Bug Fixes
---------

* Document that single fetches can return None
  (by @khazhyk in 23394c9)

* Fix type introspection being very slow on large databases
  (by @elprans in e0c44ce for #186)

* Fix copy tests on PostgreSQL < 9.4
  (by @elprans in 327058f)

* Fix DeprecationWarning in tests
  (by @elprans in 3f9523c)

* Fix intermittent authentication failures against PostgreSQL 10 servers
  (by @elprans in 498213e for #158)

* Do not attempt to connect to Unix sockets on Windows when host is not set
  (by @elprans in 8a32fc4 for #184)

* Guard against incorrect use of resources associated with a connection
  (by @elprans in 089ac81, 93bf26f for #190)

* Warn when there are active listeners on a connection that is released
  (by @elprans in d085d2c for #190)

* Add a test for cursors on a standby replica.
  (by @elprans in c484a47 for #66)

* Clarify the argument/parameter count mismatch exception
  (by @elprans in b6fe018 for #178)

* Fix `TypeError` on `get_attributes` when result has no columns
  (by @fantix in f29de23)

* protocol: Use `try`-`finally` explicitly every time we create a waiter
  (by @1st1 in 50edd8c)

* Call correct parent constructor in `InterfaceWarning.__init__`
  (by @elprans in eec98b0)

* Allow grabbing the version information programmatically.
  (by @s0undt3ch in fa6dbc4)

* Use the general statement cache for type introspection
  (by @elprans in 57c9ffd for #198)

* Fix issues with inet type I/O
  (by @elprans in e54f02e for #37)

* Handle inactive connection closes while stored in the pool
  (by @AmatanHead in 9744ade)

New Features

* Implement `as_dict()` method for `PostgresMessage`.
  (by @vitaly-burovoy in 90725f1)

* Add API for receiving log messages `connection.add_log_listener()`.
  (by @vitaly-burovoy and @1st1 in 1b1893d and f072f88 for #144)

* Add support for "tuple" exchange format for codec overrides.
  (by @elprans in 0453243 and d27dda7)

* Implement binary format codec for numeric type.
  (by @elprans in a5413eb for #157)

Bug Fixes

* Fix boundary checks for integers.
  (by @vitaly-burovoy in e082910 and dfcf135)

* Fix handling of `NULL`s in copy_records_to_table().
  (by @elprans in 991b1ae for #153)

* Raise an error when a binary `COPY FROM` is attempted w/o appropriate codec.
  (by @elprans in 7aac14e for #157)

* Fix `Record.items()` to support duplicate keys. See #28 for details.
  (by @1st1 in 39b390c for #28)

* Fix `Record.keys()` to correctly return duplicate keys. See #28.
  (by @1st1 in b06114d for #28)

* Call notifications listeners using `loop.call_soon()`.
  (by @1st1 in 83d08bd)

* Make `PoolConnectionProxy` more dynamic. Fixes #155.
  (by @1st1 in 6ca1f28 for #155)

* Make sure `set_type_codec()` overrides core codec for all formats.
  (by @elprans in 9c32b86 for #140)

* New severity "V" field as "severity_en" attribute.
  (by @vitaly-burovoy in 35bce5a)

* Make interval decoding logic match that of psycopg2.
  (by @elprans in 6b48443 for #150)

v0.11.0

Backwards Compatibility

* Make `timeout` param of `executemany()` a keyword-only kwarg.
  (by @1st1 in bb326fc)

* Prohibit passing non-string instances as text arguments to queries.
  (by @elprans in ccc5f7a)

New Features

* Add support for COPY IN.
  (by @elprans in 10d95d4 for #123)

* Add support for COPY OUT.
  (by @elprans and @1st1 in 5662d9f for #21)

Bug Fixes

* Refactor args parsing and config management for `connect()` and
  `create_pool()`.
  (by @1st1 in f280a56)

* Fix cancellation code to correctly ensure proper state of the waiter.
  (by @1st1 in 0a49130)

* support postgres-xl version
  (by songjy in ffb8959)

* Fix erroneous codec cache invalidation on internal codec aliasing.
  (by @elprans in df64f55 for #133)

* Fix potential segfault in text array decoder.
  (by @elprans in bbd116b)

* Limit max number of arguments (closes #127).
  (by @1st1 in 128910e for #127)

Documentation

* Expand usage documentation, add FAQ.
  (by @elprans in e4bef17)

New features

* Add new Connection parameter: `max_cacheable_statement_size`.
  (by @1st1 in b1f87eb for #115)

Bug fixes

* Require `command_timeout` argument of `connect()` be greater than 0.
  (by @1st1 in 7b7ce99)

* Fix SSL support in connection pool.
  (by @elprans in b89fb45 for #119)

* Make timeout in connect() consistent.
  (by @1st1 in 1d8f5cf for #117)

New features

* Add support for SSL connections.
  (by @1st1 in 5836a8f for #25)

* Add `max_cached_statement_lifetime` parameter to `asyncpg.connect()`.
  (by @1st1 in 10955fd for #76)

* Add `max_inactive_connection_lifetime` parameter to `asyncpg.create_pool()`.
  (by @1st1 in a2935ae)

* Allow overriding codecs for builtin types on a connection.
  (by @elprans in 71de129 for #73)

* Add support for the text I/O fallback for arrays of unknown types.
  (by @elprans in a2e53ab for #82)

* Make the `Record` type available as `asyncpg.Record`.
  (by @elprans in d42608f for #93)

* pool: Track connections and prohibit using them after release.
  (by @1st1 in 3bf6103)

* Rollback any active transactions in `Connection.reset()`.
  (by @1st1 in 0d19d96)

* Invalidate statement cache on schema changes affecting statement result.
  (by @elprans in 749d857 for #72)

* Use anonymous prepared statements when the cache is off.
  (by @1st1 in a3e9cb4 for #76)

* Expose some of `Connection` methods directly on the Pool object.
  (by @1st1 in 1b3a847 for #39)

* Raise an error if connection is used after being closed.
  (by @1st1 in 5ddd7fc)

* Add Amazon Redshift detection.
  (by @elprans in 4fdc1db for #29)

* Add rudimentary server capability detection.
  (by @elprans in e8bb3dc for #87)

Bug fixes

* Handle exceptions in generators passed to `Connection.executemany()`.
  (by @elprans in 8d17ecc for #85)

* Shield `Pool.release()` from task cancellation.
  (by @elprans in 537c8c9 for #97)

* Fix inclusion of `DETAIL` and `HINT` in Postgres messages.
  (by @elprans in 2e346c1)

* Implement conistent handling of timeouts.
  (by @elprans in 1674dec)

* Make `timeout` arg of `Connection.executemany()` a keyword-only arg.
  (by @1st1 in 424760d)

v0.9.0

Elvis Pranskevichus (5):
      Test floating point edge case decoding with text input
      Remove the expectation of receiving an "anyarray" type in query output
      Shorten the nested array decoder code
      Add a test for ENUM type
      Add Github issue template.

Vitaly Burovoy (1):
      Fix parsing server version string for non-final releases (devel, beta etc.)

Yury Selivanov (5):
      Give auto-prepared statements more distinct names.
      github: Reword issue template
      Add 'init' parameter to `create_pool()`. Addresses issue #80.
      setup.py: Mark asyncpg as production/stable

asyncpg-0.8.4

asyncpg-0.8.3

asyncpg v0.8.2