News and Updates

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.

SQLAlchemy release 1.3.5 is now available.

Release 1.3.5 has dialect-specific improvements for PostgreSQL and MySQL, as well as a series of relatively subtle bug fixes and improvements to the ORM. Finally, an issue regarding quoting of column labels in conjunction with the literal_column() construct is 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.5 is at Changelog.

SQLAlchemy 1.3.5 is available on the Download Page.