#sql

Articles tagged with #sql

SQL 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 read21
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
Partitioning Approaches in SQL and NoSQL: Horizontal, Vertical, Range, Hash, and List Partitioning
Horizontal, vertical, SQL, and NoSQL partitioning strategies — a map of every approach and when to use each
Apr 12, 202612 min read61
Sharding Approaches in SQL and NoSQL: Range, Hash, and Directory-Based Strategies Compared
How PostgreSQL, MySQL, Cassandra, DynamoDB, and MongoDB implement sharding — the trade-offs every system designer must know
Apr 5, 202629 min read22
Isolation Levels in Databases: Read Committed, Repeatable Read, Snapshot, and Serializable Explained
What read committed commits to, why repeatable read still allows phantoms in some databases, and when you actually need serializable isolation
Apr 5, 202628 min read509
Database Anomalies: How SQL and NoSQL Handle Dirty Reads, Phantom Reads, and Write Skew
A deep comparison of how relational and NoSQL databases detect, prevent, and accept different classes of data anomalies
Apr 5, 202631 min read36