2h ago · 11 min read · When I started building HozonDB — a relational database engine from scratch in Rust — I made a deliberate choice to keep the storage model simple. Pages, rows packed one after another, a pointer to th
Join discussion
May 12 · 2 min read · SQLite and Concurrency: The Lockout Experienced at islistesi.com A few weeks ago, the SQLite database I use to ensure data consistency in a production ERP system gave me serious trouble with an unexpected lockout (lock) issue. Specifically, I encount...
Join discussionMay 11 · 12 min read · Source: Reasons TTL Alone Is a Weak Cache Strategy for Frequently Updated Business Data You know that feeling when a fast, simple idea looks like the obvious engineering short-cut—and then quietly turns into a production headache? TTL-based caching...
Join discussion
May 11 · 6 min read · Database warning signals: How to migrate before disaster strikes Database failures rarely happen without warning. The challenge isn't technical capability, it's recognizing the early indicators and acting before you're forced into emergency mode. Mos...
Join discussion
May 10 · 6 min read · When you run a simple ALTER TABLE to add a column, a critical production table can be locked for minutes, sometimes hours, halting writes across hundreds of tenants. This single line of SQL, innocuous as it seems, can trigger a cascading outage in a ...
Join discussionMay 8 · 12 min read · Source: Techniques: How to design versioned commands so retries stay safe under concurrent modification? 1. Opening: when retries hurt Start with a familiar failure: you design a retry loop to make an operation resilient. It retries on transie...
Join discussion
