DevLift

Blog

Tutorials, guides, and insights to help you become a better developer.

Clear
Prisma will happily turn one findMany into 133 statements, and the include that replaces them is not one query either, so this walks through the real logged SQL for four versions of the same read against a 132-post table.
AdminSeptember 4, 20269 min read
How Database Indexes Work: B-Trees, Buffers, and the 46% Rule
A measured tour of B-tree indexes on PostgreSQL 17, with real query plans for index-only scans, the visibility map, HOT updates, and the selectivity point where the planner abandons your index.
AdminAugust 7, 202610 min read

Stay in the Loop

Get notified about new courses, tutorials, and learning tips. No spam, unsubscribe anytime.