Read a PostgreSQL query plan without getting lost
Follow the work through a query plan, compare estimates with actual rows, and learn what to investigate before adding another index.
Your daily dose of database knowledgeBig database ideas.
Big database ideas.
A few good minutes.
Understand the tools. Master the fundamentals.
Build better data systems, one practical lesson at a time.
Practical examples
Clear explanations
Always curious
your_next_breakthrough.sql
01-- Small lessons. Lasting knowledge.
02SELECT understanding, confidence
03FROM your_daily_learning
04WHERE curiosity = true
05LIMIT a_few_minutes;
A little better than yesterday∞ possibilities
One concept. Real clarity.That's a DB Minute.
✳From your first query to your next architecture
SQL & NoSQLCachingAnalyticsCloud databasesData engineering
Follow your curiosity
All technologies
A whole world of data. Find your corner.
Relational databases
SQL, schemas, and the engines behind your applications.
Explore topicNoSQL databases
Documents, key-value data, and flexible ways to model it.
Explore topicCaching & in-memory
Faster reads, thoughtful invalidation, and fewer surprises.
Explore topicAnalytics & warehouses
Turn data into answers, from your laptop to the cloud.
Explore topicSearch engines
Find the right results in a world of unstructured data.
Explore topicVector & AI search
Embeddings, similarity, and retrieval that makes sense.
Explore topicPipelines & streaming
Move, transform, and connect data across your systems.
Explore topicDeveloper tools
Migrations, administration, and the tools of the trade.
Explore topicA FEW FAMILIAR FACES
The deeper dive
A CLEARER VIEW OF WHAT'S UNDER THE HOOD
Editor's reading desk
Read a PostgreSQL query plan without getting lost
Follow the work through a query plan, compare estimates with actual rows, and learn what to investigate before adding another index.
Read the guideFresh from the library
View all articles
Your next “now I get it.”
MySQL composite indexes: why column order matters
Build an index around a real access pattern, then use EXPLAIN to understand what it helps—and what it doesn't.
Window functions: keep the rows, add the context
Calculate a running total and rank orders within each customer without collapsing the underlying rows.
Cache-aside with Redis: the easy part is the lookup
Follow a cache hit and miss, then work through invalidation, stale data, and the race conditions hiding between them.
Expiration and eviction are two different promises
A TTL controls freshness over time. An eviction policy controls what happens under memory pressure. Your cache needs both decisions.
MongoDB: embed the data you read together
Choose document boundaries from access patterns, growth, and update behavior rather than translating relational tables one-for-one.
Same curiosity. A bigger sky.
Explore cloud guides
Take your knowledge to the cloud.
aws⌣
Amazon Web Services
From RDS and DynamoDB to Redshift and Athena. Make sense of the services, architecture, and operational decisions.
Explore AWSA
Microsoft Azure
Explore Azure SQL, Cosmos DB, and Microsoft's analytics ecosystem, including Fabric and its data engineering tools.
Explore AzureG
Google Cloud
Connect Cloud SQL, Spanner, and BigQuery with the tools that ingest, process, and govern your data.
Explore Google CloudThe platform may change. Good engineering principles don't.
A little structure for your next step
All learning paths
Don't just read. Build your understanding.
PATH 01
SQL, from the ground up
Build a working foundation in joins, window functions, and transactions. Small datasets make each idea easy to inspect.
3 lessons · Beginner
PATH 02
Make sense of database performance
Move from query plans to index design, then understand why analytical workloads ask different questions.
4 lessons · Intermediate
PATH 03
Cloud databases, with confidence
Understand availability, key design, connection budgets, and query costs across AWS, Azure, and Google Cloud.
6 lessons · Intermediate