Up to [cvs.NetBSD.org] / pkgsrc / databases / py-asyncpg
Request diff between arbitrary revisions
Keyword substitution: kv
Default branch: MAIN
py-asyncpg: updated to 0.31.0 0.31.0 Enable Python 3.14 with experimental subinterpreter/freethreading support. Improvements Add Python 3.14 support, experimental subinterpreter/freethreading support Avoid performing type introspection on known types Make prepare() not use named statements by default when cache is disabled Implement connection service file functionality Fixes Fix multi port connection string issue Avoid leaking connections if _can_use_connection fails Other Drop support for EOL Python 3.8
Fix PLIST after py-setuptools update; bump depends and revision
py-asyncpg: updated to 0.30.0 0.30.0 Improvements Implement GSSAPI authentication Implement SSPI authentication Add initial typings Allow building with Cython 3 docs: fix connection pool close call Add support for the sslnegotiation parameter Test and build on Python 3.13 Support PostgreSQL 17 Add fetchmany to execute many and return rows Add connect kwarg to Pool to better support GCP's CloudSQL Allow customizing connection state reset Fixes s/quote/quote_plus/ in the note about DSN part quoting Use asyncio.run() instead of run_until_complete() Require async_timeout for python < 3.11 Allow testing with uvloop on Python 3.12 Mark pool-wrapped connection coroutine methods as coroutines handle None parameters in copy_from_query, returning NULL fix: return the pool from async_init_ if it's already initialized Replace obsolete, unsafe Py_TRASHCAN_SAFE_BEGIN/END
py-asyncpg: updated to 0.29.0 v0.29.0 Improvements Python 3.12 and PostgreSQL 16 support Add support for tuple-format custom codecs on composite types Support target_session_attrs in URL format, add tests Infinity numeric support Add support for the WHERE clause in copy_to methods Add query logging callbacks and context manager Fixes When prepared statements are disabled, avoid relying on them harder Handle environments with HOME set to a not-a-directory Fix handling of non-ASCII passwords Disable JIT while doing type introspection Remove connection parameter caching in Pool Switch to Python 3.12-style wait_for Update automatic PostGIS type conversion for Shapely 2.0 Use the timeout context manager in the connection path Small fix for documentation on using SSL in Connection Use cleanup_ctx in pool usage doc Close cursor portals once the iterator is exhausted Cut BaseProtocol circular reference on close. Allow passing hosts as tuples to connect() (in addition to lists)
py-asyncpg: updated to 0.28.0 0.28.0 Do not try to cleanup statements Add Pool.is_closing() method Fix test_tls_version for LibreSSL Handle environments without home dir fix: salt and iterations parsing for scram Add support for target_session_attrs Add support for READ UNCOMMITTED Update benchmarks, add psycopg3
py-asyncpg: updated to 0.25.0 v0.25.0 Changes Improve SSL option compatibility in URIs Add Pool methods to determine its min, max, current and idle size Make it possible to specify a statement name in Connection.prepare() Implement support for multirange types Fixes Make sure timeout callbacks always get cleaned up Update __all__ statements to a simpler form that is better supported by typecheckers Fix test_timetz_encoding on Python 3.10 Fix a bunch of ResourceWarnings in the test suite Fix SSLContext deprecation warnings Fix the description of the database argument to connect() Fix parsing of IPv6 addresses in the connection URI Improve diagnostics of invalid executemany() input
py-asyncpg: updated to 0.22.0 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 Allow using custom Record class Add Python 3.9 support Prefer SSL connections by default Add codecs for a bunch of new builtin types Expose Pool as asyncpg.Pool Avoid unnecessary overhead during connection reset
py-asyncpg: updated to 0.20.0 asyncpg v0.20.0 Improvements Support Python 3.8 Support PgBouncer by sending only a single SYNC message per query Bug Fixes Handle IP values with prefix in "inet" type as ipaddress.IPvXInterface Close transport if connection times out Use faster UUID codecs; make UUID decoding/encoding/operations 2-7x faster Use loop.start_tls() to upgrade connections to SSL Build Bump Cython to 0.29.14
py-asyncpg: updated to 0.19.0 asyncpg v0.19.0 Improvements Add support for SCRAM-SHA-256 authentication. Add PostgreSQL 12 support Bug Fixes Remove preexec_fn hack from test cluster management Fix DeprecationWarning in the docstring of copy_from_query() Allow specifying the target version when generating the release log Check for .flake8 after importing flake8 Include .flake8 in PyPI tarball fix timezone type label in docs Fix _StatementCache.clear() PS memory leak fix for warning_callback not yet defined Fix assertion fail on copy_records_to_table Do not look for a port in a Unix socket domain path Unquote connection string components properly Remove superfluous transaction from a cursor example
py-asyncpg: updated to 0.18.1 asyncpg v0.18.1: Fix DSN parsing regression asyncpg v0.18.0: Improvements Implement Record.get() Internal asyncpg errors are now consistently raised as InternalClientError Allow mappings as composite type input Add BitString.to_int() and BitString.from_int() Allow 'sslmode' in DSNs Add support for specifying multiple host addresses when connecting Low-level protocol implementation has been tweaked and optimized for slightly better performance in certain scenarios Queries with cached statements now generate fewer TCP packets Allow aliasing builtin types by name in set_builtin_type_codec() Factor out generic PostgreSQL protocol helpers into a separate package Fix tests and enable CI for PostgreSQL 11 Bug Fixes Handle and ignore permission errors when attempting to read .pgpass Fix decoding of fractional timestamps before Postgres epoch
py-asyncpg: updated to 0.17.0 asyncpg v0.17.0: Improvements Official support for Python 3.7. Bug Fixes Fix garbage collection of connections and emit a ResourceWarning if an unclosed connection is garbage collected. Raise a clear error if there's a race in pool intialization. Channel names in Connection.add_listener() and Connection.remove_listener() are now quoted properly. Fixed endianness detection on *BSD systems. Fixed handling of large type OIDs.
py-asyncpg: updated to 0.16.0
asyncpg v0.16.0:
Behavior Changes
----------------
Pool.close() now waits until all acquired connections are released.
Hence, the below code will now hang indefinitely:
conn = await pool.acquire()
await pool.close()
Asyncpg will log a warning if pool.close() takes over 60 seconds to
complete. It is advisable to use asyncio.wait_for() to set a timeout.
Improvements
------------
Add support for reading passwords from .pgpass
Add Connection.is_in_transaction()
Added codec for built-in type tid
Allow setting custom codecs on domains and enumerated types
Allow passing datetime.date instances as timestamp input
Implement support for pool connection rotation
Bug Fixes
---------
Prohibit non-iterable containers to be passed as array input
Decode numeric zeros with correct scale
Fix handling of OIDs >= 2**31
Make Pool.close() wait until all checked out connections are released
Fix type codec cache races
Raise a consistent exception on input encoding errors
py-asyncpg: updated to 0.14.0 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. Improvements: Support timeouts in Connection.close() and Pool.release() Invalidate type cache on schema changes affecting statement result. A new Connection.reload_schema_state() method. Add CrateDB detection Bug Fixes: Make prepared statement uid generator global Document pgbouncer-related prepared statement breakage Fix unaligned access issues in host-network byte I/O on ARM Fix issues with timetz type I/O Consistently use postgres/postgres as database/user pair in tests Fix Range.__hash__() Guard transaction methods against underlying connection release
py-asyncpg: update to 0.13.0 v0.13.0 Backwards Incompatible Changes ------------------------------ Drop support for PostgreSQL 9.1 Remove the deprecated "binary" parameter from Connection.set_type_codec() New Features ------------ Add support for PostgreSQL 10 Bug Fixes --------- Document that single fetches can return None Fix type introspection being very slow on large databases Fix copy tests on PostgreSQL < 9.4 Fix DeprecationWarning in tests Fix intermittent authentication failures against PostgreSQL 10 servers Do not attempt to connect to Unix sockets on Windows when host is not set Guard against incorrect use of resources associated with a connection Warn when there are active listeners on a connection that is released Add a test for cursors on a standby replica. Clarify the argument/parameter count mismatch exception Fix TypeError on get_attributes when result has no columns protocol: Use try-finally explicitly every time we create a waiter Call correct parent constructor in InterfaceWarning.__init__ Allow grabbing the version information programmatically. Use the general statement cache for type introspection Fix issues with inet type I/O Handle inactive connection closes while stored in the pool
asyncpg is a database interface library designed specifically for PostgreSQL and Python/asyncio. asyncpg is an efficient, clean implementation of PostgreSQL server binary protocol for use with Python's asyncio framework.