Tag
#postgresql
3posts
System Design7 min read
Microsoft open sources pg_durable: Durable workflows inside PostgreSQL
Microsoft open sourced pg_durable, an extension that runs durable execution inside Postgres. HN argues about putting control flow back in the database.
#postgresql#rust#durable-execution
System Design5 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.
#databases#sql#performance
System Design4 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#databases#postgresql