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.

#353: SQLModel: The New ORM for FastAPI and Beyond

January 17, 2022 01:18:21 66.09 MB Downloads: 0
Two frameworks that have taken the Python world by storm are FastAPI and Pydantic. Once you already have your data exchange modeled in Pydantic, you might want to use that code for storing it in the database. And, if you have DB models you might want to somehow use them to power and document the APIs built with FastAPI.

But the popular ORMs, such as SQLAlchemy and others, far predate Pydantic. But could they be put together?

Sebastián Ramírez is here to tell us the answer is yes. We're covering his project SQLModel which is the marriage between Pydantic and SQLAlchemy.

Links from the show

Sebastián Ramírez: @tiangolo

SQLModel: sqlmodel.tiangolo.com
Create a SQLModel Model: sqlmodel.tiangolo.com
Multiple Models: sqlmodel.tiangolo.com

FastAPI Talk Python episode: talkpython.fm/284
FastAPI Dependency Injection: fastapi.tiangolo.com

ODMantic for MongoDB: github.com
Beanie for MongoDB: github.com

Michael's Short video on Pydantic: youtube.com
FastAPI courses by Michael: training.talkpython.fm/fastapi-courses
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
Datadog
Tonic
Talk Python Training