News and Updates

SQLAlchemy 1.3.13 Released

permalink

SQLAlchemy release 1.3.13 is now available.

Release 1.3.13 is a fairly ambitious bug-fix release which includes a fair amount of ORM related fixes as well as a variety of internal changes in order to greatly reduce reference cycles in both the Core and ORM layers. While these changes have been extensively tested, there is an increased usage of weak reference objects which can in theory impact non-idiomatic code that deals with inspection of ORM internals in that some objects may be garbage collected earlier than they would have previously.

See the changelog for descriptions of these new features as well as an overview of bug fixes.

As is the case with all releases, we'd like to thank all the contributors who helped with this release.

Changelog for 1.3.13 is at Changelog.

SQLAlchemy 1.3.13 is available on the Download Page.

SQLAlchemy 1.3.12 Released

permalink

SQLAlchemy release 1.3.12 is now available.

Release 1.3.12 contains a series of bug fixes mostly in the area of the ORM.

See the changelog for descriptions of these new features as well as an overview of bug fixes.

As is the case with all releases, we'd like to thank all the contributors who helped with this release.

Changelog for 1.3.12 is at Changelog.

SQLAlchemy 1.3.12 is available on the Download Page.

SQLAlchemy 1.3.11 Released

permalink

SQLAlchemy release 1.3.11 is now available.

Release 1.3.11 has a significant number of bug fixes across all areas as well as new use case additions. While it is a "point release", it contains a few use case additions that amount to new features, as they are needed sooner than the 1.4 series will be ready. This includes new scalar accessors for JSON index expressions that work across all JSON-supporting backends as well as cross-dialect support for the "GENERATED ALWAYS AS" SQL construct, which allows for an automatically updated expression to be established within DDL in the database server.

See the changelog for descriptions of these new features as well as an overview of bug fixes.

As is the case with all releases, we'd like to thank all the contributors who helped with this release.

Changelog for 1.3.11 is at Changelog.

SQLAlchemy 1.3.11 is available on the Download Page.

SQLAlchemy 1.3.10 Released

permalink

SQLAlchemy release 1.3.10 is now available.

Release 1.3.10 fixes a regression in the newly implemented Oracle max identifier length detection which was inadvertently using the newer value of 128 on server version 12.2 and greater, despite documentation stating that version 1.3.9 would continue to return the length of 30 unless the value were explicitly set. In addition, the retrieval and parsing of the "compatibility" version has been improved and will no longer emit a warning if the "v$parameter" table is not available, as this condition seemed to be reported more than was anticipated. It is recommended that all Oracle users skip release 1.3.9 and upgrade to 1.3.10.

As is the case with all releases, we'd like to thank all the contributors who helped with this release.

Changelog for 1.3.10 is at Changelog.

SQLAlchemy 1.3.10 is available on the Download Page.

SQLAlchemy 1.3.9 Released

permalink

SQLAlchemy release 1.3.9 is now available.

Release 1.3.9 contains a variety of bug fixes and use case additions.

In particular is included support for Oracle's updated max identifier length which is 128 as of Oracle 12.2; release 1.3 won't adjust automatically, but will emit a warning that recommends the application set the desired identifier length explicitly using a new parameter max_identifier_length; the value will default to 128 for server version 12.2 and above in the 1.4 series.

Release 1.3.9 also includes support for SQLite "URI" connections supported by the Python 3 version of the driver. An ORM regression which appeared in version 1.3.6 involving the "selectinload" loader strategy is also fixed.

As is the case with all releases, we'd like to thank all the contributors who helped with this release.

Changelog for 1.3.9 is at Changelog.

SQLAlchemy 1.3.9 is available on the Download Page.