How to build a FastAPI app with MySQL database (step by step guide)
In this video, we will guide you through the process of creating a FastAPI blog application integrated with a MySQL database, using SQLAlchemy for database interaction. You'll learn to define data models with Pydantic and how to use MySQL Workbench for database management. Finally, we'll show you how to serve your application using uvicorn.
🎥 React + FastAPI: • How to build a React +...
🎥 AWS Lambda + FastAPI: • Deploy FastAPI on AWS ...
🎥 MongoDB + FastAPI: • Unlocking the Power of...
🎥 PostgreSQL + FastAPI: • How to build a FastAPI...
🎓 Courses can be found:
FastAPI Beginner & Advanced: www.udemy.com/course/fastapi-...
Learn Chatbot Development: www.udemy.com/course/the-comp...
Want to learn how to use MySQL Workbench, a unified visual tool for database architects, developers, and DBAs? I will guide you on how to visually design, model, generate, and manage databases.
Throughout the video, we'll be sharing lots of tips and tricks that we've learned over the years. You'll be well-equipped to handle a wide variety of FastAPI projects by the end of this tutorial.
🔔 Subscribe to our channel to keep up with our latest content, and hit that like button if you find this tutorial helpful!
===========================
🔥 Check out the FastAPI Masterclass : www.udemy.com/user/ericroby2/
===========================
🛒 GEAR & RECOMMENDED BOOKS: kit.co/codingwithroby
TIMESTAMPS:
00:00 - Introduction
01:05 - FastAPI, SQLAlchemy, uvicorn, pydantic installation
02:27 - FastAPI Database File
04:37 - Create SQLAlchemy & MySQL Database Models
09:23 - FastAPI
14:00 - MySQL Workbench
15:46 - FastAPI endpoints
#codingwithroby #fastapi #mysql
Пікірлер: 71
Thank you so much for this. Great explanation and structure for a beginner. I now have a clear framework to build on top of.
@codingwithroby
11 ай бұрын
Woot woot! Glad you were able to learn and find value 🙂
Hi Eric thank you so much for the clear explanation, your code is really clean
@codingwithroby
10 ай бұрын
Thank you so much 🙂 Glad you were able to find a lot of value!
Thank you ! You are the best!
@codingwithroby
6 ай бұрын
No - YOU'RE the best 🙂
amazing video, learned a lot! Tnx!
@codingwithroby
5 ай бұрын
Awesome sauce!
Thank you so much for the this tutorial. keep it up.
@codingwithroby
7 ай бұрын
You're welcome!
Excelente explicacion!😄
@codingwithroby
8 ай бұрын
Yay! Glad you like it 🙂
Thanks a lot! Very helpful for beginners like me
@codingwithroby
10 күн бұрын
Glad it was helpful!
Nice explanation 😁 Thanks
@codingwithroby
8 ай бұрын
I am glad you enjoyed it 🙂
Thats so great sir. I am learning form you
@codingwithroby
3 ай бұрын
Glad to hear that!!
thanks king
Thanks! Cool video. Greetings from Russia!
@codingwithroby
8 ай бұрын
Glad you liked it!
working correct
Thanks!
@codingwithroby
3 ай бұрын
No problem!
2:07 I used to install dependencies one by one or by reading from a text file but this is new info thanks bro.
@codingwithroby
11 ай бұрын
Nice! Glad you were able to learn something new 🙂 Using a requirements.txt file is probably the best solution to installing multiple dependencies at once if you already have that defined… but if you are installing multiple dependencies to a brand new project keep it all on the same line and pip install them together!
@manojk1494
11 ай бұрын
Thanks for your response!
@codingwithroby
11 ай бұрын
Of course! If you ever have any questions or need anything just post them here 🙂
many thankssss!!😿
@codingwithroby
2 ай бұрын
You bet!
I really liked the video. Can I use the same steps but with MariaDB?
@codingwithroby
10 ай бұрын
It should work very similar!
Super cool and easy steps salut to u sir love from karachi pakistan ❤
@codingwithroby
2 ай бұрын
Thanks!
It works very well, however, how do i do an update for my posts ?
where is the video on how to setup the mysql workbench? couldnt find it
for update we use db.put at the end?
Great video, I have a small question. Whenever I delete a post and then add a new one, the post id will start from where it was last ended. For example if I create post 2 then delete it and then add another post, the new post will start from id 3. Is there anyway to reset the post id to fill in from the smallest id not being used?
@codingwithroby
9 ай бұрын
While it might seem like a good idea to "recycle" IDs to fill gaps, there are several reasons you might not want to do this, especially if you're new to development: The biggest reason is data integrity. If you've deleted a post and reuse its ID, you might end up with links, references, or logs that point to the wrong content. This is bad for data accuracy. Think of how Foreign Keys work. If you have another piece of data that references that post, and then you delete the post, the old piece of data now references the new data point. Overall, majority of the time you do not want to reuse primary keys once they have been created, and that is why by default databases do not reuse.
@ericflynn5799
9 ай бұрын
@@codingwithroby makes sense! Thank you for the clear explanation.
Hii i have one doubt we can connect already existing database and tables also
Thank you so much for this, it's highly insightful _ please can you drop the syntax for update either post or user by user id as well as get all users.
@codingwithroby
9 ай бұрын
Hey friend! If you check out some of my other FastAPI videos I go over a whole bunch of different database queries and how they work 🙂
cool
Next, could you cover the authentication and the authorization in FastAPI?
@codingwithroby
Жыл бұрын
Not a bad idea! I will look into adding this into a future video
Hello, and how would be the query to get all the post of my table, without selecting one?
@codingwithroby
11 ай бұрын
Great question! Try doing: return db.query(Post).all()
You did use Sql for chating with the data?
@codingwithroby
Ай бұрын
Yes, this video is using SQL.
Why you do not provide Id when creating user still it gets id number automatically?
How do we implement HTML/CSS front-end into this application? Also, can a user login/registration system be implemented? (where users can sign up for an account and then make posts, for example)
@jake115577
6 күн бұрын
kzread.info/dash/bejne/Yq6WlM2omLzAebA.htmlsi=aj3W_RmtQuIOScD3
Could you show your code in terms of asynchronous programming? Because here you declaring api views as asynchronous functions which do not await for db calls
@codingwithroby
9 ай бұрын
You probably do not need to use the async here. I added it just so people could see what a final state may look like
you didn't make a foreign key in the model ;-) (user_id is just a integer column, instead of a foreign key for id in user table)
as a newbie, i have a question, how can i host it so that external users can use it? i know we should secure it (whitelisting ip/tokens etc) but how can i load this python app to the internet for access to external users. thanks
@Manojkumar-fq2vu
Ай бұрын
use vercel, or render bro
but in this code , sql connnection established again and again for each request that bad things
@codingwithroby
6 ай бұрын
Nope that is a good thing - You do not want to keep connection on API requests!
where is PUT request?
damn i cant even create a virtual enviroment, that's how unprepared I am.
@codingwithroby
5 ай бұрын
Ha this made me laugh - you got this!
i got this erroe AttributeError: module 'sqlalchemy.orm.session' has no attribute '__module__' how do i fix it please?
@codingwithroby
8 ай бұрын
This is hard without me seeing any code 😢 Perhaps it is something small and you can compare your code to the video again
@eriguzy
8 ай бұрын
@@codingwithroby please sir i would like to send the pictures of the errors to you via your social media, this is my exam project and i am behind time,let me know which platform i can send the screenshot asap i really need help
@eriguzy
8 ай бұрын
hey i fixed it>>>it was a lowercase mistake of sessionlocal instaed of Sessionlocal while i was importing, thanks for the video...i will be glad if theres any video on user registration and login with authentication as well for this blog app