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 
 
<div>Sebastián Ramírez: <a href="https://twitter.com/tiangolo" target="_blank" rel="noopener">@tiangolo</a> 
 
SQLModel: <a href="https://sqlmodel.tiangolo.com/" target="_blank" rel="noopener">sqlmodel.tiangolo.com</a> 
Create a SQLModel Model: <a href="https://sqlmodel.tiangolo.com/#create-a-sqlmodel-model" target="_blank" rel="noopener">sqlmodel.tiangolo.com</a> 
Multiple Models: <a href="https://sqlmodel.tiangolo.com/tutorial/fastapi/multiple-models/" target="_blank" rel="noopener">sqlmodel.tiangolo.com</a> 
 
FastAPI Talk Python episode: <a href="https://talkpython.fm/episodes/show/284/modern-and-fast-apis-with-fastapi" target="_blank" rel="noopener">talkpython.fm/284</a> 
FastAPI Dependency Injection: <a href="https://fastapi.tiangolo.com/tutorial/dependencies/" target="_blank" rel="noopener">fastapi.tiangolo.com</a> 
 
ODMantic for MongoDB: <a href="https://github.com/art049/odmantic" target="_blank" rel="noopener">github.com</a> 
Beanie for MongoDB: <a href="https://github.com/roman-right/beanie" target="_blank" rel="noopener">github.com</a> 
 
Michael's Short video on Pydantic: <a href="https://www.youtube.com/watch?v=aHv7-6WIxNM" target="_blank" rel="noopener">youtube.com</a> 
FastAPI courses by Michael: <a href="https://training.talkpython.fm/fastapi-courses" target="_blank" rel="noopener">training.talkpython.fm/fastapi-courses</a> 
Watch this episode on YouTube: <a href="https://www.youtube.com/watch?v=BTCtKWpNoRI" target="_blank" rel="noopener">youtube.com</a> 
Episode transcripts: <a href="https://talkpython.fm/episodes/transcript/353/sqlmodel-the-new-orm-for-fastapi-and-beyond" target="_blank" rel="noopener">talkpython.fm</a> 
 
--- Stay in touch with us --- 
Subscribe on YouTube: <a href="https://talkpython.fm/youtube" target="_blank" rel="noopener">youtube.com</a> 
Follow Talk Python on Twitter: <a href="https://twitter.com/talkpython" target="_blank" rel="noopener">@talkpython</a> 
Follow Michael on Twitter: <a href="https://twitter.com/mkennedy" target="_blank" rel="noopener">@mkennedy</a> </div> 
Sponsors 
<a href='https://talkpython.fm/datadog'>Datadog</a>
<a href='https://talkpython.fm/tonic'>Tonic</a>
<a href='https://talkpython.fm/training'>Talk Python Training</a>

Podurama

Home

Trending

Personal

Your Podcasts

New Episodes

My Files

Favourite Episodes

Tags (Folders)

Recently Played

Bookmarks

Followed Playlists

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

Talk Python To Me