aiopg

What's Changed

• Add python 3.11 and drop python 3.6 support by @Pliner in https://github.com/aio-libs/aiopg/pull/892

Full Changelog: https://github.com/aio-libs/aiopg/compare/v1.3.5...v1.4.0

Changes

• Implement timeout on acquiring connection from pool(#766)

• Deprecate blocking connection.cancel() method (#570)

• Fix IsolationLevel.read_committed and introduce IsolationLevel.default (#770)

• Fix python 3.8 warnings in tests (#771)

• Don't run ROLLBACK when the connection is closed (#778)

• Multiple cursors support (#801)

• Set max supported sqlalchemy version (#805)

• Pop loop in connection init due to backward compatibility (#808)

Changes

• Fix on_connect multiple call on acquire(#552)

• Fix python 3.8 warnings(#622)

• Bump minimum psycopg version to 2.8.4(#754)

• Fix Engine.release method to release connection in any way(#756)

• Added missing slots to context managers (#763)

• Removal of an asynchronous call in favor of issues #550
• Big editing of documentation and minor bugs #534

Changes

• Fix select priority name (#525)

• Rename psycopg2 to psycopg2-binary to fix deprecation warning (#507)

• Fix #189 hstore when using ReadDictCursor (#512)

• close cannot be used while an asynchronous query is underway (#452)

• sqlalchemy adapter trx begin allow transaction_mode (#498)

Changes

• Support Python 3.7 (#437)

Changes

• Add get_dialect func to have ability to pass json_serializer #451

Changes

• Fixed compatibility with SQLAlchemy 1.2.0 #412

• Added support for transaction isolation levels #219

Changes

• Added connection poll recycling logic #373

Changes

• Add async with support to .begin_nested() #208
• Fix connection.cancel() #212 #223
• Raise informative error on unexpected connection closing #191
• Added support for python types columns issues #217
• Added support for default values in SA table issues #206

CHANGES

• Immediately remove callbacks from a closed file descriptor #139
• Drop Python 3.3 support

Connection pool is more stable now.

Changes

• Refactor tests to use dockerized Postgres server #107
• Reduce default pool minsize to 1 #106
• Explicitly enumerate packages in setup.py #85
• Remove expired connections from pool on acquire #116
• Don't crash when Connection is GC'ed #124
• Use loop.create_future() if available

Changes

• Make pool.release return asyncio.Future, so we can wait on it in
  __aexit__ #102
• Add support for uuid type #103

Documentation release, no code changes.

Added support for async/await syntax into SQLAlchemy layer

Changes

• Add async context managers for transactions #91
• Support async iterator in ResultProxy #92
• Add async with for engine #90

Fixed a bug with processing timeouts, added support for async with statements in core API.

SQLAlchemy layer is not converted yet.

Full list of changes:

• Add PostgreSQL notification support #58
• Support pools with unlimited size #59
• Cancel current DB operation on asyncio timeout #66
• Add async with support for Pool, Connection, Cursor #88

Major aiopg 0.7.0 release.

CHANGES

• Get rid of resource leak on connection failure.
• Report ResourceWarning on non-closed connections.
• Deprecate iteration protocol support in cursor and ResultProxy.
• Release sa connection to pool on connection.close().

Better support for aiopg.sa query execution

Changes

• Accept dict, list, tuple, named and positional parameters in
  SAConnection.execute()

Minor release, fixes a bug that leaves connection in broken state after cursor.execute() failure.

Minor bugfix release.

Fix allows to use next transaction on the same connection for aiopg.sa machinery.