News and Updates

SQLAlchemy release 0.6.8 is now available. This is a maintenance release for the 0.6 series - the current series of SQLAlchemy is 0.7.

The release includes a series of bugfixes, as well as a backport of 0.7's identity map implementation which fixes some stability issues.

The full changelog for version 0.6.8 is at CHANGES.

For a full description of version 0.6 of SQLAlchemy including migration information, see What's New in SQLAlchemy 0.6?.

Download SQLAlchemy 0.6.8 on the download page.

The SQLAlchemy project is pleased to announce version 0.7.0 of SQLAlchemy, the first production release within the 0.7 series. 0.7 represents the past year's worth of development, streamlining APIs, adding new features, solidifying the core and improving performance. Key highlights of version 0.7 include:

• New event system applies a consistent and flexible approach to the task of extending SQLAlchemy, both within the core and the ORM. The previous system of ad-hoc "extension" and "listener" classes is replaced by a single function event.listen() which can apply listeners to a wide variety of hooks. Read more at Intro to events.
• A new extension allows easy creation of "hybrid" attributes, attributes that provide Python expression behavior at the instance level and SQL expression behavior at the declarative (class) level. Read more at Hybrid Attributes.
• A new system of building so-called "mutable" attributes, column-mapped values which can change their value in-place. Detection of changes now uses change events and solves the previous issue of full unit-of-work scans for such attributes. Read more at Mutable Scalars.
• Major speed improvements, including batching of INSERT statements when possible, greatly reduced codepaths for many key operations. Check out the RunSnakeRun diagrams at A Tale of Three Profiles.
• C extensions, battle tested after a year of use in 0.6, now build by default on install for CPython platforms.
• Pypy is fully supported.
• Dialect support for Psycopg2 on Python 3, Drizzle, pymysql added.
• Documentation and example updates, including a modernized, declarative version of polymorphic associations.
• Many, many core and ORM behavioral improvements. See the almost-full list at 07Migration.

Thanks to everyone who's contributed via code, bug reports, infrastructure support, production testing. SQLAlchemy 0.7.0 is available on the download page.

Thanks to all who participated in this year's sprints at Pycon 2011. The releases of 0.6.7 and 0.7b4 owe a lot to what the group got done, including Pypy test coverage, unit test improvements, dialect fixes, lots of documentation tweaks and edits, some impressive ORM fixes, and other features. The sprints have also fostered an ongoing discussion on how we can keep the mailing lists diverse and increase the rate of communication - some website changes have already been made, including this blog, and more are in the works.

If I left a name out, please let me know !

• Brad Allen
• Lukas Blakk
• Taavi Burns
• Diana Clarke
• Alex Gaynor
• Denise Govindarajan
• Toby Ho
• Phil Jenvey
• Jason Kirtland
• Joel Mohler
• Jim Phares
• Mark Sharp
• Michael Trier - co organizer

Beta 4 of SQLAlchemy 0.7 has been released. This is most likely the last beta of version 0.7 before final release. 0.7 has been downloaded many hundreds of times and a small series of regressions have been fixed; it is used in at least a few production installations already.

Of particular note in this release:

• Support for psycopg2, the Postgresql driver, on Python 3
• The C extensions now build by default for the Python 2 platform.
• Support for Python 3 builds using plain Python Distutils, or Distribute.
• Full test success for Pypy, Python 3.2
• Lots of bugfixes and revised documentation, including the new Revised index page.

0.7beta4 owes a lot to the sprinters at this year's Pycon; a subsequent blog post detailing the sprints for this year is coming soon.

The SQLAlchemy 0.7 series represents a great leap forward in functionality and performance - the upgrade path starts by reviewing the 07Migration document.

Changes can be reviewed at CHANGES; download SQLAlchemy 0.7beta4 on the download page.

SQLAlchemy release 0.6.7 is now available. This is a bugfix release to the 0.6 series, which is now mostly feature frozen. The 0.7 series has been the focus of new feature development for several months and is very near to production release - 0.6.7 represents all those bugfixes that were appropriate for a backport to the maintenance series.

The 0.6 series has been SQLAlchemy's most popular ever, with 0.6.6 alone logging over 52,000 downloads in just over three months.

For a full list of changes in 0.6.7, see CHANGES.

For a full description of version 0.6 of SQLAlchemy including migration information, see What's New in SQLAlchemy 0.6?.

Download version 0.6.7.