Monitor performance issues & errors in your code

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.

Watch this episode on YouTube
Play on YouTube
Watch the live stream version

Links from the show

Mike on Twitter: @zzzeek
Migrating to SQLAlchemy 2.0:
sqlalchemy-continuum versioning:
enum support:
sqltap profiling:

Michael K.'s ORM GC "problem" example

Unit of work:
ORM + Dataclasses:
Cython example:
Async SQLAlchemy example:
ORM Usages Stats (see ORM section):
Watch this episode on YouTube:
Episode transcripts:

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

Want to go deeper? Check out our courses

Talk Python's Mastodon Michael Kennedy's Mastodon