Great tutorial. Very quick and to the point. It would be interesting to see a video about releasing a FastAPI/React/Postgres application to AWS or GCP.
Hi, Mr Roby on 14:30 i am wondering why you didn't add question = relationship("Question") # Establish relationship to choices model --- and thanks for your tutorial
I would love this tutorial but showing how to use relationships. For instance how would you make it pull all the answers automagically when the question is pulled?
Erck tu ejemplo me ayudo a entender mejor FastApi he visto varios videos y el tuyo es uno de los mejores que los explica, sencillo y al grano, gracias!
thank u man!!! i don't understand all ur words, because my english not good. But this video was better than videos in my native language. I hope that u do more videos about FastAPI, actually FastUI. Thank u so much another time.
Hi! Can anyone help me? I would like to have a GET endpoint that returns a JSON like this: { "question_text": "question", "choices": [ { "choice_text": "answer1", "is_correct": true }, { "choice_text": "answer2", "is_correct": false }, { "choice_text": "answer3", "is_correct": false }, { "choice_text": "answer4", "is_correct": false } ] } How do I do it? It seems like I can't select the columns I want even if the query seems right: print(select(Questions, Choices).where(Questions.id == Choices.question_id)) SELECT questions.id, questions.question_text, choices.id AS id_1, choices.choice_text, choices.is_correct, choices.question_id FROM questions, choices WHERE questions.id = choices.question_id Thanks for the help!
If you want this all in a single JSON, I would suggest creating another Python object that holds a String along with the choices objects, query the DB and place the info accordingly with the object you are returning.
Absolute usefull tutorial. Found it... ughhh finally. Thank you! It was pretty hard to understand db_dependency = Annotated[Session, Depends(get_db)] logic, but with gpt i think I got it. Didnt get about async without await thing.... but I just think it some kind of inner processes of FastAPI requires it. Anyways thank you!
Eric, please do you have the completion of this tutorial in your Udemy class with the topic "Fastapi- The Complete Curse 2024 (Beginners+Avanced)? i mean the aspect of the delete, get _by_id and update"🙏
Great tutorial Eric. If you can create a video on slightly complex project using fastAPI and postgreSQL i'll watch it even if it's 3 hours long Btw you don't have to import List from typing anymore. New versions of python provides this already with the name list
@@codingwithroby maybe a program that has 2 tables one for student info and one for student marks and then you calculate things like average, grade, etc
Typically, async returns another async def most of the time (with await) until it reaches the final stage - any data from database, message, string, int etc. On the last stage the def should be also async but it will return with no await So in this case, @codingwithroby is correct, my mistake! @@AzharRafiq However, we use async def to avoid big delays when fetching data. This allows the program to switch between multiple tasks without blocking the main thread.
Hi Eric I hope you're doing well, I have a slight issue when I paste the URL on my browser i keep getting "detail" : "not found". If anyone could help me please ?
HELLO PLEASE, i need you're help i followed the tuto exactly but when i want to launch the API i have an error "from sqlalchemy import Session ImportError: cannot import name 'Session' from 'sqlalchemy'"
Hey friend! How is it going? Let's figure out what is going on here. When are you doing this? It should be session maker if you are adding: from sqlalchemy.orm import sessionmaker
@@codingwithroby hey, the ImportError is Gone but when i do the Post endpoint they add null data to the database (i try to make my own api with user and when i post an user i can see the ID in database but all of the other data is null)
Create something like this 1) user registration in FastAPI ( Using two database PostgreSQL and MongoDB ) Registration fields - Full Name,Email,Password,Phone,Profile_picture First Name,Password,Email,Phone - postgreSQL Profile picture - MongoDB Check Email already exist 2) user registration in fastAPI ( Using postgreSQL ) Registration fields - Full Name,Email,Password,Phone,Profile_picture Create table Users to store : First Name,Password,Email,Phone Create table Profile to store : Profile_picture Check Email , Phone already exist
Great tutorial. Very quick and to the point. It would be interesting to see a video about releasing a FastAPI/React/Postgres application to AWS or GCP.
Thanks friend !
Great job! 🎉 I really appreciate clears and directs explanations like this one
Woot woot! I am so glad you were able to find some value. Cheers!!!
Hi, Mr Roby
on 14:30
i am wondering why you didn't add
question = relationship("Question") # Establish relationship
to choices model
---
and thanks for your tutorial
I would love this tutorial but showing how to use relationships. For instance how would you make it pull all the answers automagically when the question is pulled?
Watching on my phone, can’t wait to follow along I actually need to fully understand this for work. Thanks man
Glad it was helpful!
Erck tu ejemplo me ayudo a entender mejor FastApi he visto varios videos y el tuyo es uno de los mejores que los explica, sencillo y al grano, gracias!
It would have been much better if you have explained the logic behind the lines and what it does more clearly especially in database part.
Thanks for your recommendations!
Great job buddy!.. very clear and concise
Glad you liked it! 🙂
Great video. Lot of quality of content. Very informative! I'd suggest creating videos related to CORS, that would be great!
Great suggestion!
Very Great Tutorial, Greetings from Egypt
Thanks for watching! Cheers 🙂
very nice and easy way of teaching
Thanks, friend!
i watched your three times but i am got same error my question pass in db perfectly but choices doesnt put,
thank u man!!! i don't understand all ur words, because my english not good. But this video was better than videos in my native language. I hope that u do more videos about FastAPI, actually FastUI. Thank u so much another time.
Glad I could help!
Great video. Could you share the repo link by any chance please?
Hey friend, for this video I never saved the repo. Sorry!
It was a great tutorial! even though I made a few changes while watching the tutorial! way to go!
Great to hear! Woot woot 🙂
nice video! do you have one implementing postgres + data validation + docs + auth?
I think scattered around I do - I have a best selling FastAPI course you can take. That will 100% have what you are looking for.
@@codingwithroby where do I find it?
@@yvysunu In the description above for this video under Courses.
Hi! Can anyone help me? I would like to have a GET endpoint that returns a JSON like this:
{
"question_text": "question",
"choices": [
{
"choice_text": "answer1",
"is_correct": true
},
{
"choice_text": "answer2",
"is_correct": false
},
{
"choice_text": "answer3",
"is_correct": false
},
{
"choice_text": "answer4",
"is_correct": false
}
]
}
How do I do it? It seems like I can't select the columns I want even if the query seems right:
print(select(Questions, Choices).where(Questions.id == Choices.question_id))
SELECT questions.id, questions.question_text, choices.id AS id_1, choices.choice_text, choices.is_correct, choices.question_id
FROM questions, choices
WHERE questions.id = choices.question_id
Thanks for the help!
If you want this all in a single JSON, I would suggest creating another Python object that holds a String along with the choices objects, query the DB and place the info accordingly with the object you are returning.
Post IS where you creat every thing'Just past it in thé post Doc and get it in thé get questions.
thanks, it's been helpful
You're welcome! 🙂
Thank you, Eric. Really helpful
Glad it was helpful!
Great video
Thanks!
Coming from MVC background! How about we put the files into a production grade folder 📂 structure?
The idea here was to simply show how to setup FastAPI with PostgreSQL. I appreciate your feedback🙂
@dipanjansaha6824: how would this structure that you mention look like? Do you have any reconmendations?
Mine works now.What a great teacher .thanks you too much.
Thank you so much 🙂
Absolute usefull tutorial. Found it... ughhh finally. Thank you! It was pretty hard to understand db_dependency = Annotated[Session, Depends(get_db)] logic, but with gpt i think I got it. Didnt get about async without await thing.... but I just think it some kind of inner processes of FastAPI requires it. Anyways thank you!
Great to hear! Thank you! 😊
Thank you so much! Very detailed explanation!
Glad it was helpful! 🙂
in a production project the lines of create_all and Annotated go ouside of endpoints, are a good practice ?
I would probably use migrations and have a deployment script do it, but for small/medium sized applications, absolutely!
Eric, please do you have the completion of this tutorial in your Udemy class with the topic "Fastapi- The Complete Curse 2024 (Beginners+Avanced)? i mean the aspect of the delete, get _by_id and update"🙏
It is not exactly this tutorial, but it shows how to do almost everything 🙂
I am confident it will have what you are looking for
Great Video Eric , Thank you
Glad it was helpful! 🙂
i need your help
thanks excellent job
Glad you were able to find value 🙂
Thanks a lot Eric!
You are more than welcome!
Great tutorial Eric.
If you can create a video on slightly complex project using fastAPI and postgreSQL i'll watch it even if it's 3 hours long
Btw you don't have to import List from typing anymore. New versions of python provides this already with the name list
Thanks for the suggestion! What exactly are you wanting to see so I have a better understanding 🙂
@@codingwithroby maybe a program that has 2 tables one for student info and one for student marks and then you calculate things like average, grade, etc
Greate tutorial!! how can we update database if we made changes from models? I really appreciate!
You will want to use something like Alembic. If it is a brand new app, you can delete the db and let SQLAlchemy recreate a new one for you.
Awesome video!
p.s. An async function without an await expression will run synchronously :)
Nice addition!
when we should use async vs def only?
Typically, async returns another async def most of the time (with await) until it reaches the final stage - any data from database, message, string, int etc. On the last stage the def should be also async but it will return with no await
So in this case, @codingwithroby is correct, my mistake! @@AzharRafiq
However, we use async def to avoid big delays when fetching data. This allows the program to switch between multiple tasks without blocking the main thread.
Hi Eric I hope you're doing well,
I have a slight issue when I paste the URL on my browser i keep getting "detail" : "not found". If anyone could help me please ?
What is the url that you are pasting? If you past the localhost url without anything after it the "detail":"not found" message will appear.
So what should I paste ?
What a comprehensive tutorial video, that was amazing!
please do you have a class on Udemy where i can learn from you very well?
Yes I do! Link is in description 🙂
Can you share github repo with that project ?
HELLO PLEASE, i need you're help i followed the tuto exactly but when i want to launch the API i have an error "from sqlalchemy import Session
ImportError: cannot import name 'Session' from 'sqlalchemy'"
Hey friend! How is it going? Let's figure out what is going on here. When are you doing this? It should be session maker if you are adding: from sqlalchemy.orm import sessionmaker
@@codingwithroby hey, the ImportError is Gone but when i do the Post endpoint they add null data to the database (i try to make my own api with user and when i post an user i can see the ID in database but all of the other data is null)
@@iVentusHD What does your Python method look like?
class with a plural name are bad form but this is a nice video, props
pgadmin video link please
Thank you
You are welcome 🙂
How to host this on render?
Render is one option and another option is AWS. I have a video on AWS deployment you may be interested in.
Create something like this
1) user registration in FastAPI ( Using two database PostgreSQL and MongoDB )
Registration fields - Full Name,Email,Password,Phone,Profile_picture
First Name,Password,Email,Phone - postgreSQL
Profile picture - MongoDB
Check Email already exist
2) user registration in fastAPI ( Using postgreSQL )
Registration fields - Full Name,Email,Password,Phone,Profile_picture
Create table Users to store : First Name,Password,Email,Phone
Create table Profile to store : Profile_picture
Check Email , Phone already exist
can you share code
I do not have this code specifically anymore, but I can definitely look into keeping all code from my RUclipss.