News and Updates

SQLAlchemy 1.4.52 Released
permalink

SQLAlchemy 1.4.52 is now available.

This release was made to support a single ORM issue backport from the 2.0 series, involving a shortcoming in the with_loader_criteria() ORM option that is frequently used to limit results based on ACLs and similar criteria.

The complete changelog for 1.4.52 is at Changelog.

SQLAlchemy 1.4.52 is available on the Download Page.

SQLAlchemy 2.0.28 Released
permalink

SQLAlchemy 2.0.28 is now available.

Release 2.0.28 includes two ORM related regression fixes, one of which is a performance regression regarding ORM "criteria" options such as the with_expression() construct as well as when adding WHERE criteria to loader options such as selectinload(). The replacement approach is significantly simpler and may have a noticeable effect for applications which encounter this specific codepath / scenario.

Links to the detailed changelog for 2.0.28 is at Changelog.

SQLAlchemy 2.0.28 is available on the Download Page.

SQLAlchemy 2.0.27 Released
permalink

SQLAlchemy 2.0.27 is now available.

Release 2.0.27 fixes a single regression caused by a fix for the asyncpg dialect, where an exception catch was catching an object reference that wasn't present.

Links to the detailed changelog for 2.0.27 is at Changelog.

SQLAlchemy 2.0.27 is available on the Download Page.

SQLAlchemy 2.0.26 Released
permalink

SQLAlchemy 2.0.26 is now available.

Release 2.0.26 has a wide array of bugfixes across almost all the dialects, the ORM, Core components, as well as typing and example fixes.

Links to the detailed changelog for 2.0.26 is at Changelog.

SQLAlchemy 2.0.26 is available on the Download Page.

SQLAlchemy 2.0.25 Released
permalink

SQLAlchemy 2.0.25 is now available.

This release includes a fix for an issue found in the asyncio system, where an engine that's been disposed using the Engine.dispose() method, as would be done when moving the engine across a process boundary, then used again for new connectivity, would inadvertently use a threading.Lock internally which can cause deadlocks when used in an asyncio context.

The release also includes a "preview" backport of the asyncio-compatible dialect for Oracle using the newly introduced asyncio support in the oracledb DBAPI library.

Links to the detailed changelog for 2.0.25 is at Changelog.

SQLAlchemy 2.0.25 is available on the Download Page.