engineering
JSONB columns let you store flexible data, but the moment you need to search inside them, the default B-tree index is useless. GIN indexes solve the search problem at a cost most teams underestimate. The trade-offs deserve the same kind of attention you would give a schema migration.
engineering
Webhook ordering is one of the topics where the gap between API documentation and reality is widest. Most providers say nothing explicit. Most consumers assume more than the provider guarantees. The result is a class of bugs that is rare enough to escape testing and persistent enough to never go ...
history
The compass needle does not point to true north. It points to a wandering location somewhere in the Canadian Arctic that has moved 50 km a year for the last two decades. The discovery of this fact and the centuries-long effort to map it produced one of the most consequential scientific projects i...
biology
A five-gram crustacean accelerates its dactyl club to 23 meters per second in 0.6 milliseconds, generating impact forces over a thousand newtons, producing cavitation bubbles whose collapse temperatures briefly exceed the surface of the sun. The engineering details took until the 2000s to be unde...
biology
The narwhal tusk is one of the strangest structures in mammalian biology. It is a tooth that grows nine feet through the upper lip of the male narwhal, spiraled like a unicorn horn, with ten million nerve endings exposed to the seawater. After a century of competing hypotheses, the working theory...
engineering
Webhook event names are public API. Customers build switch statements and routing tables on them. The naming convention you pick on day one is the one you live with for years. There are a small number of patterns that age well and several that age badly.
history
For 1,800 years the astrolabe was the most sophisticated portable computing device in human civilization. It told time, determined latitude, calculated the start of Ramadan, surveyed land, and predicted star positions. Then in two centuries it disappeared so completely that the craft of making on...
engineering
The FILTER clause turns multi-pass conditional-aggregate queries into single-pass scans. Most teams writing 2026 Postgres code still reach for CASE WHEN inside SUM. There is a cleaner way that has been standard SQL since 2003.
biology
A 5-centimeter crustacean snaps its claw fast enough to create a vapor cavity, which collapses with a 218-decibel acoustic pulse and a 4700-Kelvin flash of light. The mechanism was misunderstood for decades because the sound looked like mechanical impact and is actually cavitation collapse.
engineering
A webhook subscription endpoint that accepts any URL eventually accepts URLs that point to localhost, private networks, expired domains, and the wrong customer. Validating at subscription time is much cheaper than validating during every delivery.
history
Galileo noticed in 1583 that a swinging chandelier kept time independently of its swing amplitude. It took 70 years and a Dutch mathematician to turn the observation into a working clock that made time precise to the second.
engineering
Postgres has had COMMENT ON since version 7 in 2002. Almost no team uses it. The cost is one extra line per object and the value is that documentation lives where the schema lives and survives every refactor.