This article will teach you how to create a CRUD RESTful API with Python, FastAPI, SQLAlchemy ORM, Pydantic, Alembic, PostgreSQL, and Docker-compose to perform the basic Create/Read/Update/Delete operations against a database.


- Python, FastAPI, PostgreSQL, SQLAlchemy CRUD API Overview

- Setting up FastAPI and PostgreSQL

- Building the FastAPI Server

- Starting the FastAPI Server

- Setting up Environment Variables in FastAPI

- Connecting to the PostgreSQL Server

- Installing the UUID OSSP PostgreSQL Plugin

- How to Create Database Models with SQLAlchemy

- Creating Validation Schemas with Pydantic

- Creating the FastAPI Route Handlers

- Fetch All Posts Handler

- Create New Post Handler

- Update Post Handler

- Get a Single Post Handler

- Remove Post Handler

- Add the Routes to the FastAPI Middleware Stack

[RESTful API with Python, SQLAlchemy, & FastAPI: Access and Refresh Tokens](https://codevoweb.com/restful-api-with-python-fastapi-access-and-refresh-tokens)

[RESTful API with Python, SQLAlchemy & FastAPI: Send HTML Emails](https://codevoweb.com/restful-api-with-python-fastapi-send-html-emails)

[CRUD RESTful API Server with Python, FastAPI, SQLAlchemy, and PostgreSQL](https://codevoweb.com/crud-restful-api-server-with-python-fastapi-and-postgresql)