Databases
Arrays and Custom Types in Go With Postgres and pgx Codecs
Use PostgreSQL arrays and enums from Go with pgx: slices for text[] and int[], ANY and @> queries, NULL versus empty arrays and a string type for an enum.
7 min read
Tag
postgres
8 articles
Databases
JSON Columns in Go With Postgres JSONB Explained Well
Store and query JSONB from Go with pgx: write structs, scan into structs and maps, filter with @> and ->>, update with jsonb_set and index with GIN.
7 min read
Testing
Test Against a Real Postgres in Go Without Slow Setup
Run Go tests against real PostgreSQL fast: migrate once into a template database, clone a private database per test, run in parallel and drop after.
10 min read
Databases
Connect Go to PostgreSQL the Right Way With Pooling
Connect Go to PostgreSQL with pgx: a pgxpool for native use, the database/sql adapter for the standard API, pool sizing, timeouts and a wrong password.
7 min read
Databases
Retry Serialization Failures in Go Transactions Safely
Retry PostgreSQL serialization failures and deadlocks in Go: detect SQLSTATE 40001 and 40P01 with pgconn and rerun the whole transaction. Eight workers shown.
7 min read
Databases
Time Zones and Timestamps in Go SQL Code Explained
Handle time zones between Go and PostgreSQL: timestamptz keeps the instant, timestamp keeps a wall clock, and the session zone only changes display.
7 min read
Databases
Transaction Isolation Levels in Go With Real Anomalies
See isolation levels in Go on PostgreSQL: a non-repeatable read at Read Committed, write skew at Repeatable Read, and the error Serializable raises instead.
11 min read
APIs
Build a Search Endpoint in Go With Postgres Full Text
Build a Go search endpoint on PostgreSQL full text search: a weighted tsvector, GIN index, ranking, snippets, and a trigram fallback for typos.
14 min read