phase 3 · 3.2-postgres

Postgres via database/sql + pgx

prereqs 3.1-sql-fundamentals 2.2-net-http-server 2.6-testing-at-scale

review intervals 7d 21d 60d drills sql-crud-txn

The lesson for this task hasn't been written yet. The mastery criteria below is the shortest description of what you'll own when this task is green.

Mastery criteria

- URL shortener: POST /shorten, GET /:slug with raw SQL, no ORM
- Prepared statements, pooling, BEGIN/COMMIT/ROLLBACK all used intentionally
- Integration test against a real containerized Postgres passes repeatedly
- golang-migrate up/down migrations applied in a CI-style script

Verify

Run from your go-dojo repo root:

go-dojo verify 3.2-postgres

This runs the task's go test suite in exercises/phase-3/3.2-postgres/, commits the attempt to .go-dojo/attempts/, and updates your mastery.