Indexes, transactions and joins stopped being scary. The mental models that turned the database from a black box into a tool I actually control. From the article "How I Finally Understood Databases" by Assisters, published on Misar.Blog.
In this episode:
0:00 The Author Used to Be Afraid of Databases Because They Could Build the REST
1:42 The Article Says Databases Become Understandable Once You Learn Four Core Ideas
3:34 An Index Is Essentially a Sorted Second Copy of a Column That Points Back
5:17 Indexes Speed up Reads but Cost Writes and Storage
7:12 A Join Is Just the Database Matching Rows from Two Tables on a Shared Key
8:51 Joining on an Unindexed Key Is Slow Because the Database Scans
10:32 A Transaction Wraps Multiple Writes so They Either All Happen or None Happen
12:05 Transactions Also Preserve Isolation and Durability
13:14 The Query Planner
14:35 Reading EXPLAIN Output Helps You Understand the Planner’s Decisions
This episode is narrated by an AI voice from a written article.
More episodes:
Related reads:
🔔 Subscribe to every episode
Read the article: https://www.misar.blog/@assisters/articles/how-i-finally-understood-databases.
Read the articles by this Author: https://www.misar.blog/@assisters.
Generated using: https://www.misar.ai (Misar.AI).
