News and Updates

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.

SQLAlchemy 1.4.51 Released
permalink

SQLAlchemy 1.4.51 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 complete changelog for 1.4.51 is at Changelog.

SQLAlchemy 1.4.51 is available on the Download Page.

SQLAlchemy 2.0.24 Released
permalink

SQLAlchemy 2.0.24 is now available.

Release 2.0.24 includes a significant number of bug fixes and improvements. Changes to be particularly aware of include a fix to the URL.render_as_string() method to repair for escaping of particular characters that previously would not "round trip" through a URL->string->URL loop, full pep-484 typing has been implemented for the sqlalchemy.sql.functions module, and the async_fallback() function used for test suites is now deprecated.

Links to the detailed changelog for 2.0.24 is at Changelog.

SQLAlchemy 2.0.24 is available on the Download Page.

SQLAlchemy 2.0.23 Released
permalink

SQLAlchemy 2.0.23 is now available.

Release 2.0.23 has a wide variety of bug fixes across most components, including ORM, SQL/engine, PostgreSQL, MySQL/MariaDB, Oracle, and SQL Server. In addition, in response to popular demand, an early-access async dialect for the combination of aioodbc with SQL Server has been added. The dialect builds on a new internal asyncio framework that is expected to be integrated with most other asyncio dialects in SQLAlchemy 2.1.

Links to the detailed changelog for 2.0.23 is at Changelog.

SQLAlchemy 2.0.23 is available on the Download Page.

SQLAlchemy 1.4.50 Released
permalink

SQLAlchemy 1.4.50 is now available.

Release 1.4.50 is a late 1.4-series release to keep up with a small number of bug fixes that have been backported from the 2.0 series. It includes a fix for a new warning that's being emitted by some MySQL native client libraries regarding the argument signature for the ping() command, when the "pool pre-ping" feature of the engine is used.

The complete changelog for 1.4.50 is at Changelog.

SQLAlchemy 1.4.50 is available on the Download Page.