News and Updates

SQLAlchemy 1.0.0b5 Released

permalink

SQLAlchemy release 1.0.0b5 is now available.

This release is yet another set of fixes for issues reported by beta testers. At this point, 1.0.0 is ready to go and should be released very soon.

In preparation for 1.0.0, production installations that haven't yet been tested in the 1.0 series should be making sure that their requirements files are capped at 0.9.99, to avoid surprise upgrades.

Changelog for 1.0.0b5 is at:

Changelog

SQLAlchemy 1.0.0b5 is available on the Download Page.

SQLAlchemy 1.0.0b4 Released

permalink

SQLAlchemy release 1.0.0b4 is now available.

This release contains a handful of fixes and enhancements mostly to address issues that were reported by beta testers. Things are looking very good and it's hoped that maybe this will be the last beta, unless a host of new regressions are reported.

In preparation for 1.0.0, production installations that haven't yet been tested in the 1.0 series should be making sure that their requirements files are capped at 0.9.99, to avoid surprise upgrades.

Changelog for 1.0.0b4 is at:

Changelog

SQLAlchemy 1.0.0b4 is available on the Download Page.

SQLAlchemy 1.0.0b3 Released

permalink

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 1.0.0b2 Released

permalink

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 1.0.0b1 Released

permalink

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.