News and Updates

SQLAlchemy 1.4.29 Released

permalink

SQLAlchemy 1.4.29 is now available.

Release 1.4.29 is released slightly ahead of schedule to accommodate for a fix for the mypy plugin, which stopped working as a result of a change released in mypy version 0.390, released earlier today. SQLAlchemy's continuous integration for mypy was inadvertently disabled which prevented this issue from being caught, which has been repaired.

Also included are fixes and use case additions for the ORM, asyncio, engine and MariaDB components.

Our user and contributor communities continue to deliver with bug reports, fixes and code contributions every day. Thanks much for their dedication and efforts.

The complete changelog for 1.4.29 is at Changelog.

SQLAlchemy 1.4.29 is available on the Download Page.

SQLAlchemy 1.4.28 Released

permalink

SQLAlchemy 1.4.28 is now available.

Release 1.4.28 adds new warnings emitted in the area of statement caching involving third-party datatypes, SQL constructs, and dialects, as user issues have revealed that the case of SQLAlchemy's new statement caching being disabled may be more common than was previously realized, and that this can also have a significant performance impact compared to release 1.3 in the area of ORM lazy loading. Previously, it was expected that 1.4 would be only modestly slower than 1.3 if statement caching were disabled, however ORM lazy loading and object refreshes, which occur on attribute access, can be an exception if these calls are very frequent.

For this reason, the new warnings will refer users to new documentation sections that describe the steps to take when these warnings occur.

As is always the case, huge thanks to our user and contributor communities as for their ongoing help and support as well as to our core team for their dedicated efforts and hard work.

The complete changelog for 1.4.28 is at Changelog.

SQLAlchemy 1.4.28 is available on the Download Page.

SQLAlchemy 1.4.27 Released

permalink

SQLAlchemy 1.4.27 is now available.

Release 1.4.27 includes a series of fixes and improvements across the Core and ORM components as well as for individual dialects.

The 1.4 series has moved off of the "main" branch of SQLAlchemy and 2.0 development is now underway.

As is always the case, huge thanks to our user and contributor communities as for their ongoing help and support as well as to our core team for their dedicated efforts and hard work.

The complete changelog for 1.4.27 is at Changelog.

SQLAlchemy 1.4.27 is available on the Download Page.

SQLAlchemy 1.4.26 Released

permalink

SQLAlchemy 1.4.26 is now available.

Release 1.4.26 is chock full of a number of bug fixes as the 1.4 release has settled into general use. Key fixes in release 1.4.26 include:

  • a repair to the workings of the update() statement in an ORM context when used with hybrid and composite attributes.
  • Fixes for the with_loader_criteria() ORM option
  • adjustments to the ORM Session interface to accommodate for new API features
  • some new legacy warnings for lesser used patterns with Query.join()
  • SQL / ORM fixes for the use case of selecting from repeated, non-labeled column expressions, typically the null() construct when used as a placeholder in a UNION statement.
  • For PostgreSQL, refinements to the "expanding IN" SQL feature when used with PostgreSQL ARRAY datatypes as well as fixes for the mostly PostgreSQL-specific any_() and all_() column methods.
  • For MySQL, repaired support for new behaviors in MariaDB 10.6
  • For SQL Server, reflection fixes and improvements for foreign key constraints as well table /view detection.

As is always the case, huge thanks to our user and contributor communities as for their ongoing help and support as well as to our core team for their dedicated efforts and hard work.

The complete changelog for 1.4.26 is at Changelog.

SQLAlchemy 1.4.26 is available on the Download Page.

SQLAlchemy 1.4.25 Released

permalink

SQLAlchemy 1.4.25 is now available.

Release 1.4.25 fixes a single platform installation issue where the platform names for aarch64 as well as AMD64 on windows only were excluded from the list of platforms for which the greenlet dependency, necessary for SQLAlchemy asyncio support, is required, preventing greenlet from being installed automatically for these platforms. The greenlet dependency may also be installed manually using the sqlalchemy[asyncio] installation target with pip.

The complete changelog for 1.4.25 is at Changelog.

SQLAlchemy 1.4.25 is available on the Download Page.