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 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
