When it all GOes right
summary
Go plus PostgreSQL workflow with concrete tools: use PGX native features instead of lib/pq for native types, prepared-statement caching, COPY and listen/notify; use sqlx for row-to-struct convenience or sqlc-generated types to keep SQL in source and generate safe Go code; test with real Postgres, mocked sessions via pgxmock (examples for success and rollback) or with testcontainers parallelism to spin up many isolated DBs; CI uses go-releaser, GitHub Actions for multi-OS builds, Docker images and coverage HTML (example project shows ~87% coverage).
AI-written summary · about
chapters (16)
- 0:00Welcome and introduction
- 1:51About Cybertech and partners
- 2:34Why Go is loved by developers
- 4:18Where Go is used today
- 6:08Go IDEs and tools overview
- 7:59Choosing PostgreSQL drivers
- 10:54PGX vs database/sql
- 13:01Hello world with PostgreSQL
- 15:08Useful Go extensions
- 18:00SQL code generation with sqlc
- 19:08Testing approaches
- 21:59Mocking database interactions
- 25:38Testing coverage and tools
- 27:22CI/CD with GitHub workflows
- 32:08Key takeaways on Go
- 34:36Q&A session
related talks
49mWhen it all GOes right
47mA Journey to Postgres Productivity with Go
32mA Journey to Postgres Productivity with Go
26mTime to Go with PostgreSQL
24mpgcov: Bringing Real Test Coverage to PostgreSQL Code
39mBuilding Production Applications Using Go
56mLightning Talks
25mBig Bad World of Postgres Dev Environments