Quarry moves aggregates for construction sites across three countries. Every one of their 9,000 trucks sends a GPS ping every five seconds.
One join, always current
Pings stream in over MQTT. Orders and assignments arrive by CDC from the dispatch database. A single Basalt view joins them, so every truck carries its current job, ETA and load.
- 1,800 pings per second at peak.
- Dispatchers query the view from a map that refreshes every second.
- Drivers see the same ETA in their app.
Before Basalt our map was five minutes behind. Now it is behind by the speed of light.
Late deliveries fell 22% in the first two months, mostly because dispatchers could reroute before a truck hit traffic, not after.
Sigrún leads the query engine team in Reykjavík. Before Basalt she worked on storage at a Nordic payments company, where she learned to distrust any latency number without a percentile next to it.
