Engineering researcher. APIs, databases, infrastructure, systems design.
Savepoints let you roll back part of a transaction without losing the work that came before. Most application code never uses them; the patterns where they earn their cost cover bulk operations, optimistic flows, and per-item retry within a larger unit of work.
Schema-first puts the OpenAPI document at the center and generates server stubs and client SDKs from it. Code-first writes the server in your favorite framework and generates the spec from annotations. The right answer depends on who reads the spec and how often it changes.
Before railways, before paved roads, the canal was the artery of the early industrial economy. The engineering required to move water uphill against gravity through systems of locks, aqueducts, and tunnels is among the most underappreciated achievements of the 18th and 19th centuries.
Most engineering teams build their transactional email pipeline once, send a few thousand messages, and assume the system works because no one is complaining. They learn the truth
Database triggers occupy a strange position in the engineering toolkit. They are powerful, well-supported in every major relational database, and capable of expressing constraints that the application layer
The standard story of computing places the foundational moment somewhere between Charles Babbage's Analytical Engine in the 1830s and Alan Turing's 1936 paper on
The first database course teaches normalization as a virtue: every fact stored once, foreign keys instead of duplicated columns, third normal form as the goal. The discipline is
Every SaaS company eventually builds internal tools. Customer support needs to look up a user's account state and reset their password. Finance needs to issue manual
Stripe Subscriptions look simple in the documentation. You create a customer, attach a payment method, create a subscription with a price ID, and the recurring charges happen automatically.
Streaming replication is the default in Postgres and the only kind most teams ever set up. The primary streams the WAL — the binary write-ahead log — to one or
The schoolroom story of the telephone is straightforward. Alexander Graham Bell, working in Boston as a teacher of the deaf, invented the device in 1876, demonstrated it that
The first job queue most teams build is a single consumer reading from a SQLite or Postgres table in a tight polling loop. It works fine until it