PostgreSQL Resources and Book Recommendations

Introduction

You have worked through SQL fundamentals, Postgres-specific features (RETURNING, JSONB, MVCC, VACUUM), integrations, projects, and operations. This chapter collects official docs, books, and Hello Code tracks that pair well with PostgreSQL in real architectures.

Prerequisites

Progress through this track (or equivalent Postgres experience)
At least one project chapter attempted (recommended)

How to Keep Learning

Run PostgreSQL beside MySQL and Redis in one Compose stack — Project deploy
Break things on purpose—drop an index, fill disk, open a long transaction
Fix with Troubleshooting
Automate pg_dump before schema experiments — Backup

Hands-on beats reading about EXPLAIN alone.

Official References

Resource	Best for
PostgreSQL Documentation	Authoritative reference, all versions
PostgreSQL Tutorial	Guided SQL lessons
PostgreSQL Wiki	Recipes, extensions, ops notes
pg_stat_statements	Query performance stats

Download docs for offline: postgresql.org/docs/current/.

Recommended Books

PostgreSQL: Up and Running (O'Reilly — Riggs, Krosing, Page)

Installation, SQL, administration, backup
Best after chapters 01–18 of this track

The Art of PostgreSQL (Dimitri Fontaine)

SQL power features, indexing, query design
Read after Indexes and Window Functions

Designing Data-Intensive Applications (Kleppmann)

Relational vs document stores, replication, transactions
Pairs with Replication intro and MongoDB modeling

SQL Performance Explained (Markus Winand)

Indexing and EXPLAIN mindset—applies across Postgres and MySQL

Pick one book and ship a side project—not four at once.

Pair With Hello Code Tracks

Track	Connection
MySQL	Sister SQL track—compare syntax
MongoDB	Document model vs JSONB
Redis	Cache-aside in chapter 27
Python	venv before psycopg
FastAPI	API for chapter 23
JDBC	Java connectivity — chapter 24
Spring Boot 3	JPA with PostgreSQLDialect
Nginx	TLS and reverse proxy
Linux	Docker ops
Git	CI with Compose health checks

Advanced Topics (Next Steps)

Topic	Where to go
PostGIS	postgis.net
Logical replication upgrades	Official logical replication docs
Citus / distributed Postgres	Extension for sharding at scale
Row-level security SaaS	Roles + policy design
TimescaleDB	Time-series extension
pgvector	Embeddings / AI search workloads

PostgreSQL vs MySQL vs MongoDB vs Redis (Reminder)

Need	Often choose
SQL reports, JOINs, strict integrity	PostgreSQL or MySQL
Rich SQL, JSONB, extensions, CTEs	PostgreSQL
Flexible nested documents	MongoDB
Hot cache, sessions, rate limits	Redis

Same product can use all four with clear boundaries — What Is PostgreSQL.

Certification and Community

PostgreSQL offers CE certification through enterprise partners—projects often matter more for hiring
PostgreSQL Community
pgsql-general mailing list for deep questions

FAQ

Official docs vs this track?

This track teaches Hello Code conventions and cross-links; official docs are the reference when you need every CREATE INDEX option.

ORM or raw SQL?

Learn SQL + psycopg first; add SQLAlchemy/JPA when app complexity warrants—debugging still needs EXPLAIN.

Neon / Supabase vs self-hosted?

Managed reduces ops; SQL and drivers stay the same—Docker ops teaches what runs underneath.

Where is the chapter list?

PostgreSQL Chapter Index.

Plan file for authors?

frontend/gen_article_plan/postgresql.md

Done with Postgres—what next?

Pick FastAPI deploy, Redis streams, or deep MySQL for dialect comparison.