Engineering researcher. APIs, databases, infrastructure, systems design.
Before the stapler existed, holding multiple sheets of paper together was a more complicated problem than it looks. The arc from medieval ribbons to ornate brass machines to the 1920s commodity stapler is small-engineering history that disappears into ordinary office life.
SQL NULL is not a value. It is the absence of a value, and the difference produces a class of bugs that survives code review, type checks, and unit tests because the SQL standard explicitly defines NULL to behave the way that hides them.
Every webhook product accepts a customer-supplied URL and makes HTTP requests to it from infrastructure the customer does not control. The default behavior is server-side request forgery as a product feature. Recipient allowlisting is the discipline that closes the gap.
Single-event-per-delivery is the right default for webhooks and most B2B SaaS providers ship nothing else. There are specific scenarios where batching produces large operational wins, and the boundaries between when batching helps and when it hurts are worth being explicit about.
The carbonated-beverage industry as we know it depends on a small piece of stamped metal invented in Baltimore in 1892. Before William Painter's crown cork, every bottled soda was a leakage problem. After it, soda became one of the dominant consumer goods of the twentieth century.
Silent data corruption is one of the rare failure modes that punishes good operational hygiene. Regular backups happily encode the corruption, replication propagates it to standbys, and the team discovers the problem when a restore reveals data that was already wrong months ago.
The conveyor belt is one of the more invisible foundational technologies of modern industry. Its first decisive application was Oliver Evans's 1785 grain mill, and its mature factory form came together over a century later in the meatpacking disassembly lines Ford reverse-engineered.
Postgres exposes a family of reset functions for the cumulative statistics views, and using them carelessly destroys the historical context that makes the views useful. The discipline of when to reset and what to capture first is one of the smaller operational habits that compounds over years.
Most webhook APIs let customers subscribe by event type and then ship every event matching the type. For high-volume integrations this is wasteful on both sides. Server-side filtering lets customers narrow further without writing infrastructure to discard most of what they receive.
Rate limits have two implementations that look identical in the documentation and behave very differently in practice. The fixed-window reset is cheap to implement and produces customer-visible cliff edges; the sliding-window reset is more expensive and produces smoother experience.
The bubble level seems trivial: a sealed glass tube with a bubble. The 1660s French invention by Melchisedec Thevenot solved a measurement problem that had defeated builders for thousands of years and reshaped what construction precision was possible.
Postgres has supported jsonb since 9.4, but the SQL standard's jsonpath language added in Postgres 12 changed what you can ask of JSON columns. The operators are unfamiliar and the language is its own small grammar, but the capability is real.