All posts / tag
#postgresql
-
Booking the last concert seat
A worked ticket-booking design with PostgreSQL row locks, expiring holds, payment retries, and the late confirmation that cannot take a seat back.
-
Now depends on who you ask
UTC fixes how time is written down. It does not settle whose clock won, when a transaction sampled it, or which event happened first.
-
The graph database you don’t have to add yet
PostgreSQL 19 can query existing tables as a property graph. The useful boundary is knowing when graph syntax is enough and when another database earns its place.
-
Rolling PgBouncer without dropped queries
PgBouncer rollouts reset live client sockets after Kubernetes drained the pod. Shorter Rails connection lifetimes closed the proxy shutdown timing gap.