How to build a FastAPI app with PostgreSQL

In this FastAPI PostgreSQL + pgAdmin video, we'll delve into FastAPI, a powerful python web framework and SQLAlchemy, a SQL toolkit that enhances the flexibility of SQL. You'll learn how these two integrate, creating a potent duo for web development with a professional PostgreSQL database.

Our guide includes a quick overview of PostgreSQL and pgAdmin, an open-source database system and its web-based administration tool, ensuring top-notch database management.

Finally, we'll cover Pydantic for data validation and parsing, a vital component for any robust FastAPI application working with PostgreSQL.

By the end of this video, you'll have the knowledge to build a FastAPI application, utilizing SQLAlchemy, PostgreSQL, pgAdmin, and Pydantic.

===========================
🎓 Courses can be found:
===========================

⌚️Timestamps:
0:00 Introduction
01:00 FastAPI, SQLAlchemy, uvicorn, pydantic installation
03:00 Start FastAPI Application
07:00 Create PostgreSQL connection
07:45 pgAdmin GUI
11:00 Create PostgreSQL Tables
16:00 Connect FastAPI, PostgreSQL with SQLAlchemy
17:00 FastAPI API Endpoints

Happy coding!

#codingwithroby #fastapi #postgresql

[gvttsmr]

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!

[pipe]

Great job! 🎉 I really appreciate clears and directs explanations like this one

[aviraltiwari]

Great video. Lot of quality of content. Very informative! I'd suggest creating videos related to CORS, that would be great!

[NobixLee]

Watching on my phone, can’t wait to follow along I actually need to fully understand this for work. Thanks man

[lotusmojo]

Great job buddy!.. very clear and concise

[ufxlunp]

Thank you so much! Very detailed explanation!

[mattmarshall]

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.

[elykou]

Mine works now.What a great teacher .thanks you too much.

[ilteeoe]

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.

[cesardavidmillan]

It was a great tutorial! even though I made a few changes while watching the tutorial! way to go!

[trixer]

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?

[shotihoch]

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!

[ibrahimshazly]

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

[goswami_himanshu]

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

[rafiali]

i watched your three times but i am got same error my question pass in db perfectly but choices doesnt put,

[Tommy-and-Ray]

Great video. Could you share the repo link by any chance please?

[thegreekgoat]

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.

[tihomirkamenov]

Awesome video!
p.s. An async function without an await expression will run synchronously :)

[domingotrejo]

in a production project the lines of create_all and Annotated go ouside of endpoints, are a good practice ?

[timothyatanda]

What a comprehensive tutorial video, that was amazing!
please do you have a class on Udemy where i can learn from you very well?