News and Updates

SQLAlchemy release 0.7.6 is now available. Released from Pycon 2012, this release starts getting us ready for the 0.8 series, adds some new features such as support for Common Table Expressions, and also has some important bug fixes.

For a full list of changes including all bug fixes, see 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.6 on the download page.

SQLAlchemy release 0.7.5 is now available. This release includes some major bugfixes, as well as a handful of new features:

• Relationship loaders like joinedload() accept a "wildcard" character, e.g. '*', to establish the "default loading strategy" for a query.
• New reflection features allow autoloading of tables to be smoothly integrated with Declarative mappings, allowing database connectivity to be established in a later step after classes have been defined.
• Multiple Declarative bases can share the same registry of class names.

For a full list of changes including all bug fixes (27 in total), see 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.5 on the download page.

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!