Problem
Design a driver location heatmap that aggregates GPS pings into city-wide density views
- Route high-volume writes and hot cells without pinning partitions
- Deliver sub-second live freshness while keeping deep historical scans cheap
- Rebuild live state after crashes and deduplicate late pings
Key Test Points
- H3 minute buckets
- Kafka replay for rebuild
- History on ClickHouse rather than Redis
Spot an issue or have a suggestion?