Re:ChartSQL: Create Charts and Dashboards from SQL
by ams6110 on Sunday November 16, 2014 @11:18AM
(#8614541)
It's generally not very difficult to get SQL query results in JSON rather than tabular format and then feed that to your favorite charting tools.
[ Parent
| on HN ]
Re:ChartSQL: Create Charts and Dashboards from SQL
by paulasmuth on Sunday November 16, 2014 @11:22AM
(#8614557)
However that means you have to write a heap of reptitive glue code (or sed incantations if that's your thing) to mangle your SQL Results into the JSON format your charting tool wants. If you run a lot of ad-hoc queries you have to waste a significant amount of time on this boring legwork that could much better be spent on interesting tasks.
FnordMetric aims to fix that by extending standard SQL; it allows you to express the data query and the chart specification in a coherent fashion (SQL).