News and Updates

The What's new in 0.8 document is now published on the wiki. The work for 0.8 is around 70% completed with the majority of "hard" reworkings finished, broken up among various patches and Bitbucket repositories at the moment but soon to be merged into a comprehensive 0.8 tree that will ultimately push 0.7 into a maintenance branch.

0.8 so far has overall fewer changes than any previous major version, though a few are significant. It's very likely that 0.8 will pick up a bunch more changes before it lands its first beta release.

So far, the version is set to be called 0.8 but there's at least some possibility it could be called 1.0 - stay tuned for news on that !

0.8 Migration

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/.