News and Updates

SQLAlchemy release 1.0.0b3 is now available.

This is an emergency re-release of 1.0.0b2 to repair an erroneous commit.

Changelog for 1.0.0b3 is at:

Changelog.

SQLAlchemy 1.0.0b3 is available on the Download Page.

SQLAlchemy release 1.0.0b2 is now available.

This is the second pre-release in the 1.0.0 series which includes a small handful of regression fixes and some additional features. We'd like to thank those who have been beta testing the 1.0.0 series and encourage all beta testers to upgrade to beta2!

Users should carefully review the Migration Document for 1.0 for the 1.0 series overall, as well as the Changelog to note which behaviors and issues are affected in this release. We'd like to thank the many contributors who helped with this release.

SQLAlchemy 1.0.0b2 is available on the Download Page.

SQLAlchemy release 1.0.0b1 is now available.

This is the first beta release in the new 1.0 series of SQLAlchemy. Users are encouraged to ensure that their pip installations are up-to-date, so that version 1.0.0b1 will only install if explcitly specified using the --pre flag.

Release 1.0.0b1 features a large degree of internal rearchitecture, new features, and bug fixes. Key highlights include:

• Improved Performance - Function call counts are reduced in many areas across the library, including Core execution and result set formulation, ORM query construction, ORM result set fetching, mass object expiration, and ORM persistence. The memory footprint of an ORM application is also greatly reduced by rolling out the use of __slots__ across a wide array of internal structures.
• New Performance Features - for even more performance gains, new APIs are introduced to the ORM which can dramatically improve the performance of certain operations. See features such as Baked Queries and Bulk Insert/Update API. New documentation and examples regarding performance are added as well, including the new example performance suite.
• New Dialect Features - In particular, the Postgresql, MySQL, and SQLite dialects have significant changes, in particular regarding improved datatype support and improved database reflection.
• Dozens of other improvements - Small but useful improvements like removing the need for use_alter and autoload_with implies autoload=True are part of a long list of changes which can be seen in the What's new in 1.0? document.

Users should carefully review the migration document as well as the Changelog to note which behaviors and issues are affected. We'd like to thank the many contributors who helped with this release.

SQLAlchemy 1.0.0b1 is available on the Download Page.

SQLAlchemy release 0.9.9 is now available.

Release 0.9.9 is a large maintenance release featuring 30 changes, mostly bug fixes. A handful of modest feature adds are also present, including new Core features for SQLite, Postgresql, and new API features to provide better control of transaction isolation level when using the ORM.

The majority of SQLAlchemy development is taking place targeted at version 1.0, which is extremely close to having its initial beta releases. Version 1.0 has accumulated a wide variety of performance improvements, both as intrinsic to normal operation as well as via new features.

Users should carefully review the Changelog to note which behaviors and issues are affected. We'd like to thank the many contributors who helped with this release.

SQLAlchemy 0.9.9 is available on the Download Page.

SQLAlchemy release 0.9.8 is now available.

As the 1.0 series is well underway, 0.9.8 continues to close out bugs that can still be applied without significant risk of destabilization. In contrast to 0.9.7 where we were still hitting upon regressions, 0.9.8 fixes a set of garden variety bugs, many of which are related to changes in DBAPIs (new SQL Server version strings, new Psycopg2 error conditions, changes in MySQL-connector-python and pg8000). That being said, 0.9.8 has a relatively large amount of fixes overall.

Users should carefully review the Changelog to note which behaviors and issues are affected. We'd like to thank the many contributors who helped with this release.

SQLAlchemy 0.9.8 is available on the Download Page.