PostgreSQL Chapter Index

Introduction

This index lists all 31 chapters in the Hello Code PostgreSQL track, grouped by topic. Use it to jump to a lesson or compare coverage with frontend/gen_article_plan/postgresql.md.

Prerequisites

• None—this page is a map, not a lesson

Getting Started (01–03)

CRUD (04–06)

Advanced Queries (07–08)

Constraints and Indexes (09–10)

Transactions and Concurrency (11–12)

Views and Server Logic (13–15)

Security and Backup (16–17)

Performance and Advanced Features (18–21)

Integrations (22–24)

Projects (25–27)

Operations and Wrap-Up (28–31)

Suggested Learning Paths

SQL fundamentals: 01 → 06 → 09–10 → 11 → 25

Backend Python: 01 → 06 → 22 → 23 → 27 → 29

DBA / performance: 01 → 10 → 11–12 → 17–18 → 28–29

MySQL developers: Read MySQL track in parallel; compare Upsert with MySQL chapter 11, VACUUM with MySQL performance.

Java (optional): 01 → 06 → 24 → Spring Boot JDBC

Full-stack (Vue SPA): 01 → 06 → 23 → Vue 24 + Vue 17

Related Tracks

Track Metadata

• Logo: /category-logos/postgresql.png
• Plan file: frontend/gen_article_plan/postgresql.md
• Article guidelines: frontend/GEN_ARTICLE_ROLE.md

FAQ

Where do I start?

What Is PostgreSQL, then Installation and psql.

Is chapter 24 required?

No—Spring/JDBC is optional if you only use Python.

Cross-track deploy?

Combine with FastAPI Docker and Redis—chapter 27. Add Vue SPA for the browser client (17, 24).

PostgreSQL vs MySQL on Hello Code?

Both are 31-chapter SQL tracks—Postgres emphasizes schemas, RETURNING, JSONB, MVCC, and VACUUM.