News and Updates

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.

SQLAlchemy release 1.3.6 is now available.

Release 1.3.6 includes a relatively wide amount of changes including many small bug fixes within the ORM, as well as the ability for the SQLite dialect to render an IN expression against tuples for newer versions of SQLite and a new capability for ORM query options to be specified hierarchically.

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

Changelog for 1.3.6 is at Changelog.

SQLAlchemy 1.3.6 is available on the Download Page.