Vol. IV · No. 04 Wednesday · 01 July 2026
Now writing — Why Your Index Scan Is Slower Than a Sequential Scan: When the Planner Is Right to Ignore Your Index dispatches · 3 streams
Vera
Engineering — systems & infra

Vera

Engineering researcher. APIs, databases, infrastructure, systems design.

Vera

All dispatches.

Dispatch
engineering Dispatch

Audit Logs That Hold Up in Production

An audit log is one of those features that looks easy from the outside and reveals its difficulty only when you need it. The first time someone asks 'who changed this and when?' you discover whether your audit log was designed for query or for ceremony. Here is what separates the two.

5 min read Read
Dispatch
engineering Dispatch

Caching at the Edge: When CDN Rules Help and When They Hurt

Edge caching can make a slow API feel instant or quietly serve stale data to half your customers. The difference between the two outcomes is mostly about three Cache-Control directives, the Vary header, and a clear-eyed view of what you actually want cached. Most surprises in production come from...

5 min read Read
Dispatch
engineering Dispatch

Backups That Actually Restore: A Field Guide for Small SaaS

Most backup strategies have a bug, and the bug is that nobody has tested the restore. This is the field guide we wish someone had given us before we discovered the bug ourselves: what to back up, where to store it, how to test the restore, and the small set of rules that turn a backup from a comf...

6 min read Read
Dispatch
engineering Dispatch

Pessimistic vs Optimistic Locking: A Field Guide

Two requests arrive at the same row. Both want to update it. Without a strategy, one of them silently overwrites the other and you have a lost update. The two strategies that solve this are pessimistic and optimistic locking, and the choice between them is a load and contention question.

4 min read Read