News and Updates

SQLAlchemy 1.1.0 Released

permalink

SQLAlchemy release 1.1.0 is now available.

Release 1.1.0 is the first official release in the 1.1 series, after three beta releases. The release represents the past eighteen months of new feature development since version 1.0 was released. The very long list of new capabilities has a focus on Core, particularly in the area of SQL syntaxes that are either solely supported by, or are most commonly used on the Postgresql database, and development was greatly assisted by a highly involved community working sometimes for many weeks on new features.

Major new SQL features include:

  • Common table expression (CTE) support for INSERT, UPDATE, DELETE
  • Support for Postgresql upsert - INSERT..ON CONFLICT (DO UPDATE | DO NOTHING)
  • Support for MySQL's JSON type
  • Support for RANGE and ROWS specification within window functions
  • Support for the SQL LATERAL keyword support by Postgresql
  • Support for TABLESAMPLE
  • Core and ORM support for FULL OUTER JOIN
  • Support for IS DISTINCT FROM and IS NOT DISTINCT FROM
  • Support for WITHIN GROUP, ARRAY_AGG
  • Support for FOR UPDATE SKIP LOCKED / FOR NO KEY UPDATE / FOR KEY SHARE

There are also many new ORM features including a new "raise" loader that prevents inadvertent lazy loading, new event hooks for Session objects that allow tracking of all stages of an object's lifecycle, and new "mutable" collections for columns that store serialized object structures.

Along with the new SQL syntax and ORM features are a wide array of ORM and execution engine fixes and improvements, and an absolute minimum of behavioral changes that run the risk of being surprising. Nevertheless, as is always the case, there are many areas where something that didn't work before will work now; users should please carefully review the full series of migration notes at What's new in 1.1? to see the full expanse of things that have changed.

The complete changelog for 1.1.0 as well as all the beta releases is at Changelog; we'd like to thank the many contributors who helped with this release.

SQLAlchemy 1.1.0 is available on the Download Page.

SQLAlchemy 1.0.15 Released

permalink

SQLAlchemy release 1.0.15 is now available.

Release 1.0.15 features a small number of bug fixes that have been made over the past two months since the previous 1.0.x release.

Users should review the changelog for 1.0.15 at Changelog; we'd like to thank the many contributors who helped with this release.

SQLAlchemy 1.0.15 is available on the Download Page.

SQLAlchemy 1.1.0b3 Released

permalink

SQLAlchemy release 1.1.0b3 is now available.

This is likely the last beta of the 1.1 series, which repairs a few issues in the new CTE for UPDATE/INSERT feature. Overall not many regressions or issues have been reported in the beta series, however this is typical; once the 1.1 final release comes out, the userbase grows dramatically and more issues should be expected.

Users should carefully review the What's New in SQLAlchemy 1.1? document as well as the Changelog to note which behaviors and issues are affected. We'd like to thank the many contributors who helped with this release.

SQLAlchemy 1.1.0b3 is available on the Download Page.

SQLAlchemy 1.0.14 Released

permalink

SQLAlchemy release 1.0.14 is now available.

This is the latest release in the 1.0 series which includes a variety of bug fixes that have accumulated since the last 1.0 release. This release happens to only feature Core and dialect level changes; none are ORM specific. All applicable fixes here are also in the 1.1 series, most of which are already released as of 1.1.0b2. As the 1.1 series moves towards final release, the 1.0 series will move into "maintenance" mode with very few additional changes being made.

Users should review the changelog for 1.0.14 at Changelog; we'd like to thank the many contributors who helped with this release.

SQLAlchemy 1.0.14 is available on the Download Page.

SQLAlchemy 1.1.0b2 Released

permalink

SQLAlchemy release 1.1.0b2 is now available.

A few small issues were reported with 1.1.0b1 which are resolved here. Assuming things remain fairly quiet during the beta releases, 1.1.0 final will be released in the coming weeks. Typically, a lot more regressions are reported once the beta stage is left as that's when the general population starts using the release.

Users should carefully review the What's New in SQLAlchemy 1.1? document as well as the Changelog to note which behaviors and issues are affected. We'd like to thank the many contributors who helped with this release.

SQLAlchemy 1.1.0b2 is available on the Download Page.