Tag
#sql
2posts
Tech8 min read
DuckDB Is Fast Because It Skips the Part Everyone Forgets
A deep dive into DuckDB internals: why an in-process SQL engine that skips the network beats clusters that cost millions, and what HN thinks about it.
#duckdb#databases#sql
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