News and Updates

SQLAlchemy 1.2.18 Released


SQLAlchemy release 1.2.18 is now available.

Release 1.2.18 includes a series of dialect-level fixes as well as a few ORM fixes. Of note is another fix in a series of fixes involving a MySQL 8.0 related issue which impacts table reflection on Windows platforms.

Changelog for 1.2.18 is at Changelog.

SQLAlchemy 1.2.18 is available on the Download Page.

SQLAlchemy 1.3.0b3 Released


SQLAlchemy release 1.3.0b3 is now available.

Release 1.3.0b3 should hopefully be the last beta release for 1.3, as no additional major changes are planned. This release adds further restrictions on deprecated behaviors, most notably removing most instances of automatic coercion of Python strings that contain SQL fragments into text() objects; this behavior has been emitting warnings since 1.0 so should not be something in use by applications by now; as it has become an obscure feature it starts to look more like a bug rather than a deprecated behavior, so the warnings are now full exception messages.

The release also includes a variety of related improvements in the area of SQL identifiers and quoting, as well as some ORM-specific improvements. Finally, support for the Nose testing framework has been removed; SQLAlchemy has standardized on Py.test for some years now and Nose no longer worked as a test platform under Python 3 in any case.

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.0b3 is available on the Download Page.

SQLAlchemy 1.2.17 Released


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 1.3.0b2 Released


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 1.2.16 Released


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.