Tag
#Database
3 posts
Tech 5 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
Tech 3 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
Tech 4 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