SQLAlchemy 2.0

Episode #344, published Thu, Dec 9, 2021, recorded Wed, Nov 10, 2021

SQLAlchemy is the most widely used ORM (Object Relational Mapper) for Python developers. It's been around since February 2006. But we might be in for the most significant release since the first one: SQLAlchemy 2.0. This version adds async and await support, new context-manager friendly features everywhere, and even a unified query syntax. Mike Bayer is back to give us a glimpse of what's coming and why Python's database story is getting stronger.

Play on YouTube

Watch the live stream version

Links from the show

SQLAlchemy: sqlalchemy.org
Mike on Twitter: @zzzeek
Migrating to SQLAlchemy 2.0: sqlalchemy.org
awesome-sqlalchemy: github.com
sqlalchemy-continuum versioning: readthedocs.io
enum support: github.com
alembic: sqlalchemy.org
GeoAlchemy: geoalchemy.org
sqltap profiling: github.com

Michael K.'s ORM GC "problem" example
pythons-gc-and-orms: github.com

nplusone: github.com
Unit of work: duckduckgo.com
ORM + Dataclasses: sqlalchemy.org
SQLModel: sqlmodel.tiangolo.com
Cython example: cython.org
Async SQLAlchemy example: sqlalchemy.org
ORM Usages Stats (see ORM section): jetbrains.com
Watch this episode on YouTube: youtube.com
Episode transcripts: talkpython.fm

--- Stay in touch with us ---
Subscribe to us on YouTube: youtube.com
Follow Talk Python on Mastodon: talkpython
Follow Michael on Mastodon: mkennedy

Want to go deeper? Check out our courses

Course: Python for the Absolute Beginner course

Course: HTMX + Flask: Modern Python Web Apps, Hold the JavaScript

Course: Modern APIs with FastAPI and Python

Mike Bayer

Michael Bayer is the creator of several prominent Python libraries including SQLAlchemy, Mako Templates for Python, Alembic Migrations, and Dogpile caching. He has been working with open source software and databases since the mid-1990s. Today ...

Episode sponsored by

Ads served ethically