News and Updates

SQLAlchemy 1.4.18 is now available.

Release 1.4.18 includes some ORM regressions typically involving very complex mapping/query combinations, as well as makes an improvement that is hoped to support Flask-SQLAlchemy integration as well as similar integrations. Some new asyncio features are included as well as varied other dialect-level fixes for PostgreSQL and SQLite (specifically pysqlcipher).

Thanks to our users and developers for their continued support and efforts on the project.

The complete changelog for 1.4.18 is at Changelog.

SQLAlchemy 1.4.18 is available on the Download Page.

SQLAlchemy 1.4.17 is now available.

Release 1.4.17 fixes one mistake just released in version 1.4.16 regarding a performance enhancement involving expressions such as select().join(), which could fail in certain uncommon calling circumstances brought to our attention.

Thanks to our users and developers for their continued support and efforts on the project.

The complete changelog for 1.4.17 is at Changelog.

SQLAlchemy 1.4.17 is available on the Download Page.

SQLAlchemy 1.4.16 is now available.

With the pace of regressions having slowed, it is hoped that the 1.4 series continues to achieve wide adoption, which will further establish the stability of the new architectures and features. Release 1.4.16 includes a variety of fixes in including some minor regressions in the ORM.

Thanks to our users and developers for their continued support and efforts on the project.

The complete changelog for 1.4.16 is at Changelog.

SQLAlchemy 1.4.16 is available on the Download Page.

SQLAlchemy 1.4.15 is now available.

Release 1.4.15 fixes a fairly serious issue with the subqueryload() loader strategy that was causing it to not correctly use SQL caching, which would degrade the usefulness of the caching feature overall. A small number of other fixes and enhancements are also included.

Thanks to our users and developers for their continued support and efforts on the project.

The complete changelog for 1.4.15 is at Changelog.

SQLAlchemy 1.4.15 is available on the Download Page.

SQLAlchemy 1.4.14 is now available.

Release 1.4.14 includes deprecation paths for some API behaviors that had inadvertently been removed. It also includes a fix for the recently modified "empty IN" behaviors, as well as support for calling ".commit()" or ".rollback()" pre-emptively inside of transactional context managers. Finally, an adjustment to TypeDecorator will render a warning that user- defined TypeDecorator classes will want to "opt in" or "opt out" of caching by applying a flag cache_ok=[True|False] to these classes.

Thanks to our users and developers for their continued support and efforts on the project.

The complete changelog for 1.4.14 is at Changelog.

SQLAlchemy 1.4.14 is available on the Download Page.