A Journey to Postgres Productivity with Go
summary
Argues Postgres is the practical default for most persistent Go apps and demonstrates a working gRPC example repo wired to a real Postgres database using pgx, schema migrations via golang-migrate (embedded with go-bindata), query construction with Squirrel, and integration tests that spin up real containers with dockertest. Shows a concrete bug fix (make receiver a pointer to avoid mutating a copy), uses PGX types for UUID/arrays, and measures tests starting two containers and running in ~3.6s.
AI-written summary · about
chapters (21)
- 0:00Start
- 4:14How Do We Store Data
- 5:54Types of Data Stores
- 6:48In-Memory Key Value Stores
- 8:09Mongodb
- 8:22Relational Databases
- 9:09Which Data Store
- 10:04How Do We Use Postgres with Go
- 11:16Generator Libraries
- 12:44Pgx
- 13:18Debug Logging of Queries
- 14:08Database Migrations
- 14:58Migration Library
- 15:40Write Migration Files
- 16:48How To Integrate the Migrations into Our Application
- 18:17Squirrel Parameters
- 20:50Docker Test
- 22:09Postgres Example Repo
- 22:26Initial Schema Migration
- 28:39Summary
- 29:18Questions
