News and Updates

SQLAlchemy 1.4.43 is now available.

Release 1.4.43 includes a variety of fixes within the 1.4 series.

The complete changelog for 1.4.43 is at Changelog.

SQLAlchemy 1.4.43 is available on the Download Page.

The second beta release of SQLAlchemy 2.0 is now available.

The first beta release just one week ago has seen unprecedented response for a beta, with around 5000 downloads per day. Thanks to our users, in the past seven days we've gotten about ten bug reports for small issues that have been fixed in 2.0.b2.

Of note is a fix for SQL Server that affected large string values, as well as a variety of rudimentary fixes for the new annotation-based Declarative feature including dataclasses support.

For an overview of whats new in SQLAlchemy 2.0, see the Whats New in SQLAlchemy 2.0? document.

Links to the detailed changelog for 2.0.0b2 is at Changelog.

SQLAlchemy 2.0.0b2 is available on the Download Page.

SQLAlchemy 1.4.42 is now available.

Release 1.4.42 includes a variety of bug fixes mostly in the area of ORM related use cases. Two new ORM related configurational warnings are added as well, indicating situations that can otherwise lead to confusing behavior in some cases when the incorrect mappings are used. While it's likely that some existing setups may have either of these patterns in place and will see the new warnings, these mis-configuration patterns have been possible for many years and don't indicate any new issue for existing applications.

Additionally fixed ongoing regressions regarding the MSSQL dialect in attempting to connect to various forms of Azure cloud databases, where fixes for one type of Azure database then introduce new problems connecting to another kind. The SQLAlchemy project doesn't have direct testing resources for these databases so we can only rely upon user feedback to know what's working, however it's very likely the issues are finally resolved in this release.

The complete changelog for 1.4.42 is at Changelog.

SQLAlchemy 1.4.42 is available on the Download Page.

We are pleased to announce that the first beta release of SQLAlchemy 2.0 is now available.

The 2.0 series represents over three years of effort towards updating SQLAlchemy's usage model and architectures for modern Python use. The update's origins lie within the three major Python paradigms that came into existence well after SQLAlchemy's first releases in 2006: Python 3, pep-484 typing support, and asyncio. It's also in response to the changing nature of the Python programming community, vastly larger and home to many new developers with higher standards for strictness, ease of use and documentation than was the case sixteen years ago.

While the SQLAlchemy 1.4 series introduced the major architectural changes to internals, including the integration of Core SQL constructs within the ORM, full SQL caching support, and asyncio support, the SQLAlchemy 2.0 series now capitalizes on this architecture within many areas, including most prominently:

• Complete pep-484 typing support and native compatibility with typing tools such as mypy, pylance, including annotation-based Declarative models and fully typed SQL statements (make sure you uninstall all sqlalchemy-stubs, sqlalchemy2-stubs packages)
• Vastly more performant INSERT behavior within the ORM
• Vastly more performant table reflection architecture
• Integration of pure SELECT, INSERT, UPDATE, DELETE statements including RETURNING of objects, upsert within normal ORM use

SQLAlchemy 2.0 also finalizes a very large number of API changes first introduced in 1.4. As such, even though SQLAlchemy 1.4 provided a very comprehensive upgrade path, we expect there to be lots of issues within the beginning of the series, both as projects accommodate the changes as well as for users of the new features, in particular the Declarative annotation support. We therefore hope that the beta series will have lots of testing done, and we will likely move from beta releases into release candidates as well, anticipating a 2.0 final release after some months.

For an overview of whats new in SQLAlchemy 2.0, see the Whats New in SQLAlchemy 2.0? document.

Links to the detailed changelog for 2.0.0b1 is at Changelog.

SQLAlchemy 2.0.0b1 is available on the Download Page.

SQLAlchemy 1.4.41 is now available.

Release 1.4.41 includes a variety of bug fixes including an improvement to the asyncpg dialect implementation regarding how invalid or stale database connections are released, as well as a series of small ORM fixes.

The complete changelog for 1.4.41 is at Changelog.

SQLAlchemy 1.4.41 is available on the Download Page.