Databases

See how databases organize, cache, and retrieve data — from B-Tree indexing and sorted sets to caching strategies and session management.

14 guides 8 visualizations 6 simulators
Visualizations 8 visualizations
🏛️
Databases LIVE Intermediate

ACID Transactions Visualization

Step through the four ACID guarantees — Atomicity, Consistency, Isolation, Durability — with undo/redo logging, 2PL and MVCC isolation, isolation levels, and ARIES crash recovery.

🛢️
Databases LIVE Intermediate

Database Replication WAL and Failover Visualization

Step through primary-standby database replication, WAL streaming, replica lag, synchronous commit, failover, split-brain risk, and recovery.

🗃️
Databases LIVE Advanced

Database Sharding Lifecycle Visualization

Walk through the Database Sharding lifecycle with guided steps for hash sharding, range sharding, scatter-gather, hotspot, rebalance.

🏗️
Databases LIVE Advanced

Redis Architecture

A comprehensive deep-dive into Redis internals: caching strategies, data structures, single-threaded execution, pipelining, persistence (RDB & AOF), replication, failover

⚡
Databases LIVE Beginner

Redis Caching Patterns

Visualize cache-aside, read-through, write-through, and write-behind caching patterns. See how Redis sits between your application and database to accelerate reads.

🔄
Databases LIVE Advanced

Redis Cluster Failover Lifecycle Visualization

Walk through native Redis Cluster failover: cluster-bus PFAIL and FAIL reports, master authorization, config epochs, and MOVED recovery.

🔐
Databases LIVE Beginner

Session Management with Redis

Learn how Redis manages user sessions across distributed web servers. See session creation, retrieval, expiration, and how sticky sessions differ from shared session stores.

🌋
Databases LIVE Intermediate

SQL Query Executor: Volcano Iterator Model

Understand the pull-based Volcano iterator execution model in SQL engines. Walk through open(), next(), and close() interfaces, see pipeline breakers like Hash Join

Simulators 6 simulators
🔐
Databases LIVE Advanced

ACID Isolation Locking Lab

Simulate a checkout race to see how ACID isolation, row locks, table locks, MVCC snapshots, range locks, and serializable retries keep database state correct.

🗑️
Databases LIVE Intermediate

Cache Invalidation Strategies Simulator

Simulate different cache invalidation strategies side-by-side. Watch how write-through, write-behind, cache-aside, and TTL-based invalidation handle reads, writes

🔌
Databases LIVE Intermediate

Database Connection Pool Simulator

Simulate a database connection pool managing connections between application threads and a database. Watch connections get checked out, used, and returned. Experiment with pool sizing

💥
Databases LIVE Intermediate

Redis Crash & Cache Stampede

Simulate what happens when Redis crashes: cache timeouts, database fallback, cache stampede pressure, rising latency, 5xx errors, and recovery after Redis restarts cold.

🛟
Databases LIVE Intermediate

Surviving a Redis Crash

Walk through a Redis crash from healthy reads to degraded fallback, DB protection, circuit breaking, L1 hot keys, replica failover, gradual warm-up, and cache-optional correctness.

💿
Databases LIVE Advanced

Tunable DB Consistency Simulator

Simulate tunable read/write consistency levels (One, Quorum, All) in a Dynamo-style replicated database ring. Slice network connections to create partitions, execute operations