News and Updates

With the release of SQLAlchemy 0.7.3 just two days ago, fixing a few remaining regressions from 0.6, the well known review site Yelp! has now successfully rolled SQLAlchemy 0.7 into production usage, migrating their codebase from 0.6 to run 0.7.3.

SQLAlchemy 0.7 represents the culmination of over six years of constant development, enhancement, and testing, forged by the invaluable feedback and field reports of hundreds of users and organizations. I'd like to thank everyone who's chipped in over the years from our core contributors to new users reporting bugs and requesting clarification - every interaction goes directly towards improving the product, and there's many more on the way. And congratulations to Yelp!

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.

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.