On Tue, Jan 6, 2009 at 3:42 PM, Michael Bayer <[email protected]> wrote: > > Hello list - > > I am pleased to announce the release of SQLAlchemy 0.5.0, the first > official release in the 0.5 series. This series has been in the > making since the Pycon 2008 sprints, where we first began reorganizing > the ORM attribute system and adding comprehensive rollback and > SAVEPOINT support to the session. > > To really get a sense of what's new, the > http://www.sqlalchemy.org/trac/wiki/05Migration > document points to most of it, and a good read of the ORM tutorial > and the session documentation illustrate the major paradigm shifts of > the 0.5 series. The most profound changes are: > > * Query can now select any combination of entities/columns, ORM > enabled or not. > * The Declarative approach is widely tested and should be considered > a first choice for many applications. > * The Session actively expires its state after a commit operation > and can revert its internal state after a rollback (all of which is > configurable since it results in a lot more SQL being issued). > SAVEPOINTs are very usable. > * Query's ability to create joins automatically or semi- > automatically using query.join() is greatly enhanced. > * Query can issue updates and deletes directly based on criterion. > * The joined and single table inheritance systems, particularly from > a Query perspective, are dramatically improved. > * The ORM has many new extension points including > AttributeExtension, SessionExtension, and comparator_factory. > * The method of configuring schema-level column defaults has been > simplified. > * The MS-SQL dialect is vastly improved and actively supported > thanks to the tireless efforts of Michael Trier. > * Speed increases are in the 20% range over 0.4. > * The documentation has been converted to Sphinx, and a new > searchable API Reference section has been created. > * Python 2.3 is no longer supported. > > The 0.5 series was prereleased through a series of four release > candidates over a period of many months, so many production > applications are already using the 0.5 series of SQLAlchemy, including > Armin Ronacher's new blogging application Zine: http://zine.pocoo.org/ . > > Also in development is the 0.6 series of SQLAlchemy, which is where > we've targeted our dialect overhaul that will allow DBAPIs to interact > with database dialects in an agnostic way - this will lead to easy > support to backend-agnostic dialects like zxJDBC, mxODBC, pyodbc, as > well as alternate dialects like pg8000 which are proving to be "faster > to the punch" in terms of Py3K. Our Py3K support is targeted towards > 0.6 where we're anticipating that its DBAPI agnosticism will allow us > to mobilize quickly towards new Py3K drivers as they are released. > > Download SQLAlchemy 0.5 at: http://www.sqlalchemy.org/download.html > Migration: http://www.sqlalchemy.org/trac/wiki/05Migration > Changelog: > http://www.sqlalchemy.org/trac/browser/sqlalchemy/tags/rel_0_5_0/CHANGES >
Awesome thanks for this. We are going to delay TG2.0b2 a little bit so we can build a new index with SA0.5.0. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
