Category: Databases

Working with data: PostgreSQL schema design, indexes, query optimization, transactions, caching in Redis and fighting the N+1 problem.

Databases 14 March 2026 11 min read

How to read a query plan, choose an index type and avoid creating useless indexes that only slow down writes.

Databases 1 December 2025 9 min read

Caching patterns, fighting the cache stampede and proper invalidation — so that the cache speeds up the system rather than breaking its correctness.