Back to Browse

Python FastAPI Tutorial (Part 5): Adding a Database - SQLAlchemy Models and Relationships

27.8K views
Jan 14, 2026
1:02:59

In this Python FastAPI tutorial, we'll be learning how to add a database to our FastAPI application using SQLAlchemy. Up until now, we've been storing our data in a Python list in memory, which resets every time the server restarts. We'll fix that by connecting to a real SQLite database and setting up SQLAlchemy models with relationships between users and posts. We'll also look at why we use separate SQLAlchemy models and Pydantic schemas, and how to use FastAPI's dependency injection to manage database sessions. By the end, you'll have a solid foundation for database-driven FastAPI applications that you can later scale up to Postgres or MySQL. Let's get started... The code from this video can be found here: https://github.com/CoreyMSchafer/FastAPI-05-Database Full FastAPI Course: https://www.youtube.com/playlist?list=PL-osiE80TeTsak-c-QsVeg0YYG_0TeyXI Pydantic Tutorial - https://youtu.be/M81pfi64eeM ✅ Support My Channel Through Patreon: https://www.patreon.com/coreyms ✅ Become a Channel Member: https://www.youtube.com/channel/UCCezIgC97PvUuR4_gbFUs5g/join ✅ One-Time Contribution Through PayPal: https://goo.gl/649HFY ✅ Cryptocurrency Donations: Bitcoin Wallet - 3MPH8oY2EAgbLVy7RBMinwcBntggi7qeG3 Ethereum Wallet - 0x151649418616068fB46C3598083817101d3bCD33 Litecoin Wallet - MPvEBY5fxGkmPQgocfJbxP6EmTo5UUXMot ✅ Corey's Public Amazon Wishlist http://a.co/inIyro1 ✅ Equipment I Use and Books I Recommend: https://www.amazon.com/shop/coreyschafer ▶️ You Can Find Me On: My Website - http://coreyms.com/ My Second Channel - https://www.youtube.com/c/coreymschafer Facebook - https://www.facebook.com/CoreyMSchafer Twitter - https://twitter.com/CoreyMSchafer Instagram - https://www.instagram.com/coreymschafer/ #Python #FastAPI

Download

1 formats

Video Formats

360pmp483.0 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.

Python FastAPI Tutorial (Part 5): Adding a Database - SQLAlchemy Models and Relationships | NatokHD