News and Updates

SQLAlchemy release 0.9.0 is now available.

After about a year's worth of development, 0.9.0 is the first official release of the 0.9 series of SQLAlchemy. As always, 0.9 includes many major architectural improvements and new features.

To get an overview of SQLAlchemy 0.9's new features, see the What's New in 0.9 document. This document should also serve as a guide for those behavioral changes which may require adjustments to existing applications.

Highlights of SQLAlchemy 0.9.0 include in-place Python 3 support, major improvements to the eager loading system including a more expressive API and critical performance improvements to the rendering of more complex joins, support for Postgresql JSON types, SQL expression improvements such as textual "selectable" objects, "INSERT from SELECT" support, improved APIs for "SELECT..FOR UPDATE", schema and DDL improvements, and many other refinements. Architecturally, the move to Python 3 in place has allowed lots of consolidation to take place, and there has also been a major reorganization of module layout both within Core and ORM.

Existing production deployments which have not yet been tested in SQLAlchemy 0.9.0 should ensure that they specify a version less than 0.9.0 in their requirements files, as version 0.9.0 now becomes the default version of SQLAlchemy downloaded from Pypi when no version specifics are given.

Full changelog for the SQLAlchemy 0.9 series is at Changes; this document will also link out in many cases to the migration document mentioned above.

Download SQLAlchemy 0.9.0 on the Download Page.

SQLAlchemy release 0.8.4 is now available.

0.8.4 is a relatively early bugfix release, which includes one key feature critical to the recently relased 0.6.1 version of Alembic migrations.

The "reflect unique constraints" feature of 0.9 has been backported to 0.8.4. This feature, which retrieves a list of unique constraint objects from a schema, allows the new Alembic feature of autogenerate for indexes and unique constraints to function fully.

A key bugfix in 0.8.4 involves the QueuePool implementation. An issue was observed where the QueuePool implementation would block when a new connection attempt was stalled; other new connection attempts within concurrent threads would be paused until the stalled attempt completed or errored out. This issue has been resolved, as the section where new connections are created is no longer within a mutex.

The release otherwise includes a small set of minor dialect- and engine-level fixes.

Users should carefully review the Changelog to note which behaviors and issues are affected. We'd like to thank the many contributors who helped with this release.

SQLAlchemy 0.8.4 is available on the Download Page.

SQLAlchemy release 0.9.0b1 is now available.

This is the first beta release of the new 0.9 series, which features a wide array of behavioral improvements and features. It also includes all relevant bugfixes that have been applied to the 0.8 and sometimes the 0.7 series as develoment has continued. We strongly encourage users to download and evaluate 0.9.0b1, already in use in production environments, and to report back on issues promptly.

To get an overview of SQLAlchemy 0.9's new features, see the What's New in 0.9 document. This document should also serve as a guide for those behavioral changes which may require adjustments to existing applications.

Major highlights include:

• Runs on Python 2 and 3 with no 2to3 step needed.
• C extensions run on Python 3
• Major improvements to SQL rendering regarding ORM eager loading
• The event API is enhanced with the ability to remove listeners.
• Major improvements to composite attributes, association proxies
• New Query features including a rewritten "loader option" system with greater capabilities
• SQL expression language and schema improvements.

The release is being offered for download via Bitbucket files and not on Pypi, so that it is not installed automatically for those users using pip, since it is still in beta.

Download SQLAlchemy 0.9.0b1 on the Download Page.

SQLAlchemy release 0.8.3 is now available.

0.8.3 is a bugfix release containing several dozen fixes, and a few features backported from the upcoming 0.9.0b1 release planned for the same time.

Areas of improvement include ORM, Core, and fixes for dialects like that of MySQL, Postgresql, Oracle, and SQLite.

Users should carefully review the Changelog to note which behaviors and issues are affected. We'd like to thank the many contributors who helped with this release.

SQLAlchemy 0.8.3 is available on the Download Page.

SQLAlchemy release 0.8.2 is now available.

0.8.2 includes several dozen bug fixes and new features, including refinement of some of the new features introduced in 0.8.

Areas of improvement include Core, ORM, as well as specific fixes for dialects such as Postgresql, MySQL, Oracle, SQL Server, Firebird and Sybase.

Users should carefully review the Changelog to note which behaviors and issues are affected. We'd like to thank the many contributors who helped with this release.

SQLAlchemy 0.8.2 is available on the Download Page.