Database Fundamentals for Engineers
From normalization to distributed consistency — how databases really work under the hood.
8 posts · 73 min total read
Schema Design
Mastering Database Design: Normalization Explained
Stop throwing hardware at the database - here's how normalization can actually speed things up
Mastering Database Design: Denormalization
Normalization builds the library; denormalization opens the coffee shop inside it
Consistency & Distribution
ACID vs BASE: Comparison of two Design Philosophies
ACID and BASE represent two design philosophies at opposite ends of the consistency-accessibility spectrum. Whaaat?
CAP and PACELC Theorems in Plain English
Data Engineering fundamentals explained: the CAP theorem and PACELC - two frameworks for understanding tradeoffs in distributed systems
Locking Mechanisms in High-Load Systems
Learn how locking mechanisms impact data consistency and system performance in high-load concurrent systems.
Internals & Patterns
Building a Bloom filter
In this post, we will explore the Bloom filter — a data structure that is ingenious in its simplicity and elegant in its design
Change Data Capture (CDC)
Change Data Capture (CDC): what is it and why it's important?
INSERT vs UPDATE and Their Impact on Data Ingestion
INSERT vs UPDATE, which one is faster for Data Ingestion?