🗄️db / pillar
Databases & Storage
Relational schemas, MVCC internals, indexing engines, in-memory caching, and replication
3 Blueprints55 Total Modules
db/postgres18 Modules
PostgreSQL & DBA Architecture
MVCC Internals, GIN/BRIN Indexing & Production DBA
Postgres internals: MVCC tuple lifecycle, JSONB operators, GIN/BRIN indexing, EXPLAIN BUFFERS, Autovacuum tuning, Streaming Replication, and PITR.
#postgres#postgresql#rdbms#jsonb
db/redis19 Modules
Redis & In-Memory Architecture
Event Loop, Streams, Sentinel HA & Redis Cluster
Redis mastery: Single-threaded event loop, Streams, RDB/AOF persistence, Sentinel HA, Cluster sharding, and caching design patterns.
#redis#cache#nosql#in-memory
db/sql18 Modules
SQL & Relational Databases
Relational Schemas, Window Functions & Indexing
Comprehensive relational database engineering: 3NF schema design, complex joins, CTEs, Window Functions, B-Tree indexes, and ACID transactions.
#sql#rdbms#postgres#sqlite