· 6 min read
DatabaseA 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
3 articles
A field guide to PostgreSQL JSONB: the genuinely good use cases, GIN indexing, and the modeling traps that bite teams later.
What the N+1 query problem is, why ORMs cause it by default, how to spot it, and the patterns that eliminate it for good.
A practical mental model for how database indexes really work, why they speed up reads, and the hidden costs you pay on writes.