Tue, 02 Jun 2009
As of this past weekend,
100% of tests pass on Python 3000 using
the up-and-coming 0.6 series of SQLAlchemy, while running on sqlite via the sqlite3 adapter
as well as Postgresql via the
pg8000 DBAPI.
Jython compatibility is largely present as well. The 0.6 series has
a special focus on environment and dialect compatibility, as well as on schema construct and DDL improvements.
Developers will have full access to new expression constructs such as CREATE TABLE and ADD CONSTRAINT, with the ability
to define new ones. It is now possible to construct custom create/drop sequences which add constraints, triggers
and other DDL using rules that are sensitive to the underlying database in use - and will allow smoother integration
with
sqlalchemy-migrate too. 0.6 should be merged to trunk
soon with alpha releases by mid-summer.
Tue, 06 Jan 2009
In progress since Pycon 2008, the first official release of the 0.5 series is now available. This version packs a huge amount of change since 0.4 including multiple paradigm shifts in usage as well as countless bugfixes and behavioral and speed improvements. Through a series of prereleases, 0.5 is already on production systems and has been extensively tested by dozens of users. With the first 0.5 release, 0.6 is underway as well and will be where Py3k support is targeted. SQLAlchemy 0.5 is available for download on the
download page. A comprehensive migration document is at
05Migration.
Mon, 02 Jun 2008
Checkout 2.0 is now available from every Apple store as well straight from
Madebysofa; it's the software that turns any Mac into an event-driven networked cash register and inventory system. Version 2.0 is built entirely on SQLAlchemy interfacing with SQLite. The guys from Madebysofa just shipped me a free boxed copy (shown at left). SQLAlchemy however has no plans to start charging ;) .
Mon, 26 May 2008
O'Reilly's new book
Essential SQLAlchemy, written by Rick Copeland, will be available in June, 2008. This is one of two current book projects for SQLAlchemy, the other being
Database Access with SQLAlchemy, in the works by several authors including Mark Ramm, author of
Rapid Web Applications with Turbogears. Early reviews of
Essential look promising, and it will most likely cover through the 0.4 series of SQLA.
Thu, 27 Mar 2008
This year's Pycon had a lot of SQLA activity. There was a full day of tutorials as well as a conference talk, and a good deal of cross-project pollination, including sprint activity with members of the Jython, Django, and Zope communities. There's two new development branches underway which both got a lot of attention at the sprints, both of which will be merged to trunk in the near future. Read more about this year's event and download presentations at
Pycon Wrapup.
Fri, 15 Feb 2008
Antonio Cangiano has
announced that IBM's SQLAlchemy dialect for DB2 is finally a reality. A driver for Informix IDS is also in the works. The project is hosted on
Google Code and the mailing list has already started buzzing. Thanks much to IBM for their contribution to the Python community !
Wed, 17 Oct 2007
The first production release of 0.4 is now available. After six separate beta releases, the final 0.4 represents the hard work of many contributors with over a hundred new fixes and improvements after the the initial 0.4 beta1 release. 0.4 overall represents the largest overhaul SQLAlchemy has had yet, with its most refined and feature-filled ORM, SQL expression, and transactional APIs ever, all new documentation, a rewritten compiler, massive refactorings and speed refinements to the execution system and ORM, and more support for more databases, including experimental support for Sybase and MS Access.
Dozens of users have already upgraded their SQLAlchemy 0.3 applications to 0.4, and the upgrade path has been carefully tailored to be as painless as possible. Typical performance increases are between 30% and 50% depending on usage. To get started, visit the docs and download.
