biology
Prairie dogs produce alarm calls that encode information about the type, size, color, and approach speed of approaching predators. The level of semantic detail in their calls is one of the strongest documented cases of compositional communication in a non-primate mammal, and one of the most con
history
Before the electric bulb, the kerosene lamp transformed how humans spent the hours between sunset and bedtime. For roughly seventy years, it was the dominant source of light in homes across most of the world, and the social changes it enabled are still partly visible in the rhythms of modern li
api-design
Bulk API operations on millions of rows need different patterns than the small-batch endpoints most APIs ship. Cursor-based bulk operations let customers process unbounded result sets through repeatable, resumable, idempotent batches without timing out or losing track of progress.
postgres
Declarative partitioning in Postgres only pays off when the planner can skip partitions a query does not need. Plan-time pruning is automatic; execution-time pruning is recent and easy to miss. Knowing which form fires for which queries is the difference between a fast partitioned table and a s
biology
The Namib darkling beetle lives in one of the driest deserts on Earth and gets nearly all its drinking water by harvesting fog with patterned microstructures on its back. The mechanism is a clean case of biology doing materials engineering at the micrometer scale, and the biomimetic translation
history
The ball bearing reduces rolling friction by an order of magnitude over plain bearings, and almost every spinning thing in modern industrial civilization—motors, wheels, hard drives, wind turbines, grocery store carts—depends on one. The technology is older than internal combustion and as much
api
Authorization scopes let customers limit what an API key can do. The design space is wider than it looks: too few scopes leave customers exposed to credential theft, too many scopes overwhelm customers and produce inconsistent application. Most APIs that get scopes right start small and iterate
postgres
Foreign Data Wrappers let Postgres query external data sources—other Postgres instances, MySQL, CSV files, REST APIs—as if they were local tables. The feature is powerful and easy to misuse, with performance characteristics that surprise teams expecting normal table behavior.
biology
On a small Pacific island, a single species of crow makes hooked tools from pandanus leaves with such consistency that the tools have regional cultural styles. The cognitive machinery behind this is one of the strongest known cases of non-human tool culture, and it sits in a brain the size of a
history
Before the 1790s, every nail was hand-forged by a blacksmith. Houses contained tens of thousands of them, each one valuable enough to be worth recovering when the house burned down. The wire-nail machine arrived around 1880 and collapsed the price by two orders of magnitude in a generation, and
api-design
When a customer's webhook receiver has been broken for a day, the replay API needs to deliver thousands of events without overwhelming the receiver or burning through your delivery budget. Bulk replay is a separate primitive from per-event replay, and the patterns that work depend on the receiv
postgres
LATERAL is the SQL feature that lets a subquery reference columns from earlier in the FROM clause. It collapses several common loop-like patterns into single queries and removes a whole class of N+1 problems that ORMs and application code usually solve by iteration.