Query Optimization13 min read
Vector Search Explained: From KNN to HNSW — A Complete Guide
How similarity search works under the hood — and why naive brute-force collapses at scale.
Writing
39 long-form articles on production engineering — how real systems fail, why, and what actually fixed them.
2 articles matching “ML”
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.