News

Python 3K, pg8000 Support in SQLAlchemy 0.6

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.

SQLAlchemy 0.5.0 Released

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.

Checkout Now Available at the Apple Store

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 ;) .

Essential SQLAlchemy Available in June

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.

Pycon 2008 Wrapup

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.

IBM Produces DB2 Driver for SQLAlchemy

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 !

SQLAlchemy 0.4.0 Released

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.

View Older News