biology
Watch a cuttlefish hunt a crab and you see something that looks like a magic trick. The cuttlefish hovers, its skin erupts in bands of light and dark that propagate across its body in rapid waves, and the crab freezes. A moment later the cuttlefish strikes with tentacles too fast for the crab to ...
engineering
The reflexive answer to 'we need a job queue' is Redis, RabbitMQ, or SQS. The unreflective version of that answer skips a Postgres feature that turns a single table into a job queue with semantics that match what most teams actually need: SKIP LOCKED.
engineering
Pagination examples in API documentation always show static lists. Real production data is mutable: rows get inserted, deleted, updated, and reordered while customers paginate through them. The patterns that handle this gracefully are not the patterns that look obvious in the static case.
history
Every modern map traces its lineage back to a brass-and-glass instrument that most people have never heard of. The theodolite, invented in the 1570s and refined for four centuries, is the device that converted the world from approximate to precisely-measured at a scale that nation-states required...
engineering
Every B2B API customer integrates twice: once against the sandbox to develop, once against production to ship. The quality of the sandbox is the difference between a smooth integration and a customer who never finishes. Most APIs treat sandbox as an afterthought; the ones that win developer minds...
history
The Reverend William Lee invented the stocking frame in Calverton in 1589, two centuries before the Industrial Revolution. Queen Elizabeth refused his patent, allegedly because the machine would put hand-knitters out of work. The machine survived anyway, and its descendants still make most of the...
science
Scincus scincus is a 20-centimeter lizard that lives in the dunes of the Sahara and the Arabian Peninsula. When threatened, it dives into loose sand and disappears, then propagates through the sand at remarkable speeds with no limbs visible. The biomechanics of how the lizard moves through a subs...
engineering
The intuition that sequential scans are slow and index scans are fast is correct most of the time and wrong in the cases that produce the most surprising query plans. Understanding when the planner picks sequential scan over an existing index is the difference between fighting the planner and giv...
engineering
The webhook is one of the worst customer-facing primitives in modern SaaS APIs. The customer has to operate a publicly-reachable HTTP endpoint, verify cryptographic signatures, handle retries and idempotency, decode payloads whose schema may change, and somehow tell whether a missing webhook is a sender problem or a receiver problem.
history
The window in your office wall is one of the most overlooked technological achievements of the 20th century. A single sheet of glass several meters across, optically clear, mechanically flat to within micrometers, manufactured by the millions of square meters and installed at every scale from elevator to skyscraper. For
biology
In February 1977, the deep-sea submersible Alvin descended 2.5 kilometers to a section of the Galapagos Rift on the East Pacific seafloor. The dive was a geological expedition: the rift was a volcanic spreading center where new seafloor was forming, and the team was looking for predicted hydrothermal vents
engineering
Most Postgres failure modes are gradual. Bloat accumulates and queries get slower; a forgotten replication slot fills the disk over weeks; a missing index turns a five-millisecond query into a five-second one. Transaction ID wraparound is the rare exception. The database runs at full speed up to the moment it