News and Updates

This is a talk given at PyGotham 2011 in New York City. In this talk, I get into my latest thinking on SQLAlchemy's usage philosophy and cover a few architectural features that I discuss in my upcoming chapter for the book Architecture of Open Source Applications. Here's the slides in PDF Form: SQLAlchemy - an Architectural Retrospective.

SQLAlchemy release 0.7.2 is now available. This release contains many bugfixes for bugs present in both the 0.6 and 0.7 series, as well as some 0.7 only fixes and a few new features.

0.7.2 includes behavioral enhancements to joined- and subquery-eager loading, a new feature to the typing system called with_variant() which allows a single type to act as a different type on selected backends, and improved string displays for several kinds of exceptions. The documentation has also been improved for clarity in many areas.

More features and documentation improvements are on the way for 0.7.3, including some new Declarative features. The current focus of development is on fully standardizing SQLAlchemy documentation and usage patterns on Declarative, with most direct usage of the mapper() function intended for special cases and custom ORM configurational layers, created either in-house or as part of external open source extension layers.

The full changelog for version 0.7.2 is at CHANGES.

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

Download SQLAlchemy 0.7.2 on the download page.

Armin Ronacher introduces SQLAlchemy to the Django community in his latest post SQLAlchemy and You, a gentle introduction to the differences in philosophy between the SQLAlchemy and Django ORMs, with a good deal of specifics.

Armin is the creator of Flask, a fast-growing web framework that places an emphasis on the SQLAlchemy ORM for relational database usage.

SQLAlchemy release 0.7.1 is now available. This is a relatively small bugfix release for the new 0.7 series.

The release includes a workaround for a C compilation issue on 64-bit Windows systems, and a variety of other fixes. It also includes a new feature, in that the restriction on "delete-orphan" cascade for self-referential relationships has been lifted.

The full changelog for version 0.7.1 is at CHANGES.

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

Download SQLAlchemy 0.7.1 on the download page.

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.