biology
The internet learned that mantis shrimp have sixteen photoreceptor types and concluded they must see colors humans cannot imagine. The actual biology is stranger and more interesting: they discriminate colors substantially worse than humans, and the sixteen receptors are doing something other t
api
Webhook deliveries are HTTP requests, and HTTP requests carry headers, and most webhook providers underuse the header surface. The right set of headers makes signature verification cleaner, makes replay handling possible, and lets customers debug delivery problems without instrumenting their ow
history
The schoolroom narrative jumps from Pascal in 1642 to electronic calculators in the 1970s and skips three hundred years of mechanical arithmetic that did most of the world's accounting and engineering computation. The interlude is one of the more thoroughly forgotten chapters in the history of
postgres
Replication slots solve a real problem and create a worse one. The mechanism keeps WAL files around as long as a consumer might need them, which is correct behavior, but a consumer that stops consuming becomes a slow-motion disk-fill catastrophe that the default monitoring catches only after th
biology
Common hippopotamus skin secretes a viscous red fluid that European observers from at least the 17th century misidentified as blood. The fluid is not blood, not sweat in the eccrine mammalian sense, and contains two pigment compounds that function as combined sunscreen, antibiotic, and antifung
api
Customer integrations often assume webhook events arrive in the order they happened. The honest engineering answer is that no widely used webhook system reliably preserves order across retries, parallelism, and recovery. Promising ordering you cannot deliver produces support escalations; refusi
history
Walter Hunt invented the safety pin in 1849 to settle a 15 dollar debt and sold the patent for 400 dollars to the man he owed. He spent the remaining ten minutes of his afternoon bending the wire. The pin he made that afternoon is essentially identical to the safety pin produced two billion tim
postgres
LISTEN/NOTIFY is one of the more underused Postgres features and reaching for Redis or Kafka before checking what the database offers is a common mistake at small scale. But NOTIFY has structural limits that show up under load, and knowing them in advance saves both the architectural detour and
history
The fountain pen dominated educated writing from roughly 1880 to 1960, and almost everything written during those eighty years passed through a steel or gold nib drawing ink by capillary action from a small internal reservoir. The mechanism is a more elegant piece of fluid engineering than it l
biology
The Greenland shark, Somniosus microcephalus, lives in cold deep water around the Arctic and has a verified lifespan of at least 272 years and a likely lifespan of around 400 years, making it the longest-lived vertebrate on Earth by a substantial margin. The biology that supports the lifespan i
api-design
Most APIs make it easy to get data in and harder to get data out. The pattern is short-sighted: customers who feel locked in are less willing to commit, and customers who eventually leave do so with worse outcomes for everyone. A well-designed migration endpoint surface is one of the underappre
postgres
Most teams that use triggers reach for FOR EACH ROW by default, often without considering that FOR EACH STATEMENT exists. The two variants run different numbers of times, see different data, and pay dramatically different performance costs. Picking the wrong one is one of the more expensive tri