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

Talk Python To Me

Michael Kennedy

Technology

4.8 • 635 Ratings

🗓️ 18 February 2022

⏱️ 78 minutes

🔗️ Recording | iTunes | RSS

🧾️ Download transcript

Summary

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?

Transcript

Click on a timestamp to play from that location

0:00.0	Two frameworks that have taken the Python world by storm lately are Fast API and Pidantic.
0:06.0	Once you already have your data exchange model in Pidantic, you might want to use that code for
0:10.4	storing or talking to your database. And if you have database models, you might want to somehow
0:15.6	use those models to power and document the APIs you're already building with fast API. But the popular ORM,
0:22.9	such as SQL Alchemy and others, far predate Pidantic. But could those two things be put together?
0:29.7	Sebastian Ramirez is here to tell us the answer is yes. We're covering his project's SQL
0:34.4	model, which is the marriage between Piedantic and SQL Alchemy.
0:38.0	This is Talk Python to Me, episode 353 recorded January 17th, 2022.
0:59.8	Welcome to Talk Python, a weekly podcast on Python.
1:01.6	This is your host, Michael Kennedy.
1:07.8	Follow me on Twitter where I'm at M. Kennedy and keep up with a show and listen to past episodes at TalkPython.fm.
1:12.9	And follow the show on Twitter via at Talk Python. We've started streaming most of our episodes live on YouTube. Subscribe to our YouTube channel over at TalkPython.fm slash YouTube to get
1:18.7	notified about upcoming shows and be part of that episode. This episode is brought to you by Datadog
1:24.5	and tonic.aI. Please check out what they're both offering during their segments.
1:29.2	It really helps support the show. Transcripts for this episode are brought to you by Assembly
1:33.0	AI. Their speech-to-text APIs automatically transcribe and understand audio and video in just a few lines of
1:39.8	Python code. Check them out at TalkPython.fm slash Assembly assembly ai. Sebastian, welcome back to Talk Python to me.
1:47.2	Thank you very much. Thank you for inviting me. It's a pleasure to me hear you.
1:50.4	It's great to have you back. When you were on the show, we were talking about Fast API,
1:54.9	and it seemed like so much had to happen. You've done so much. And now there's like all these
1:59.2	other frameworks that you've built and all sorts of exciting things, right? Yeah. Very, very exciting stuff.
2:05.0	It's like very exciting because Python is getting so excited. Well, it's very exciting. It has
	...

Please login to see the full transcript.

Previous episode | Next episode

Disclaimer: The podcast and artwork embedded on this page are from Michael Kennedy, and are the property of its owner and not affiliated with or endorsed by Tapesearch.

Generated transcripts are the property of Michael Kennedy and are distributed freely under the Fair Use doctrine. Transcripts generated by Tapesearch are not guaranteed to be accurate.