All pillars
03

Data & Storage Architecture

1 article published

The database is often the hardest component to change after launch. This pillar gives you the tools to make informed choices about storage engines, replication, and data modelling before you are locked in.

Reading Path

01

Data Modeling Fundamentals

How data shape drives every downstream storage and query decision.

Coming soon
02

SQL vs NoSQL Tradeoffs

Stop treating this as a default choice. Learn when each model wins.

Coming soon
03

Query Patterns & Access Design

Designing schemas around how data is read, not just how it is stored.

Coming soon
04

Replication Models

Sync vs async replication, leader election, and failure scenarios.

Coming soon
05

Sharding Strategies

Range, hash, directory — and the complexity that comes with each.

Coming soon
06

Caching Layers

Read-through, write-through, cache invalidation, and when caching hurts.

Coming soon
07

Data Consistency & Integrity

Transactions, constraints, and the real cost of eventual consistency.

Coming soon
08

Data Lakes vs Warehouses

Analytics infrastructure decisions and their cost implications.

Coming soon
09

Indexing Strategies (B-Tree, LSM — Conceptual)

Why index structure determines read vs write performance tradeoffs.

Coming soon
10

Storage Engines (Conceptual Overview)

What sits beneath your database and why it matters for your workload.

Coming soon
12

Schema Design & Migrations

Evolving schemas without downtime — and the traps to avoid.

Coming soon
13

Backups & Disaster Recovery

RPO, RTO, and how to actually validate that your backups work.

Coming soon
14

Storage Tiering (Hot vs Cold Data)

Moving data to cheaper storage without losing access when you need it.

Coming soon
15

Data Pipelines (Batch vs Streaming)

When to process data as it arrives vs in scheduled windows.

Coming soon