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