News and Updates

SQLAlchemy 1.4.44 is now available.

Release 1.4.44 is being released sooner than usual to provide a fix for a memory issue identified in the SQL caching system. Applications which have observed larger than usual memory use since switching to the 1.4.x series are strongly encouraged to try out version 1.4.44; if observed memory use decreases, please reach out to us and let us know!

The complete changelog for 1.4.44 is at Changelog.

SQLAlchemy 1.4.44 is available on the Download Page.

The third beta release of SQLAlchemy 2.0 is now available.

The third beta release includes a range of fixes for SQLAlchemy's newest feature, Annotated Declarative Mappings. Full scale use of this feature should hopefully be viable at this point as various issues regarding imports across multiple files have been identified and resolved.

For an overview of whats new in SQLAlchemy 2.0, see the Whats New in SQLAlchemy 2.0? document.

Links to the detailed changelog for 2.0.0b3 is at Changelog.

SQLAlchemy 2.0.0b3 is available on the Download Page.

SQLAlchemy 1.4.43 is now available.

Release 1.4.43 includes a variety of fixes within the 1.4 series.

The complete changelog for 1.4.43 is at Changelog.

SQLAlchemy 1.4.43 is available on the Download Page.

The second beta release of SQLAlchemy 2.0 is now available.

The first beta release just one week ago has seen unprecedented response for a beta, with around 5000 downloads per day. Thanks to our users, in the past seven days we've gotten about ten bug reports for small issues that have been fixed in 2.0.b2.

Of note is a fix for SQL Server that affected large string values, as well as a variety of rudimentary fixes for the new annotation-based Declarative feature including dataclasses support.

For an overview of whats new in SQLAlchemy 2.0, see the Whats New in SQLAlchemy 2.0? document.

Links to the detailed changelog for 2.0.0b2 is at Changelog.

SQLAlchemy 2.0.0b2 is available on the Download Page.

SQLAlchemy 1.4.42 is now available.

Release 1.4.42 includes a variety of bug fixes mostly in the area of ORM related use cases. Two new ORM related configurational warnings are added as well, indicating situations that can otherwise lead to confusing behavior in some cases when the incorrect mappings are used. While it's likely that some existing setups may have either of these patterns in place and will see the new warnings, these mis-configuration patterns have been possible for many years and don't indicate any new issue for existing applications.

Additionally fixed ongoing regressions regarding the MSSQL dialect in attempting to connect to various forms of Azure cloud databases, where fixes for one type of Azure database then introduce new problems connecting to another kind. The SQLAlchemy project doesn't have direct testing resources for these databases so we can only rely upon user feedback to know what's working, however it's very likely the issues are finally resolved in this release.

The complete changelog for 1.4.42 is at Changelog.

SQLAlchemy 1.4.42 is available on the Download Page.