News and Updates

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.

SQLAlchemy 1.4.1 is now available.

The response to the SQLAlchemy 1.4.0 release has been large and enthusiastic. In a testament to how widely used it is, within one day we got plenty of new issue reports for mostly small and fairly edge-case issues like naming conflicts introduced by new APIs and such. SQLAlchemy 1.4.1 has the first batch of fixes for these issues, as well as a fix for a more serious regression involving lazy loading in highly dynamic mapper configurations which has been identified and repaired.

Thanks to our many generous contributors as well as our core development team for turning around this quick fix release; there's still much more to do so more releases are on the way.

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.1 as well as all the beta releases is at Changelog.

SQLAlchemy 1.4.1 is available on the Download Page.