News and Updates

SQLAlchemy 1.0.0 Released


SQLAlchemy release 1.0.0 is now available.

Release 1.0.0 marks the tenth major SQLAlchemy series and occurs within the tenth year of the SQLAlchemy project overall; development started in 2005 and the release of 0.1.0 was in February of 2006.

Calls for SQLAlchemy to go "1.0" started early on, as early as version 0.3 (!). However, the magnitude of the task taken on by SQLAlchemy was much broader than that; the development philosophy taken by the project is one of slowly building out a wide-reaching base of functionality, integrating many rounds of refactoring and rethinks over a long period of time and building new paradigms and features on top only as the foundation matures enough to support them.

Users of 1.0 have the benefit of ten years of production deployments, total rethinks of core APIs in early versions, a vast number of API additions and refinements over later versions, at least a dozen major internal rearchitectures, and as always a relentless focus on improving performance.

The SQLAlchemy project could not be what it is today without the unbelievable support, input, and sheer love of the user community - from the vast amounts of knowledge and improvements gained from tens of thousands of mailing list messages, to the improvements hammered out through over three thousand bug reports, to the amazing developers all around the world who have presented talks and tutorials on SQLAlchemy and of course the audiences who continue to attend them, to the bloggers and book authors supporting our community, to the tweeters sending gratitude our way, to our many hundreds of contributors of patches and pull requests, as well as financial contributors who have consistently supported SQLAlchemy's hosting costs, as well as more than a few burritos ;).

In particular, SQLAlchemy's success was made possible by its original developer team, and I would like to express to all of them my very deep gratitude for their tremendous efforts towards contributing code and wisdom to the project, as well as support of my work from very early on:

  • Jason Kirtland
  • Gaëtan de Menten
  • Diana Clarke
  • Michael Trier
  • Philip Jenvey
  • Ants Aasma
  • Paul Johnston
  • Jonathan Ellis

I'd also like to thank Simon King and Jonathan Vanasco for their ongoing contributions towards the mailing list, Alex Grönholm, creator of the excellent sqlacodegen project, for his energetic and ubiquitous support of thousands of IRC users, and Sanjiv Singh, early developer of GeoAlchemy, for the awesome set of drink coasters I use every day :).

Release 1.0.0 features an array of usability enhancements, new features, bug fixes, and considerable performance enhancements. After five short beta releases, it is anticipated that the impact of upgrading from 0.9 or even 0.8 to 1.0.0 should be minimal; however in all cases, users are highly encouraged to carefully read through the behavioral enhancements and changes documented in the 1.0 migration notes, at What's new in 1.0?

Changelog for 1.0.0 is at:


SQLAlchemy 1.0.0 is available on the Download Page.

SQLAlchemy 1.0.0b5 Released


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:


SQLAlchemy 1.0.0b5 is available on the Download Page.

SQLAlchemy 1.0.0b4 Released


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:


SQLAlchemy 1.0.0b4 is available on the Download Page.

SQLAlchemy 1.0.0b3 Released


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:


SQLAlchemy 1.0.0b3 is available on the Download Page.

SQLAlchemy 1.0.0b2 Released


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.