Changelog

1.4.0 (2022-10-26)

1.3.5 (2022-09-25)

  • Fix pool size limit check for unlimited pools #888

1.3.4 (2022-06-30)

1.3.4b3 (2022-06-29)

1.3.4b2 (2022-06-29)

1.3.4b1 (2022-06-29)

  • Fix compatibility with SA 1.4.38 #891

  • Add py.typed marker #878

1.3.3 (2021-11-01)

  • Support async-timeout 4.0+

1.3.2 (2021-10-07)

1.3.2b2 (2021-10-07)

  • Respect use_labels for select statement #882

1.3.2b1 (2021-07-11)

  • Fix compatibility with SQLAlchemy >= 1.4 #870

1.3.1 (2021-07-08)

1.3.1b2 (2021-07-06)

  • Suppress “Future exception was never retrieved” #862

1.3.1b1 (2021-07-05)

  • Fix ClosableQueue.get on cancellation, close it on Connection.close #859

1.3.0 (2021-06-30)

1.3.0b4 (2021-06-28)

  • Fix “Unable to detect disconnect when using NOTIFY/LISTEN” #559

1.3.0b3 (2021-04-03)

  • Reformat using black #814

1.3.0b2 (2021-04-02)

  • Type annotations #813

1.3.0b1 (2021-03-30)

  • Raise ResourceClosedError if we try to open a cursor on a closed SAConnection #811

1.3.0b0 (2021-03-25)

  • Fix compatibility with SA 1.4 for IN statement #806

1.2.1 (2021-03-23)

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

1.2.0b4 (2021-03-23)

  • Set max supported sqlalchemy version #805

1.2.0b3 (2021-03-22)

  • Don’t run ROLLBACK when the connection is closed #778

  • Multiple cursors support #801

1.2.0b2 (2020-12-21)

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

  • Fix python 3.8 warnings in tests #771

1.2.0b1 (2020-12-16)

  • Deprecate blocking connection.cancel() method #570

1.2.0b0 (2020-12-15)

  • Implement timeout on acquiring connection from pool #766

1.1.0 (2020-12-10)

1.1.0b2 (2020-12-09)

  • Added missing slots to context managers #763

1.1.0b1 (2020-12-07)

  • 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

1.0.0 (2019-09-20)

  • Removal of an asynchronous call in favor of issues # 550

  • Big editing of documentation and minor bugs #534

0.16.0 (2019-01-25)

  • 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

0.15.0 (2018-08-14)

  • Support Python 3.7 #437

0.14.0 (2018-05-10)

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

0.13.2 (2018-01-03)

  • Fixed compatibility with SQLAlchemy 1.2.0 #412

  • Added support for transaction isolation levels #219

0.13.1 (2017-09-10)

  • Added connection poll recycling logic #373

0.13.0 (2016-12-02)

  • 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

0.12.0 (2016-10-09)

  • Add an on_connect callback parameter to pool #141

  • Fixed connection to work under both windows and posix based systems #142

0.11.0 (2016-09-12)

  • Immediately remove callbacks from a closed file descriptor #139

  • Drop Python 3.3 support

0.10.0 (2016-07-16)

  • 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

0.9.2 (2016-01-31)

  • Make pool.release return asyncio.Future, so we can wait on it in __aexit__ #102

  • Add support for uuid type #103

0.9.1 (2016-01-17)

  • Documentation update #101

0.9.0 (2016-01-14)

  • Add async context managers for transactions #91

  • Support async iterator in ResultProxy #92

  • Add async with for engine #90

0.8.0 (2015-12-31)

  • 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

0.7.0 (2015-04-22)

  • 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().

0.6.0 (2015-02-03)

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

0.5.2 (2014-12-08)

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

0.5.1 (2014-10-31)

  • Fix a bug for processing transactions in line.

0.5.0 (2014-10-31)

  • Add .terminate() to Pool and Engine

  • Reimplement connection pool (now pool size cannot be greater than pool.maxsize)

  • Add .close() and .wait_closed() to Pool and Engine

  • Add minsize, maxsize, size and freesize properties to sa.Engine

  • Support echo parameter for logging executed SQL commands

  • Connection.close() is not a coroutine (but we keep backward compatibility).

0.4.1 (2014-10-02)

  • make cursor iterable

  • update docs

0.4.0 (2014-10-02)

  • add timeouts for database operations.

  • Autoregister psycopg2 support for json data type.

  • Support JSON in aiopg.sa

  • Support ARRAY in aiopg.sa

  • Autoregister hstore support if present in connected DB

  • Support HSTORE in aiopg.sa

0.3.2 (2014-07-07)

  • change signature to cursor.execute(operation, parameters=None) to follow psycopg2 convention.

0.3.1 (2014-07-04)

  • Forward arguments to cursor constructor for pooled connections.

0.3.0 (2014-06-22)

  • Allow executing SQLAlchemy DDL statements.

  • Fix bug with race conditions on acquiring/releasing connections from pool.

0.2.3 (2014-06-12)

  • Fix bug in connection pool.

0.2.2 (2014-06-07)

  • Fix bug with passing parameters into SAConnection.execute when executing raw SQL expression.

0.2.1 (2014-05-08)

  • Close connection with invalid transaction status on returning to pool.

0.2.0 (2014-05-04)

  • Implemented optional support for sqlalchemy functional sql layer.

0.1.0 (2014-04-06)

  • Implemented plain connections: connect, Connection, Cursor.

  • Implemented database pools: create_pool and Pool.