News and Updates

SQLAlchemy 1.4.5 is now available.

Release 1.4.5 includes the next round of mostly small regressions and bug fixes for the 1.4 series. The most major change in this release is that the "statement caching" feature has been changed to be "opt in" for third party dialects, after the identification of some patterns in some dialects that are not compatible with statement caching. Third party dialects that want to add support for statement caching should set the supports_statement_cache flag on each dialect subclass that they implement, and then test that SQL statements which include literal Python values, particularly those used for LIMIT/OFFSET, are rendered correctly as they change across executions for the same statement. See the changelog for further details.

The above issue was also identified in the Oracle dialect, so all Oracle installations using the 1.4 series should upgrade to 1.4.5.

Support for the Mypy plugin is still ongoing; while there are some Mypy fixes in this release, there are still additional known issues which will be resolved in upcoming releases. The sqlalchemy2-stubs package is also undergoing rapid development and should be improving significantly in the coming weeks.

Huge thanks to our userbase and core development team for working to make release 1.4.5 possible.

The complete changelog for 1.4.5 is at Changelog.

SQLAlchemy 1.4.5 is available on the Download Page.

SQLAlchemy 1.4.4 is now available.

Release 1.4.4 includes a short set of mostly minor bug fixes, and a small fix for one significant issue in the new PropComparator.and_() method which can be used to apply custom criteria to relationship loads where bound parameters would not be applied correctly.

The primary development effort within the 1.4 series is further fixes and improvements to the Mypy plugin as well as the related sqlalchemy2-stubs package. Upcoming fixes to those features involve more significant development of new test suites so are not included in 1.4.4 as of yet. Mypy plugin work continues to go well as some difficult issues integrating with Mypy have been figured out.

Huge thanks to our userbase and core development team for working to make release 1.4.4 possible.

For users migrating from 1.3, the first stop is the What's New in 1.4? document which will provide an overview of how to get started with SQLAlchemy 1.4.

The complete changelog for 1.4.4 as well as all the beta releases is at Changelog.

SQLAlchemy 1.4.4 is available on the Download Page.

SQLAlchemy release 1.3.24 is now available.

Release 1.3.24 provides a series of bugfixes for the 1.3 series of SQLAlchemy, which are all effectively backports from the 1.4 series, now in production releases.

As is the case with all releases, we'd like to thank all the contributors who helped with this release.

Changelog for 1.3.24 is at Changelog.

SQLAlchemy 1.3.24 is available on the Download Page.

SQLAlchemy 1.4.3 is now available.

Release 1.4.3 continues with small fixes and additionally introduces support for the aiosqlite asyncio API for SQLite.

Huge thanks to our userbase and core development team for working to make release 1.4.3 possible.

For users migrating from 1.3, the first stop is the What's New in 1.4? document which will provide an overview of how to get started with SQLAlchemy 1.4.

The complete changelog for 1.4.3 as well as all the beta releases is at Changelog.

SQLAlchemy 1.4.3 is available on the Download Page.

SQLAlchemy 1.4.2 is now available.

As the large number of small regressions and new feature issues being reported has continued beyond version 1.4.1, version 1.4.2 now has the next batch of fixes. Release 1.4.2 includes mostly more regression fixes, all of which are "one-liner" fixes, as well as a new use case supported by Dataclasses feature allowing declarative mixins with @declared_attr to work as Dataclasses.

Continued thanks to the users submitting great bug reports and our core development team working all week to solidify the 1.4 release.

For users migrating from 1.3, the first stop is the What's New in 1.4? document which will provide an overview of how to get started with SQLAlchemy 1.4.

The complete changelog for 1.4.2 as well as all the beta releases is at Changelog.

SQLAlchemy 1.4.2 is available on the Download Page.