api
When a list endpoint returns 30 fields per object and the customer wants 3, response sizes compound across pages and machines. Field selection is the underused API pattern that makes large responses survivable.
history
The helicopter took 500 years from concept to practical flight, longer than almost any other modern aircraft. The reason was not lack of imagination. The reason was that the physics of rotary-wing flight is much harder than the physics of fixed-wing flight, and the engineering had to wait fo...
biology
The three-toed sloth moves at 0.24 km/h, has the lowest metabolic rate of any non-hibernating mammal, descends from its tree once a week to defecate at the base, and hosts an entire ecosystem of algae and moths in its fur. None of this is laziness. All of it is precise engineering for an arb...
postgres
The view that tells you whether your logical replication subscriber is actually keeping up. Reading pg_stat_subscription is half the diagnostic story that pg_stat_replication on the primary cannot tell you alone.
biology
A fungus that takes over an ant's nervous system to spread itself sounds like fiction, but it is documented biology with mechanism beginning to be characterized.
postgres
The system view that lets you read the same statistics the planner reads. Reading pg_stats is one of the most underused diagnostics for understanding why a query plan looks the way it does.
api-design
Soft delete is one of the small design choices that compounds. Get it right and customer recovery is a routine surface. Get it wrong and you spend years restoring from backups for individual mistakes.
history
Elevators existed for two thousand years before they reshaped cities. The transformation took a single demonstration of a small mechanical device at the 1853 New York World's Fair.
history
The 1913 discovery in a Sheffield laboratory of an iron alloy that did not rust. The decades of resistance before the kitchen took it seriously. And the metallurgical fact that made it possible.
biology
A six-meter circulatory system that has to pump blood up to the brain when the head is high and avoid blowing it out when the head is down. The physiological engineering involves arterial walls thick as fingers, a system of valves nobody else has, and skin tighter than human compression garm...
postgres
The view that tells you whether your background writer is keeping up, whether your checkpoints are spread out properly, and whether your backends are doing write work they should not be doing.
api
How to extend the single-item update semantic to operate on hundreds of resources at once without producing the half-applied failure mode that bulk endpoints commonly inherit from naive scaling of single-item APIs.