A Journey to Postgres Productivity with Go
summary
Recommend Postgres with Go using a concrete stack: pgx driver plus pgx copy_from for bulk inserts that show an order‑of‑magnitude speedup in the demo, migrations with golang-migrate embedded via go:generate, queries generated by sqlc type-safe generation (it uses Postgres’ parser to catch mismatches), dynamic filters with squirrel, and integration tests run against real databases using dockertest (example start under 5 seconds). The repo is a gRPC server with streaming that works end to end.
AI-written summary · about
chapters (15)
- 0:00Start
- 1:10State management
- 1:56In memory
- 5:01Document stores
- 9:17Problems with standard library
- 10:51Postgres tooling
- 12:45Query builders
- 13:37The five pillars of our Postgres stack
- 14:10Example repo
- 21:50golang-migrate/migrate
- 22:33Writing migrations
- 23:41Integrating the migrations
- 33:33Dynamic query building
- 34:20Masterminds/squirrel
- 46:23Conclusion
