Data Persistence

PostgreSQL database setup, async sessions, schema migrations, and CRUD patterns — everything needed to persist and query application data.

Topics

• PostgreSQL & SQLAlchemy — Setting up SQLAlchemy ORM with PostgreSQL, including connection pooling and model definition

• Async Database — FastAPI with Async SQLAlchemy and Alembic for scalable non-blocking backends

• Alembic Migrations — Managing database schema evolution with versioned migration scripts

• CRUD Operations — Capstone: complete CRUD API architecture with FastAPI, SQLAlchemy, Pydantic, and Alembic

Prerequisites

Complete Foundations and API Development first.

• Install required packages
• Async Python, Postgres, and SQLAlchemy
• Alembic Introduction
• CRUD Application Overview
• Practice — Data Persistence
• Assessment — Data Persistence