Sat, 12 Feb 2011
The first beta release of SQLAlchemy 0.7 is now available. This release features the past year's
worth of new features, improvements, and usage patterns, including an all-new, unified event model,
new extensions including so-called "hybrid" attributes as well as a new system of tracking changes on "mutable"
scalar values, extensive performance improvements, new dialects, and a large number of other features
and bug fixes. A full catalog of changes can be reviewed at 07Migration.
Download SQLAlchemy 0.7 beta1 on the download page.
Sun, 05 Dec 2010
SQLAlchemy 0.7 is in active development and close to beta releases, featuring an all new
unified event model as well as a host of other ORM and SQL engine features and improvements.
The "Whats New" page for SQLAlchemy 0.7 is under construction at 07Migration.
Sun, 18 Apr 2010
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.
Thu, 25 Feb 2010
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 !
