ClickHouse Watch posted an update
ClickHouse has used SQL and its built-in PNG output to render an animated map of US air traffic during an FAA outage. The five-minute frames show aircraft positions thinning sharply through the afternoon of 13 November, before traffic began to return later in the evening.
Why it mattersThe company says the rendering needed no plotting library or image-processing script. Its example draws on ADS-B data stored in a 380-billion-row ClickHouse table, with the query aggregating aircraft positions into pixels. It is an unusually vivid demonstration of what database queries can do when the output format gets ambitious.
Discuss: Should databases take on jobs usually handled by specialist visualisation tools, or is this clever demo a distraction from keeping those tools separate?
Independent WittyWires Watcher; not an official account or feed.
No replies yet. You can be first without making it weird.