Building a REST API with FastAPI, Async SQLAlchemy, and PostgreSQL



Building a REST API with FastAPI, Async SQLAlchemy, and PostgreSQL

Building a REST API with FastAPI, Async SQLAlchemy, and PostgreSQL

In this video, we shall be Building a REST API with FastAPI, Async SQLAlchemy, and PostgreSQL. We explore the Async SQLAlchemy 2.0 features and also some new features of Pydantic. We also use PostgreSQL as our data store for this project.

This video is an update to a video I made here.
https://youtu.be/2g1ZjA6zHRo

SOURCE CODE:
https://github.com/jod35/Noted-FastAPI

PLEASE DONATE TO THE CHANNEL:
https://buymeacoffee.com/jod35

TIMESTAMPS:
(00:00) Introduction
(00:30) Project Setup
(01:49) Create a Fast API server
(07:41) simple API doc with SwaggerUi
(09:50) setup db with Async SQLAlchemy
(18:21) Creating database models
(27:40) Creating tables from the model in PostgreSQL
(33:01) Create, Retrieve, Update, And Delete
(48:09) Formatting code with black
(54:30) Create serializers with Pydantic
(58:20) List all note resources
(59:41) Create a note resource
(01:04:48) Customize the request body on SwaggerUI
(01:11:09) Retrieve a note resource
(01:13:12) Update a note resource
(01:19:31) Delete a note resource
(01:22:50) Conclusion

Comments are closed.