SQLAlchemy 2.0 on Talk Python to Me Ep.344

Опубликовано: 01 Январь 1970
на канале: Talk Python

12,158

197

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.

▬▬▬▬ About the podcast ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

This video is the uncut, live recording of the Talk Python To Me podcast ( https://talkpython.fm ). We cover Python-focused topics every week and publish the edited and polished version in audio form. Subscribe in your podcast player of choice (100% free) at https://talkpython.fm/subscribe.

▬▬▬▬ Guests ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Mike on Twitter: / zzzeek

▬▬▬▬ Links and resources from the show ▬▬▬▬▬▬▬▬▬▬▬▬

Migrating to SQLAlchemy 2.0: https://docs.sqlalchemy.org/en/14/cha...
awesome-sqlalchemy: https://github.com/dahlia/awesome-sql...
sqlalchemy-continuum versioning: https://sqlalchemy-continuum.readthed...
enum support: https://github.com/spoqa/sqlalchemy-e...
alembic: https://alembic.sqlalchemy.org/en/lat...
GeoAlchemy: https://geoalchemy.readthedocs.io/en/...
sqltap profiling: https://github.com/inconshreveable/sq...

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

nplusone: https://github.com/jmcarp/nplusone
Unit of work: https://duckduckgo.com/?t=ffab&q=unit...
ORM + Dataclasses: https://docs.sqlalchemy.org/en/14/orm...
SQLModel: https://sqlmodel.tiangolo.com/
Cython example: https://docs.cython.org/en/latest/src...
Async SQLAlchemy example: https://docs.sqlalchemy.org/en/20/_mo...
ORM Usages Stats (see ORM section): https://www.jetbrains.com/lp/python-d...

Listen this episode on Talk Python: https://talkpython.fm/episodes/show/3...
Episode transcripts: https://talkpython.fm/episodes/transc...

▬▬▬▬ Dive deeper ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Listen to the Talk Python To Me podcast at https://talkpython.fm Over 250 hours of Python courses at https://training.talkpython.fm/courses Follow us on on Mastodon. Michael: https://fosstodon.org/@mkennedy & Talk Python https://fosstodon.org/@talkpython