News and Updates

SQLAlchemy release 1.2.0b3 is now available.

Release 1.2.0b3 is possibly the last beta release before 1.2.0 final is released. The release of 1.2.0b3 was delayed by two major factors. One was the release of cx_Oracle 6.0, which is a complete rework of the underlying client library for cx_Oracle that in turn required a lot of work on the SQLAlchemy side to accommodate, which resulted in SQLAlchemy's cx_Oracle dialect itself being reworked and modernized to make more complete use of patterns that were introduced in the 5.x series of cx_Oracle. The other was made possible by the advent of Microsoft SQL Server for Linux, which has allowed SQL Server testing to finally be part of of SQLAlchemy's continuous integration environment; as a result of this testing effort the library and test suite have had many long-standing SQL Server issues repaired.

On top of those two efforts were the usual stream of issue fixes that are backported into the 1.1.x series as well as additional behavioral adjustments new to the 1.2 series.

The What's New in SQLAlchemy 1.2? document as well as the Changelog will detail these changes as well as the changes since the 1.1 series overall. Users should carefully review these documents when testing applications against the 1.2 series, including for the move from 1.2.0b2 to 1.2.0b3. We'd like to thank the many contributors who helped with this release.

SQLAlchemy 1.2.0b3 is available on the Download Page.

SQLAlchemy release 1.1.14 is now available.

This release includes a variety of fixes for the ORM. Two of the issues are critical stability issues involving garbage-collection related bugs that are more likely to be seen within the Pypy interpreter however are not necessarily limited to this platform.

Changelog for 1.1.14 is at Changelog.

SQLAlchemy 1.1.14 is available on the Download Page.

SQLAlchemy release 1.1.13 is now available.

This release modifies the just-released fix for Oracle "WITH_UNICODE" mode based on feedback from cx_Oracle developers, to resolve a performance regression caused by this change.

Changelog for 1.1.13 is at Changelog.

SQLAlchemy 1.1.13 is available on the Download Page.

SQLAlchemy release 1.0.19 is now available.

This release modifies the just-released fix for Oracle "WITH_UNICODE" mode based on feedback from cx_Oracle developers, to resolve a performance regression caused by this change.

Changelog for 1.0.19 is at Changelog.

SQLAlchemy 1.0.19 is available on the Download Page.

SQLAlchemy release 1.2.0b2 is now available.

This release repairs an issue in the test suite that would prevent the suite from passing on Python version 3.6.2. The release is made at the same time as that of release 1.0.18 and 1.1.12. Also included are fixes related to ORM use of JSON NULL values, subquery eager loading, and a stability enhancement involving the identity map when used under high concurrency. New keyword options are also introduced on the Sequence construct.

The 1.2.0 series still has some more improvements that should be expected in a 1.2.0b3 release before moving to the final 1.2.0 release.

Users should carefully review the What's New in SQLAlchemy 1.2? document as well as the Changelog to note which behaviors and issues are affected. We'd like to thank the many contributors who helped with this release.

SQLAlchemy 1.2.0b2 is available on the Download Page.