Topic
Databases
Learn Databases as a connected topic across chapters, concepts, simulations, and interview reasoning.
10 Concepts35 Articles13h 54m
Overview
Learn Databases as a connected topic across chapters, concepts, simulations, and interview reasoning.
How this topic helps
Distributed Systems
System Design
Transactions
Interview Prep
Learning Path in this Topic
Series that contain articles from Databases. Select a path to filter the article list.
Articles
35 matched articles
Article 1ACID Properties Explained: How SQL Databases Guarantee Atomicity, Consistency, Isolation, and DurabilityTLDR: ACID is four orthogonal guarantees that every SQL transaction must provide. Atomicity says all-or-nothing: PostgreSQL implements it via WAL rollback; MySQL InnoDB via undo logs. Consistency says38 min
Article 2Isolation Levels in Databases: Read Committed, Repeatable Read, Snapshot, and Serializable ExplainedTLDR: Isolation levels control which concurrency anomalies a transaction can see. Read Committed (PostgreSQL and Oracle's default) prevents dirty reads but still silently allows non-repeatable reads, 28 min
Article 3How CDC Works Across Databases: PostgreSQL, MySQL, MongoDB, and BeyondA data engineering team at a fintech company built what they believed was a robust Change Data Capture pipeline: three source databases (PostgreSQL, MongoDB, and Cassandra), Debezium connectors wired 37 minArticle 4NoSQL Partitioning: How Cassandra, DynamoDB, and MongoDB Split DataTLDR: Every NoSQL database hides a partitioning engine behind a deceptively simple API. Cassandra uses a consistent hashing ring where a Murmur3 hash of your partition key selects a node — virtual nod24 minArticle 5SQL Partitioning: Range, Hash, List, and Composite Strategies ExplainedTLDR: SQL partitioning divides one logical table into smaller physical child tables, all accessed through the parent table name. The query optimizer skips irrelevant child tables entirely — a process 25 min
Article 6Compare-and-Swap and Optimistic Locking: How Every Database Implements ItTLDR: Compare-and-Swap (CAS) is the CPU-level atomic instruction that makes lock-free concurrency possible. Optimistic locking builds on it at the database layer: read freely, compute locally, write o34 minPage 1 of 6