News and Updates

SQLAlchemy 2.0.14 is now available.

Release 2.0.14 includes bugfixes across the ORM, SQL and dialect-specific categories, including one fix against a rare race condition that's been reported as occurring with the "joined eager loading" strategy under unusual circumstances.

Links to the detailed changelog for 2.0.14 is at Changelog.

SQLAlchemy 2.0.14 is available on the Download Page.

SQLAlchemy 2.0.13 is now available.

Release 2.0.13 fixes a series of bugs and some regressions related to recent changes, and also adds a new feature specific to the sqlalchemy.ext.asyncio extension, a utility class AsyncAttrs, which adds a generic attribute access namespace to any mapped class .awaitable_attrs, which returns any attribute as an awaitable, allowing inline access to collections and other attributes that are using lazy loading or other varieties of expired/deferred/etc column loading.

Links to the detailed changelog for 2.0.13 is at Changelog.

SQLAlchemy 2.0.13 is available on the Download Page.

SQLAlchemy 2.0.12 is now available.

Release 2.0.12 includes a critical bugfix in the SQL caching system, also backported to version 1.4.48, where SQL expressions that made use of hybrid_property() in conjunction with the ORM aliased() construct would not be appropriately cached, leading to memory issues. All applications that make use of these constructs are strongly encouraged to upgrade to 2.0.12.

Links to the detailed changelog for 2.0.12 is at Changelog.

SQLAlchemy 2.0.12 is available on the Download Page.

SQLAlchemy 1.4.48 is now available.

Release 1.4.48 includes a critical bugfix in the SQL caching system, backported from version 2.0.12, where SQL expressions that made use of hybrid_property() in conjunction with the ORM aliased() construct would not be appropriately cached, leading to memory issues. All applications that make use of these constructs are strongly encouraged to upgrade to 1.4.48 (the same fix is in the 2.0 series at version 2.0.12).

The complete changelog for 1.4.48 is at Changelog.

SQLAlchemy 1.4.48 is available on the Download Page.

SQLAlchemy release 2.0.11 is now available.

Release 2.0.11 includes a fix for a critical regression introduced in 2.0.10 as a result of the "insertmanyvalues" refactoring, for the PostgreSQL dialects using either the psycopg or psycopg2 drivers, which impacted floating point data during bulk INSERT statements.

Version 2.0.11 also includes performance enhancements to the Row construct as well as other fixes for the ORM, engine, Oracle and MSSQL components.

Links to the detailed changelog for 2.0.11 is at Changelog.

SQLAlchemy 2.0.11 is available on the Download Page.