News

Checkout Now Available at the Apple Store

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 Postgres. The guys from Madebysofa just shipped me a free boxed copy (shown at left). SQLAlchemy however has no plans to start charging ;) .

Essential SQLAlchemy Available in June

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.

Pycon 2008 Wrapup

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.

IBM Produces DB2 Driver for SQLAlchemy

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 !

SQLAlchemy 0.4.0 Released

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.

First Beta of SQLAlchemy 0.4 Released

The first beta release of SQLAlchemy's 0.4 series is released. Version 0.4 is the biggest new version of SA ever, featuring a huge list of new capabilities and features. SQLAlchemy is now very community owned with more developers, users and contributors then ever; and we've responded to user needs across a wide number of areas and rolled out new capabilities far beyond SA's original scope.

Check out the rewritten docs and 0.3 migration guide then download !

SQLAlchemy: The Book

Due for publishing by Pycon 2008, Database Access with SQLAlchemy is being written for Prentice Hall by Mark Ramm and Michael Bayer. The book will feature front-to-back coverage of SQLAlchemy's full list of capabilities, including in-depth studies of engine/metadata configuration strategies, advanced mapping scenarios, and case histories. Code examples and concepts will be against the upcoming 0.4 release of SQLAlchemy, which includes lots of new features such as configuration-free polymorphic loading and a simplified, all generative Query interface.

Chapters will be available for PDF download via Rough Cuts within the coming months.