News and Updates

The third release candidate of SQLAlchemy 2.0 is now available.

Version 2.0.0rc3 releases a few more small enhancements and fixes, as well as serves as a test for an update of the wheel builder plugin on Pypi. Release 2.0.0 final is imminent, as early as next week. Applications that haven't tested within the 2.0 series should make sure they have pinned their requirements, as pip install will start to fetch the 2.0 series by default instead of 1.4 when the release occurs.

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

SQLAlchemy 2.0.0rc3 is available on the Download Page.

The second release candidate of SQLAlchemy 2.0 is now available.

Version 2.0.0rc2 includes a small number of relatively minor changes. In particular the MySQL/MariaDB dialect repair a regression that lasted throughout the 1.4 series where the Inspector.has_table() method would not report on the existence of temp tables.

2.0 final is still anticipated for sometime this month.

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

SQLAlchemy 2.0.0rc2 is available on the Download Page.

SQLAlchemy 1.4.46 is now available.

The first release of the new year, SQLAlchemy 1.4.46 fixes a few fairly important issues, including an issue which could in unlikely circumstances impact connection pool stability for applications that use gevent or eventlet.

Release 1.4.46 is also a step towards the first release of SQLAlchemy 2.0 final, expected this month, introducing a new deprecation warning that emits exactly once when the application in use makes use of an API removed from 2.0, when the SQLALCHEMY_WARN_20 environment variable is not otherwise set. This deprecation warning is intended to give users that may not be following the progress of 2.0 that their requirements files should ensure SQLAlchemy 2.0 won't be installed prematurely.

The complete changelog for 1.4.46 is at Changelog.

SQLAlchemy 1.4.46 is available on the Download Page.

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.