News and Updates

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 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 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.

SQLAlchemy release 1.3.8 is now available.

Release 1.3.8 is only about two weeks past release 1.3.7, and overall there has been a high level of velocity as users continue to report lots of small issues and often deliver pull requests to accompany them. Release 1.3.8 includes a fix for the new psycopg2 "execute values" performance feature to accommodate for INSERT statements that are modified by compiler hooks.

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

Changelog for 1.3.8 is at Changelog.

SQLAlchemy 1.3.8 is available on the Download Page.

SQLAlchemy release 1.3.7 is now available.

Release 1.3.7 has a considerable number of bug fixes across the ORM, SQL, and database dialect components and a few new database use case additions, including full support for psycopg2's fast execution helpers which can significantly increase the performance of multiple INSERT statements.

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

Changelog for 1.3.7 is at Changelog.

SQLAlchemy 1.3.7 is available on the Download Page.