News and Updates

SQLAlchemy release 0.7.4 is now available. This release contains a bunch of new features, including:

• UPDATE..FROM support
• more configuration options for polymorphic_on
• new schema options with MetaData
• new reflection options
• new features with the ENUM type on Postgresql
• SAVEPOINT for MS SQL Server
• A new usage pattern with Hybrid attributes

Like every point release, 0.7.4 also contains plenty of bugfixes in all areas.

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

Alembic is a new migrations tool for SQLAlchemy. Building on the knowledge gained by the SQLAlchemy-Migrate project, Alembic is an up-to-date, semi-automated system of maintaining versioned database schemas. Today marks the very first alpha-level release of 0.1.0, after an intense push to fill out the initial round of features and usage patterns.

Alembic's key features include support for transactional DDL, automated generation of candidate changesets, non-linear versioning, support for static SQL script generation, support for multiple databases, and an extremely open-ended configurational system, based on an environmental API in conjunction with pre-packaged sample environments. It is currently used in one complex multi-database production environment against Postgresql and MS SQL Server; initial support for MySQL is also included.

Alembic's documentation is at http://packages.python.org/alembic/.

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.