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!
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)
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.
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?
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.
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
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 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
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
really hot stuff Eric, thx for this very good explanation!
Glad you like it!
Thank you so much for this. Great explanation and structure for a beginner. I now have a clear framework to build on top of.
Woot woot! Glad you were able to learn and find value 🙂
2:07 I used to install dependencies one by one or by reading from a text file but this is new info thanks bro.
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!
Thanks for your response!
Of course! If you ever have any questions or need anything just post them here 🙂
Hi Eric thank you so much for the clear explanation, your code is really clean
Thank you so much 🙂 Glad you were able to find a lot of value!
Thanks a lot! Very helpful for beginners like me
Glad it was helpful!
Amazing, loved it! best content.!
Thank you so much 😀 Woot woot!
Super cool and easy steps salut to u sir love from karachi pakistan ❤
Thanks!
amazing video, learned a lot! Tnx!
Awesome sauce!
Thank you ! You are the best!
No - YOU'RE the best 🙂
Nice explanation 😁 Thanks
I am glad you enjoyed it 🙂
Thats so great sir. I am learning form you
Glad to hear that!!
Thanks! Cool video. Greetings from Russia!
Glad you liked it!
Thank you so much for the this tutorial. keep it up.
You're welcome!
I have one question to it. How can I join tables ?
Excelente explicacion!😄
Yay! Glad you like it 🙂
Next, could you cover the authentication and the authorization in FastAPI?
Not a bad idea! I will look into adding this into a future video
Amazing !!
You're amazing!
I really liked the video. Can I use the same steps but with MariaDB?
It should work very similar!
Hello, and how would be the query to get all the post of my table, without selecting one?
Great question! Try doing: return db.query(Post).all()
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)
czcams.com/video/0zb2kohYZIM/video.htmlsi=aj3W_RmtQuIOScD3
It is showing that could not import module “main”.
I have done everything as per video.
Idk whats wrong?
i have the same problem here.....bro..please let me know if you find any solution
Make sure within your terminal you are in the correct folder where the main.py file lives.
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
where is PUT request?
Hii i have one doubt we can connect already existing database and tables also
many thankssss!!😿
You bet!
working correct
this guy is so underrated
amazing editing
Thank you so much 😊
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)
Yeah, I did this because then the comments would shift to "wtf is a fk" lol. So, I remove those outliers.
Why you do not provide Id when creating user still it gets id number automatically?
for update we use
db.put at the end?
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.
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 🙂
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?
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.
@@codingwithroby makes sense! Thank you for the clear explanation.
Thanks!
No problem!
You did use Sql for chating with the data?
Yes, this video is using SQL.
thanks king
but in this code , sql connnection established again and again for each request that bad things
Nope that is a good thing - You do not want to keep connection on API requests!
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
use vercel, or render bro
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
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
cool
damn i cant even create a virtual enviroment, that's how unprepared I am.
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?
This is hard without me seeing any code 😢 Perhaps it is something small and you can compare your code to the video again
@@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
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