News and Updates

April 18, 2010 permalink
by Mike B

SQLAlchemy 0.6 is now released. This release is the culmination of well over a year of effort towards restructuring and enhancements. Highlights of SQLAlchemy 0.6 include:

Support for Python 2.4+, Python 3, and Jython
Decouping of DBAPI adapters and database dialects allow any number of DBAPIs to be cleanly supported.
Support for Sybase, mxODBC, pg8000, py-postgresql, OurSQL, MySQL-Connector-Python, zxjdbc is added, including new options and capabilities for many dialects (see the compatibility chart).
Enhancements to "eager loading", including a new "subquery" eagerload that loads all collections using a maximally efficient query-per-relationship scheme.
An entirely new unit of work system which runs more effectively and simply, using less memory and CPU.
A flexible SQL compiler and execution system, now supporting RETURNING clauses when available, clause constructs for DDL elements (i.e. CREATE TABLE) and type objects, stricter SQL standard compliance where needed, and an extension system allowing the creation of new SQL constructs and open-ended extension to those provided.
Query result caching capability, including an example illustrating integration with Beaker.

SQLAlchemy 0.6 has already been in production usage for several months and has been tested by hundreds. Be sure to review the full list of whats new at 06Migration.

Pycon 2010 Sprints the Biggest Ever

February 25, 2010 permalink
by Mike B

The sprinting continues today in Atlanta after a week where at least a dozen people got involved, some new to SQLAlchemy, some veterans. New things coming out include our all-new buildbot, as well as several new dialects which are Python 3 compatible - PyPostgreql, OurSQL, MySQL-connector-Python. Python 3 tests are passing 100% for pg8000 and OurSQL, so Postgresql and MySQL are now covered for Python 3. We also have mxODBC for MSSQL in the works and have made a great leap forward in getting real Sybase support. Plus documentation updates galore, new declarative features, and a whole host of fixes and enhancements elsewhere. We'll soon be posting links to SQLAlchemy related talks and tutorials from Pycon 2010 as they become available. Thanks to everyone for the huge amount of involvement and stay tuned for SQLAlchemy 0.6 !

SQLAlchemy 0.6 On Its Way

August 07, 2009 permalink
by Mike B

SQLAlchemy 0.6 is now on trunk, with release candidates to come soon. Jython compatibility is near 100% for MySQL and Postgresql, with work being done for Oracle + JDBC as well. Oracle tests using cPython pass at 100% and compatibility is also introduced for MSSQL via PyODBC with FreeTDS, allowing any unix platform to access MSSQL (one user is testing it against Sybase ASE as well with a good deal of success). INSERT RETURNING support is also implemented natively for Postgresql, Oracle, MSSQL and Firebird and is used when available to fetch newly generated primary key identifiers.

The release of 0.6 will solidify the best architecture yet for maximum Python platform, DBAPI, and database backend compatibility, allowing new DBAPIs and architectures to be plugged in with minimal hacking.

The in-progress documentation of what's new is at 06Migration.

Python 3K, pg8000 Support in SQLAlchemy 0.6

June 02, 2009 permalink
by Mike B

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.

Checkout Now Available at the Apple Store

June 02, 2008 permalink
by Mike B

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