Skip to main content

Posts

Showing posts from November, 2025

Streaming vs Batch databases

To understand the difference between Batch and Streaming databases, it’s best to stop thinking about the "database" as just a storage box and start thinking about how it handles time . The Simple Analogy: The Laundry vs. The Waterfall Batch Processing (The Laundry): You don't wash every sock the second you take it off. You wait until the basket is full (a "batch"), then run a cycle. You get a lot of clean clothes at once, but you have to wait for the cycle to finish to wear any of them. Streaming Processing (The Waterfall): Imagine standing under a waterfall with a cup. You aren't waiting for the river to stop; you are interacting with the water as it moves. You get a drink the instant the water hits your cup. I will use 2 scenarios to explain these 2 concepts; Scenario 1: The "Dull" Monthly Report (Batch) The Setup: A retail chain wants to know their total profit for November. How it works: At the end of the month, the system gathers millio...