News and Updates

SQLAlchemy release 1.0.9 is now available.

Release 1.0.9 is a bugfix release, pushing out a collection of mostly small fixes that have accumulated over the past few months. In particular there is one small but important fix for users of the latest cx_Oracle library (5.2 or greater) in conjunction with Python 3 that corrects for an important issue in correctly detecting the version of this DBAPI and its Unicode behavior.

Primary development of new features, architectural and behavioral improvements continues within the 1.1 series targeted at early 2016 for initial beta releases.

Changelog for 1.0.9 is at:

Changelog

SQLAlchemy 1.0.9 is available on the Download Page.

Alembic 0.8.0 is now available.

This release includes a large series of reorganizations in order to provide several new extension APIs which dramatically increase the degree to which Alembic can be extended.

The average Alembic environment should hopefully not notice anything different as we've strived to maintain full backwards compatibility. However, both the "operations" and the "autogenerate" features have been entirely reorganized in order to produce a much more open-ended and integrated flow between these two systems.

At the base of the new system, everything in Alembic that is an "operation" is now boiled down into an object, known as a MigrateOperation. Subclasses of MigrateOperation include familiar things like AddColumnOp, CreateForeignKeyOP, and DropTableOp. These objects don't represent the SQL that we emit for these operations, but instead, represent the operation as defined in Alembic as part of the interface. On these objects we now hang all functions as related operations, including how it is linked to the alembic.op.* namespace, how autogenerate renders it in Python, how autogenerate produces a "diff" of it against a database, how it is implemented against the DDL backend, and many more things.

With this new system, we haven't necessarily added any new functionality that wasn't there before, but we've now organized all the things we know about an "Alembic operation" centered around this object using now-public APIs to associate operations with each one.

What this means is that you can now:

• create your own Alembic operations freely, which become available as first-class functions in alembic.op.* like any other
• create your own autogenerate schemes for these operations, including defining how to do the database compare as well as render the Python
• Modify completely what autogenerate does when it produces a new migration script; the entire contents of a generated script are delivered in object form to user-available hooks which can then rewrite the structure completely. The autogenerate operation can be made to generate multiple files to different directories and/or branches, or no files at all. A helper is also provided to make it easy to write short replacements of specific elements. Common user requests such as having autogenerate not produce a file if there were no net changes, converting an "add column" operation into an "add column, nullable=True" + "alter column set not null", or supporting alternative migration flows such as splitting migrations into "expand" and "contract" branches are now easily scriptable with no need to add new flags and switches to Alembic itself.
• Create applications that can receive an autogenerate stream and push it out directly as Alembic operations to a live database or SQL script, without even generating any revision scripts.
• Create alternative series of implementations for Alembic operations, such as writing them out to JSON or XML formats or perhaps building up a live MetaData structure based on them.

The release also includes a few other fixes and features. In particular, in conjunction with the reorganization of operations, there is also a renaming of positional arguments in the alembic.op.* namespace, however a backwards-compatibility translation layer is included so that most projects should be unaffected. The full list of name changes is listed in the changelog.

Download Alembic 0.8.0 at: https://pypi.python.org/pypi/alembic/

Full changelog, including new features, bugfixes, as well as links to all Operations methods where positional argument names that have changed, are at: http://alembic.readthedocs.org/en/latest/changelog.html#change-0.8.0.

Thanks to everyone in the community who has helped with this release in the form of patches, pull requests, bug reports, and mailing list commentary.

SQLAlchemy release 1.0.8 is now available.

Release 1.0.8 comes almost immediately after 1.0.7, as a new issue involving the connection pool has been identified and fixed which impacts any application that relies upon consistent behavior of the .info dictionary on a connection that is undergoing reconnect attempts. Applications and libraries which make use of connection pool event handlers may benefit from this release, as it repairs the behavior of the .info dictionary and reduces the likelihood of stale connections being passed to the "checkout" handler.

Changelog for 1.0.8 is at:

Changelog

SQLAlchemy 1.0.8 is available on the Download Page.

SQLAlchemy release 0.9.10 is now available.

This is a maintenance release of the 0.9 series, delivering an array of bug fixes and small feature enhancements which typically have been backported from the 1.0 series. As the 1.0 series has been in production use for some months now, the 0.9 series is expected to receive only critical bugfixes subsequent to this version.

Changelog for 0.9.10 is at:

Changelog

SQLAlchemy 0.9.10 is available on the Download Page.

SQLAlchemy release 1.0.7 is now available.

This release contains a series of regression fixes, some additional bugfixes, and a few new Core level features, including a new .cast() method available on column constructs as well as support for many new keywords used in creating sequences.

Next on the roadmap for SQLAlchemy are the beginnings of the 1.1 series; the 1.1 milestone has already accumulated several dozen proposed bugfixes and features. Look for development and documentation of the 1.1 series to begin within the coming weeks.

Changelog for 1.0.7 is at:

Changelog

SQLAlchemy 1.0.7 is available on the Download Page.