Sharding vs Partitioning
Learn the difference between logical table partitioning and distributed database sharding.
Jul 2, 20261 min read
Command Palette
Search for a command to run...
#databases
Articles tagged with #databases
B-Tree vs LSM-Tree Indexing
Understand the indexing structures behind relational SQL databases and write-heavy NoSQL databases.
Jul 2, 20261 min readNoSQL Partitioning: How Cassandra, DynamoDB, and MongoDB Split Data
Consistent hashing rings, adaptive capacity, and chunk balancers — how the three leading NoSQL databases partition data at scale
May 3, 202624 min read105SQL Partitioning: Range, Hash, List, and Composite Strategies Explained
How PostgreSQL and MySQL use range, hash, list, and composite partitioning to eliminate unnecessary I/O — and when NOT to partition at all
May 3, 202625 min read21Compare-and-Swap and Optimistic Locking: How Every Database Implements It
From the CMPXCHG CPU instruction to DynamoDB ConditionExpressions and Cassandra LWT — how CAS and optimistic locking work across every major database.
Apr 17, 202634 min read156
ACID Properties Explained: How SQL Databases Guarantee Atomicity, Consistency, Isolation, and Durability
From WAL and MVCC to fsync and isolation levels — the internals behind every ACID guarantee in PostgreSQL, MySQL, Oracle, and SQL Server.
Apr 17, 202638 min read35