News and Updates

SQLAlchemy release 1.3.0b1 is now available.

This is the initial beta release in the 1.3 series of SQLAlchemy, the latest iteration of new features and behavioral improvements. Highlights of 1.3 include:

• Performance improvements to the new "select in" loader strategy, such that a JOIN is no longer used at all to load collections
• JSON support for SQLite
• Support for SQLite's "ON CONFLICT" constraint directive
• Improvements to the new "expanding" bound parameter used for "IN" expressions, such that empty "IN" expressions are now supported
• new schema naming convention features and support for automatic truncation of long names
• a series of architectural and API improvements to the association proxy extension
• architectural and behavioral improvements to the Query.join() method
• Improvements to rendering and reflection of FULLTEXT indexes on MySQL
• Support for pyodbc's "fast executemany" mode for SQL Server
• Architectural improvements and updates to the cx_oracle dialect to keep up with the high velocity of changes being made to this DBAPI upstream

Release 1.3 includes approximately 39 individual improvements and features.

For an overview of what's new in the 1.3 series, see Whats New in 1.3? Full changelog is available at Changelog.

SQLAlchemy 1.3.0b1 is available on the Download Page.

SQLAlchemy release 1.2.14 is now available.

Release 1.2.14 includes a change that adjusts a change made in release 1.2.13, which itself was a workaround for an issue that affects the MySQL 8.0 series when reflecting foreign key constraints. The fix needed to be adjusted to work correctly when using MySQL on OSX.

Changelog for 1.2.14 is at Changelog.

SQLAlchemy 1.2.14 is available on the Download Page.

SQLAlchemy release 1.2.13 is now available.

This release includes a variety of fixes within the ORM and Core components.

Changelog for 1.2.13 is at Changelog.

SQLAlchemy 1.2.13 is available on the Download Page.

SQLAlchemy release 1.2.12 is now available.

Release 1.2.12 includes a series of mostly minor bugfixes, as well as one critical issue allowing the recently released version 7.0 of the cx_Oracle DBAPI to work correctly.

Changelog for 1.2.12 is at Changelog.

SQLAlchemy 1.2.12 is available on the Download Page.

SQLAlchemy release 1.2.11 is now available.

This release includes a short list of minor bug fixes that have accumulated over the past month.

Changelog for 1.2.11 is at Changelog.

SQLAlchemy 1.2.11 is available on the Download Page.