Talk Python to Me is a weekly podcast hosted by developer and entrepreneur Michael Kennedy. We dive deep into the popular packages and software developers, data scientists, and incredible hobbyists doing amazing things with Python. If you're new to Python, you'll quickly learn the ins and outs of the community by hearing from the leaders. And if you've been Pythoning for years, you'll learn about your favorite packages and the hot new ones coming out of open source.

#344: SQLAlchemy 2.0

December 09, 2021 01:06:19 38.67 MB Downloads: 0
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.

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
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 on YouTube: youtube.com
Follow Talk Python on Twitter: @talkpython
Follow Michael on Twitter: @mkennedy

Sponsors
TopTal
Talk Python Training
AssemblyAI