· 6 min read
Database
Postgres JSONB: When to Use It and When It BitesA field guide to PostgreSQL JSONB: the genuinely good use cases, GIN indexing, and the modeling traps that bite teams later.
Read article· 6 min read
#SQL
3 articles
Postgres JSONB: When to Use It and When It Bites· 6 min read
Database
N+1 Queries: The Silent Performance KillerWhat the N+1 query problem is, why ORMs cause it by default, how to spot it, and the patterns that eliminate it for good.
Read article· 6 min read
· 6 min read
DatabaseA practical mental model for how database indexes really work, why they speed up reads, and the hidden costs you pay on writes.
Read article· 6 min read