Tag
#Database
3posts
Tech5 min read
Database Indexing: The 'Library Card Catalog' Mental Model
Why does adding an index make a query 100x faster? A mastery guide to B-Trees, compound indexes, covering indexes, and the queries that kill your database.
#Database#SQL#Performance#PostgreSQL
Tech3 min read
Why Cheap Hardware Won't Make Redis Replace a Core Database
As hardware gets cheaper, why not use Redis as the main database? The short answer: because the limitation isn't speed. It's guarantees and data semantics.
#System Design#Database#Redis#Architecture
Tech4 min read
SQL vs. NoSQL: The 'Library vs. Warehouse' Mental Model
Why is MongoDB faster but Postgres safer? A mastery guide to Schema, ACID, and why JSONB might be the only NoSQL you need.
#System Design#Database#Postgres#MongoDB