SQLAlchemy 2.0 on Talk Python to Me Ep.344

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

Видео SQLAlchemy 2.0 on Talk Python to Me Ep.344 канала Talk Python