The week pgbouncer stopped being news
Transaction pooling, one SET that didn't stick, and a standup that moved on.
backend
all tags →Transaction pooling, one SET that didn't stick, and a standup that moved on.
What a digital wallet looks like underneath -- a balance, a ledger, idempotency keys, and the gap between moving money and moving money correctly.
Why a graph database was the only sane choice for a social feed where the interesting question isn't what your friends posted, but what your friends' friends are doing this Saturday.
In-memory rate limiting as Express middleware. No Redis, no external service. Fifty lines, one file.
The Node.js MySQL driver doesn't pool connections. Under load, you run out. Fifty lines with generic-pool fixes it.
Loading every product, category, and brand URL into a Redis hash at startup, and a middleware that rewrites requests before Express sees them.
Building catalog search with flattened MongoDB documents and application-side scoring when the proper tools don't exist yet.