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.&lt;br/&gt;
&lt;br/&gt;
&lt;strong&gt;Links from the show&lt;/strong&gt;&lt;br/&gt;
&lt;br/&gt;
&lt;div&gt;&lt;b&gt;SQLAlchemy&lt;/b&gt;: &lt;a href="https://www.sqlalchemy.org/" target="_blank" rel="noopener"&gt;sqlalchemy.org&lt;/a&gt;&lt;br/&gt;
&lt;b&gt;Mike on Twitter&lt;/b&gt;: &lt;a href="https://twitter.com/zzzeek" target="_blank" rel="noopener"&gt;@zzzeek&lt;/a&gt;&lt;br/&gt;
&lt;b&gt;Migrating to SQLAlchemy 2.0&lt;/b&gt;: &lt;a href="https://docs.sqlalchemy.org/en/14/changelog/migration_20.html" target="_blank" rel="noopener"&gt;sqlalchemy.org&lt;/a&gt;&lt;br/&gt;
&lt;b&gt;awesome-sqlalchemy&lt;/b&gt;: &lt;a href="https://github.com/dahlia/awesome-sqlalchemy" target="_blank" rel="noopener"&gt;github.com&lt;/a&gt;&lt;br/&gt;
&lt;b&gt;sqlalchemy-continuum versioning&lt;/b&gt;: &lt;a href="https://sqlalchemy-continuum.readthedocs.io/en/latest/intro.html" target="_blank" rel="noopener"&gt;readthedocs.io&lt;/a&gt;&lt;br/&gt;
&lt;b&gt;enum support&lt;/b&gt;: &lt;a href="https://github.com/spoqa/sqlalchemy-enum34" target="_blank" rel="noopener"&gt;github.com&lt;/a&gt;&lt;br/&gt;
&lt;b&gt;alembic&lt;/b&gt;: &lt;a href="https://alembic.sqlalchemy.org/en/latest/" target="_blank" rel="noopener"&gt;sqlalchemy.org&lt;/a&gt;&lt;br/&gt;
&lt;b&gt;GeoAlchemy&lt;/b&gt;: &lt;a href="https://geoalchemy.readthedocs.io/en/latest/" target="_blank" rel="noopener"&gt;geoalchemy.org&lt;/a&gt;&lt;br/&gt;
&lt;b&gt;sqltap profiling&lt;/b&gt;: &lt;a href="https://github.com/inconshreveable/sqltap" target="_blank" rel="noopener"&gt;github.com&lt;/a&gt;&lt;br/&gt;
&lt;b&gt;nplusone&lt;/b&gt;: &lt;a href="https://github.com/jmcarp/nplusone" target="_blank" rel="noopener"&gt;github.com&lt;/a&gt;&lt;br/&gt;
&lt;b&gt;Unit of work&lt;/b&gt;: &lt;a href="https://duckduckgo.com/?t=ffab&amp;q=unit+of+work+design+pattern&amp;iax=images&amp;ia=images&amp;iai=http%3A%2F%2Fwww.codeproject.com%2FKB%2Faspnet%2F581487%2Fd5.JPG" target="_blank" rel="noopener"&gt;duckduckgo.com&lt;/a&gt;&lt;br/&gt;
&lt;b&gt;ORM + Dataclasses&lt;/b&gt;: &lt;a href="https://docs.sqlalchemy.org/en/14/orm/mapping_styles.html#declarative-mapping-with-dataclasses-and-attrs" target="_blank" rel="noopener"&gt;sqlalchemy.org&lt;/a&gt;&lt;br/&gt;
&lt;b&gt;SQLModel&lt;/b&gt;: &lt;a href="https://sqlmodel.tiangolo.com/" target="_blank" rel="noopener"&gt;sqlmodel.tiangolo.com&lt;/a&gt;&lt;br/&gt;
&lt;b&gt;Cython example&lt;/b&gt;: &lt;a href="https://docs.cython.org/en/latest/src/tutorial/pure.html#static-typing" target="_blank" rel="noopener"&gt;cython.org&lt;/a&gt;&lt;br/&gt;
&lt;b&gt;Async SQLAlchemy example&lt;/b&gt;: &lt;a href="https://docs.sqlalchemy.org/en/20/_modules/examples/asyncio/async_orm.html" target="_blank" rel="noopener"&gt;sqlalchemy.org&lt;/a&gt;&lt;br/&gt;
&lt;b&gt;ORM Usages Stats (see ORM section)&lt;/b&gt;: &lt;a href="https://www.jetbrains.com/lp/python-developers-survey-2020/" target="_blank" rel="noopener"&gt;jetbrains.com&lt;/a&gt;&lt;br/&gt;
&lt;b&gt;Watch this episode on YouTube&lt;/b&gt;: &lt;a href="https://www.youtube.com/watch?v=q5Iv6RUxKC8" target="_blank" rel="noopener"&gt;youtube.com&lt;/a&gt;&lt;br/&gt;
&lt;b&gt;Episode transcripts&lt;/b&gt;: &lt;a href="https://talkpython.fm/episodes/transcript/344/sqlalchemy-2.0" target="_blank" rel="noopener"&gt;talkpython.fm&lt;/a&gt;&lt;br/&gt;
&lt;br/&gt;
&lt;b&gt;--- Stay in touch with us ---&lt;/b&gt;&lt;br/&gt;
&lt;b&gt;Subscribe on YouTube&lt;/b&gt;: &lt;a href="https://talkpython.fm/youtube" target="_blank" rel="noopener"&gt;youtube.com&lt;/a&gt;&lt;br/&gt;
&lt;b&gt;Follow Talk Python on Twitter&lt;/b&gt;: &lt;a href="https://twitter.com/talkpython" target="_blank" rel="noopener"&gt;@talkpython&lt;/a&gt;&lt;br/&gt;
&lt;b&gt;Follow Michael on Twitter&lt;/b&gt;: &lt;a href="https://twitter.com/mkennedy" target="_blank" rel="noopener"&gt;@mkennedy&lt;/a&gt;&lt;br/&gt;&lt;/div&gt;&lt;br/&gt;
&lt;strong&gt;Sponsors&lt;/strong&gt;&lt;br/&gt;
&lt;a href='https://talkpython.fm/toptal'&gt;TopTal&lt;/a&gt;&lt;br&gt;
&lt;a href='https://talkpython.fm/training'&gt;Talk Python Training&lt;/a&gt;&lt;br&gt;
&lt;a href='https://talkpython.fm/assemblyai'&gt;AssemblyAI&lt;/a&gt;

Podurama

Home

Trending

Personal

Your Podcasts

New Episodes

My Files

Favourite Episodes

Tags (Folders)

Recently Played

Bookmarks

Followed Playlists

#344: SQLAlchemy 2.0

Talk Python To Me