Data Modeling
0 lessons
1 system design
3 community items
data-modeling
Community
3 items
Article
SQL vs NoSQL: Stop Asking the Wrong Question
The choice that matters is not the data model. It is which guarantees you need on read and write. A decision table and the JSONB middle ground that retired half my Mongo use cases.
Article
Database Migrations: A Zero-Downtime Playbook
Adding a column, renaming a column, dropping a column, splitting a table. The expand-contract pattern, the four-step rename, and the migration phases that have kept me from taking the site down.
Article
MongoDB Aggregation Pipelines, by Example
Match, group, lookup, project, the four stages I use 90% of the time. Real pipelines for funnel analysis, leaderboard, and a one-stage join, with the gotchas that surprise SQL refugees.
