📰 Dev.to · priteshsurana

Replication, sharding, CAP tradeoffs, and a decision framework for choosing between PostgreSQL, MongoDB, and Cassandra in a distributed production system.

Trace an insertOne or insertMany and find through MongoDB's WiredTiger — step by step. Storage engines explained with real schema and how B tree affects its per

Trace an INSERT and SELECT through PostgreSQL's heap+WAL — step by step. Storage engines explained with real schema and zero hand-waving.

B+Tree, B-Tree, LSM Tree — the three structures that explain almost every database performance characteristic. Deep dive with visuals, tradeoffs, and real impli

You call INSERT and the database says OK. But between those two moments, at least four things happened that most engineers never think about. Here's what.