What Actually Happens Inside a Database?

What actually happens after your app saves a record or asks the database to find it? In this Our Dev Journey episode, we follow a growing application from a simple profile update to reports over historical events. You’ll see how databases organize data, why small requests can create extra work, and how different storage designs serve different workloads. We explore: • Hash indexes, append-only logs, and compaction • Sorted files, LSM trees, and Bloom filters • B-trees, pages, and recovery • Read, write, and space amplification • Secondary, composite, spatial, and full-text indexes • In-memory storage and durability • OLTP, OLAP, and analytical pipelines • Column-oriented storage, compression, and materialized views The goal is to help you reason about what your database must do to answer a request—and choose designs based on your application’s needs. Subscribe to Our Dev Journey for visual explanations that connect everyday code to system design. #SystemDesign #DatabaseInternals #OurDevJourney #Databases #SoftwareEngineering #DatabasePerformance #BackendDevelopment #DataEngineering