Choosing a Datastore
What each family of store is actually good at, and why "Postgres until it hurts" is usually the right default.
5 topics
Relational vs Document
What a document database actually buys you now that Postgres has JSONB, and the one thing it still buys.
core20 minKey-Value Stores & Redis
What Redis is genuinely good at — caching, rate limits, queues, ephemeral state — and why it is a bad primary database.
core20 minFull-Text Search Engines
How an inverted index answers a text query, and the honest threshold for moving off Postgres to Elasticsearch.
core20 minOLTP vs OLAP & the Warehouse
Why row storage suits transactions and column storage suits analytics, and why running dashboards on the production database eventually fails.
core20 minObject Storage & Large Blobs
Files belong in S3 with a row pointing at them — and the upload should never pass through your server.
core20 min