hn.today

SQLAlchemy 2.1.0 Released

sqlalchemy.org19 points10 comments
Screenshot of SQLAlchemy 2.1.0 Released

SQLAlchemy 2.1.0, released September 24, 2026, is the first production release of the 2.1 series and becomes the version installed by default with pip install sqlalchemy. Upgrades from 2.0 are generally straightforward but include a set of harder, breaking changes that will require some workflow adjustments: the greenlet dependency used for asyncio features is no longer installed automatically (install via pip install sqlalchemy asyncio), driver-less PostgreSQL and Oracle URLs now default to psycopg (psycopg3) and oracledb respectively, and Python 3.11 is now the minimum supported Python version.

Major feature additions include tstring(), a variant of text() that allows dynamically indicated bind parameters inside plain SQL strings; explicit CreateView and CREATE TABLE AS support; and official support for Microsoft’s mssql-python driver through collaboration with Microsoft. The release encompasses many other fixes and improvements accumulated over three years since 2.0, so users should consult the 2.1 migration guide and full changelog for detailed guidance. SQLAlchemy 2.1.0 is available for download on the project’s release page.

Read on sqlalchemy.org10 comments on Hacker News

Summary generated by AI from the linked article. hn.today is not affiliated with Hacker News or Y Combinator.

More in Programming

Arena Allocators in C

Arena Allocators in C

Arena allocators in C provide a high-performance and versatile way to manage memory by allocating large blocks and sub-allocating within them, reducing the need for frequent malloc and free calls. This approach simplifies memory management, decreases leaks, and improves efficiency, especially in scenarios with predictable memory lifetimes. (eliasebner.com)

The daily digest

Today's best Hacker News stories, summarized and screenshotted, one email a day.