News and Updates

The first release candidate of SQLAlchemy 2.0 is now available.

Version 2.0.0rc1 is hoped to be very close to the final 2.0.0 release which is anticipated in January. A few additional changes have been added since the 2.0.0b4 release, mostly in the area of Session behavior.

Users of SQLAlchemy 1.4 should ensure that their production requirements.txt files are capped in the 1.4 series, so that the final 2.0.0 release doesn't result in sudden changes due to surprise upgrades; upgrades from 1.4.x to 2.0.x should always be tested, even if the full migration steps were completed for the 1.4 series.

Users looking to upgrade to SQLAlchemy 2.0 are encouraged to work through the 2.0 Migration Guide <https://docs.sqlalchemy.org/en/20/changelog/migration_20.html>, which will allow the vast majority of applications that run under SQLAlchemy 1.4 to run completely under SQLAlchemy 2.0. SQLAlchemy 2.0 may have additional behaviors and API adjustments that as always should be tested against the 2.0 release itself.

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

SQLAlchemy 2.0.0rc1 is available on the Download Page.

SQLAlchemy 1.4.45 is now available.

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

The complete changelog for 1.4.45 is at Changelog.

SQLAlchemy 1.4.45 is available on the Download Page.

The fourth beta release of SQLAlchemy 2.0 is now available.

Version 2.0.0b4 should be close to ready-to-release quality, in particular for the new Declarative and Python Dataclasses features, which have received much attention within the beta testing period. A variety of issues regarding different styles of annotations and dataclass mappings have been reported and fixed, as well as a range of typing related fixes and improvements to continue to allow for full strict typing without the need for plugins.

There's additionally new improvements within the schema, SQL rendering and SQL type systems and several other improvements and fixes that have either already been released in SQLAlchemy 1.4.44 or will be in SQLAlchemy 1.4.45; the changelogs for 2.0.0b3 and 2.0.0b4 now note additional issues that were backported to the 1.4 series.

The release of 2.0 final is hoped to be mid January of 2023.

The 2.0 series is at this point very close to an approximate "feature freeze", having accumulated a series of changes that will likely lead to a long period of adjustment once released; while the beta releases typically see a few thousand downloads per day, the 1.4 releases average about 1.3 million per day on a weekday, so the download base for SQLAlchemy 2.0 is expected to multiply by at least 10000% within the first few months; new issues and usage questions are expected to be extremely heavy after the release, as 2.0 has most backwards-incompatible changes of any SQLAlchemy release.

Users looking to upgrade to SQLAlchemy 2.0 are encouraged to work through the 2.0 Migration Guide <https://docs.sqlalchemy.org/en/20/changelog/migration_20.html>, which will allow the vast majority of applications that run under SQLAlchemy 1.4 to run completely under SQLAlchemy 2.0; from that point, additional migrations towards new 2.0 Declarative mappings can be undertaken, allowing for full typing support of ORM mappings without plugins. These migrations are are described in the Whats New in SQLAlchemy 2.0? document, along with other migration notes for new features and other less central API changes, such as a new API for PostgreSQL RANGE datatypes.

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

SQLAlchemy 2.0.0b4 is available on the Download Page.

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.