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 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
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)
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!
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
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.
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
where is the video on how to setup the mysql workbench? couldnt find it
really hot stuff Eric, thx for this very good explanation!
Glad you like it!
thank you very thank you.
I’m not good at english but this video explain slowly and kindly
I am glad it was helpful!
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()
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
It works very well, however, how do i do an update for my posts ?
Thank you ! You are the best!
No - YOU'RE the best 🙂
I have one question to it. How can I join tables ?
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.
Excelente explicacion!😄
Yay! Glad you like it 🙂
Amazing !!
You're amazing!
You did use Sql for chating with the data?
Yes, this video is using SQL.
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
Thank you for the guide was good especially on db connection.
Glad it helped!
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)
th-cam.com/video/0zb2kohYZIM/w-d-xo.htmlsi=aj3W_RmtQuIOScD3
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 🙂
Teşekkürler,
python kodlarını videoadaki gibi renkli gösteren eklentinin adı ne acaba?
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.
working correct
damn i cant even create a virtual enviroment, that's how unprepared I am.
Ha this made me laugh - you got this!
cool
I really liked the video. Can I use the same steps but with MariaDB?
It should work very similar!
Thank you! Will this work with MariaDB?
For sure!
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.
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 🙂
Why you do not provide Id when creating user still it gets id number automatically?
amazing video, learned a lot! Tnx!
Awesome sauce!
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!
Nice explanation 😁 Thanks
I am glad you enjoyed it 🙂
Hii i have one doubt we can connect already existing database and tables also
where is PUT request?
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
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 🙂
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
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!
Thats so great sir. I am learning form you
Glad to hear that!!
Super cool and easy steps salut to u sir love from karachi pakistan ❤
Thanks!
Thanks! Cool video. Greetings from Russia!
Glad you liked it!
Thanks a lot! Very helpful for beginners like me
Glad it was helpful!
Thank you so much for the this tutorial. keep it up.
You're welcome!
Amazing, loved it! best content.!
Thank you so much 😀 Woot woot!
Thank you sir!!
Most welcome!
many thankssss!!😿
You bet!
Thanks!
No problem!
this guy is so underrated
amazing editing
Thank you so much 😊