SQLAlchemy 2.0 on Talk Python to Me Ep.344

Video Description

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: https://twitter.com/zzzeek ▬▬▬▬ Links and resources from the show ▬▬▬▬▬▬▬▬▬▬▬▬ Migrating to SQLAlchemy 2.0: https://docs.sqlalchemy.org/en/14/changelog/migration_20.html awesome-sqlalchemy: https://github.com/dahlia/awesome-sqlalchemy sqlalchemy-continuum versioning: https://sqlalchemy-continuum.readthedocs.io/en/latest/intro.html enum support: https://github.com/spoqa/sqlalchemy-enum34 alembic: https://alembic.sqlalchemy.org/en/latest/ GeoAlchemy: https://geoalchemy.readthedocs.io/en/latest/ sqltap profiling: https://github.com/inconshreveable/sqltap Michael K.'s ORM GC "problem" example pythons-gc-and-orms: https://github.com/mikeckennedy/pythons-gc-and-orms nplusone: https://github.com/jmcarp/nplusone Unit of work: https://duckduckgo.com/?t=ffab&q=unit+of+work+design+pattern&iax=images&ia=images&iai=http%3A%2F%2Fwww.codeproject.com%2FKB%2Faspnet%2F581487%2Fd5.JPG ORM + Dataclasses: https://docs.sqlalchemy.org/en/14/orm/mapping_styles.html#declarative-mapping-with-dataclasses-and-attrs SQLModel: https://sqlmodel.tiangolo.com/ Cython example: https://docs.cython.org/en/latest/src/tutorial/pure.html#static-typing Async SQLAlchemy example: https://docs.sqlalchemy.org/en/20/_modules/examples/asyncio/async_orm.html ORM Usages Stats (see ORM section): https://www.jetbrains.com/lp/python-developers-survey-2020/ Listen this episode on Talk Python: https://talkpython.fm/episodes/show/344/sqlalchemy-2.0 Episode transcripts: https://talkpython.fm/episodes/transcript/344/sqlalchemy-2.0 ▬▬▬▬ 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