Schema Design14 min read
UUID v4 vs UUID v7 vs Snowflake — Pick the Right Primary Key
A plain-English walkthrough: how B-tree inserts actually work, what a page split costs, why random UUID v4 keys bloat the index by 2× and blow the buffer pool.
Writing
39 long-form articles on production engineering — how real systems fail, why, and what actually fixed them.
/
Database
Schema design, query optimization, storage engines, and picking the right database.
2 articles in Schema Design
Schema Design12 min read
Stop Using DELETE in Production: Hard Delete vs Soft Delete in High-Concurrency Systems
Why DELETE is the most expensive DML operation in a relational database — and why a simple UPDATE SET deleted_at = NOW() is 4-8x faster under concurrent load.