News and Updates

SQLAlchemy 0.7.3 Released
permalink

SQLAlchemy release 0.7.3 is now available. After a long delay since 0.7.2, this release contains many new features and bugfixes, and fixes some remaining regressions left over since 0.7 was released.

0.7.3 includes enhancements to the join() method of Query, support for Python 3's enhanced function arguments when mapping classes, new Declarative features including helpers for so-called "concrete inheritance" configurations, new event hooks, improved logging of large parameter sets, new keyword arguments for indexes specific to Postgresql and MySQL.

The full changelog for version 0.7.3 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.3 on the download page.

SQLAlchemy at PyGotham
permalink

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 0.7.2 Released
permalink

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.

SQLAlchemy for Django Users
permalink

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 0.7.1 Released
permalink

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.