Python FastAPI Tutorial (Part 5): Adding a Database - SQLAlchemy Models and Relationships @coreyms
Python FastAPI Tutorial (Part 5): Adding a Database - SQLAlchemy Models and Relationships  @coreyms
Uploaded January 2026 | Updated November 2026, 2 hours ago
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:
github.com/CoreyMSchafer/FastAPI-05-Database

Full FastAPI Course:
youtube.com/playlist?list=PL-osiE80TeTsak-c-QsVeg0YYG_0TeyXI

Pydantic Tutorial - youtu.be/M81pfi64eeM

✅ Support My Channel Through Patreon:
patreon.com/coreyms

✅ Become a Channel Member:
youtube.com/channel/UCCezIgC97PvUuR4_gbFUs5g/join

✅ One-Time Contribution Through PayPal:
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:
amazon.com/shop/coreyschafer

▶️ You Can Find Me On:
My Website - coreyms.com
My Second Channel - youtube.com/c/coreymschafer
Facebook - facebook.com/CoreyMSchafer
Twitter - twitter.com/CoreyMSchafer
Instagram - instagram.com/coreymschafer

#Python #FastAPI
Python FastAPI Tutorial (Part 5): Adding a Database - SQLAlchemy Models and RelationshipsBig Announcements, Video Updates, and Future PlansPython Tutorial: How to Set the Path and Switch Between Different Versions/Executables (Windows)Python Flask Tutorial: Full-Featured Web App Part 9 - PaginationPython Tutorial: How to Set the Path and Switch Between Different Versions/Executables (Mac & Linux)Python Tutorial: Securely Manage Passwords and API Keys with DotEnvPython Tutorial: Variable Scope - Understanding the LEGB rule and global/nonlocal statementsLinux/Mac Tutorial: Cron Jobs - How to Schedule Commands with crontabPython Flask Tutorial: Full-Featured Web App Part 2 - TemplatesVirtualBox: How to Use SnapshotsPython Tutorial: Itertools Module - Iterator Functions for Efficient LoopingPython Tutorial: Real World Example - Using Patreon API and Pillow to Automate Image Creation
Corey Schafer |

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

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER