News and Updates

SQLAlchemy release 1.2.17 is now available.

Release 1.2.17 includes a fix to integer handling in the Oracle dialect specific to the 1.2 series, as well as two new event hooks in the ORM to assist with interception of bulk update and delete events.

Changelog for 1.2.17 is at Changelog.

SQLAlchemy 1.2.17 is available on the Download Page.

SQLAlchemy release 1.3.0b2 is now available.

As the second beta release in the 1.3 series, version 1.3.0b2 has a focus on looking towards the future, ensuring that all features and behaviors that are long since deprecated fully emit a warning as such to better allow them to be removed in subsequent releases, as well as that some major new deprecations are added. The goal is to apply more focus to the ORM and Core usage APIs to allow easier transition to an eventual next generation version of SQLAlchemy suited to a Python 3 only world.

Major changes in 1.3.0b2 include:

• The AliasedClass construct may now be specified as the target for a relationship, fully replacing the remaining rationale for the "non primary mapper" feature which becomes deprecated.
• The convert_unicode parameter on Engine and String is deprecated, as unicode handling is now supplied by all supported DBAPIs.
• The "threadlocal" engine strategy, long an obsolete behavior, is finally deprecated.
• Deprecation warning are emitted for all functions, methods, and parameters that have already been noted in the documentation as deprecated.

For an overview of what's new in the 1.3 series, see Whats New in 1.3? Full changelog is available at Changelog.

SQLAlchemy 1.3.0b2 is available on the Download Page.

SQLAlchemy release 1.2.16 is now available.

Release 1.2.16 includes a series of dialect and engine-level fixes, including one 1.2 regression involving Unicode decoding of DBAPI exception messages that contain non-ascii characters.

Changelog for 1.2.16 is at Changelog.

SQLAlchemy 1.2.16 is available on the Download Page.

SQLAlchemy release 1.2.15 is now available.

Release 1.2.15 includes a variety of ORM-level fixes, including one regression from 1.2.13 involving dynamic relationships with many-to-many relationships.

Changelog for 1.2.15 is at Changelog.

SQLAlchemy 1.2.15 is available on the Download Page.

SQLAlchemy's primary code-hosting repository is now GitHub.

The public source repository, issue tracker and wiki moves underneath a new organization which now is the home for SQLAlchemy as well as related projects Alembic, Mako Templates, dogpile.cache, and others.

The move from Bitbucket has been under consideration for well over a year, prompted by a long and slow decline in Bitbucket's quality as well as a complete lack of features and improvements to their issue tracker, ever since being acquired by Atlassian who sought to encourage users to move to Jira instead. Most critically, SQLAlchemy and related projects desperately needed the ability to apply free-form labels and classifications to issues in order to organize for common themes, as well as a capable search system and a modern, responsive web interface.

The massive technical challenge to this move was the ability to import SQLAlchemy's 4000+ issues into GitHub's issue tracker, as well as the many hundreds of issues associated with other projects. GitHub for many years lacked a usable issue import system which made the move a non-starter, but eventually a non-official issue import API was released, which after much effort was able to do just enough to make an issue import feasible, after several weeks of tweaking import scripts to format issues and their changes as well as to move thousands of web requests over a rate-limited system without being blocked.

Most recently, alternative self hosted systems like Gitea, which looks extremely promising, were considered as well, but in the end, SQLAlchemy would like to do everything it can to encourage community involvement, so it is hoped that the GitHub move will have this effect.

In addition to the move to GitHub, the SQLAlchemy organization has been set up as the owning namespace for these projects to further emphasize that SQLAlchemy is more than just "zzzeek".