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.

⌚️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