Topic
PostgreSQLIntermediateLearn to read PostgreSQL query plans node by node — estimates vs. actuals, loops, buffers — and turn them into index and query fixes.
#execution-plans#indexing#performance
RedisBeginnerPut Redis in front of your database the right way — choose a caching pattern, set sane TTLs, and avoid stampedes and stale data.
#caching#nosql#performance
SQLiteIntermediateSQLite can serve real production traffic. Here's how WAL mode changes concurrency, which PRAGMAs to set, and where the limits are.
#concurrency#internals#performance
