Re:ChartSQL: Create Charts and Dashboards from SQL
by timmclean on Sunday November 16, 2014 @02:19AM
(#8613656)
In case this is helpful: I interned at a company, Polychart, where we built a product similar to chart.io that is now open source and can be self-hosted: https://www.polychart.com/
Re:ChartSQL: Create Charts and Dashboards from SQL
by pca2 on Sunday November 16, 2014 @11:22AM
(#8614556)
Looks neat. However it appears to actually only support MySQL, despite it's website's claims
Re:ChartSQL: Create Charts and Dashboards from SQL
by bjelkeman-again on Monday November 17, 2014 @01:57AM
(#8617169)
Maybe we need to help them get wider support then.
Re:ChartSQL: Create Charts and Dashboards from SQL
by danmaz74 on Sunday November 16, 2014 @03:00AM
(#8613704)
Looks really interesting. Have you got any idea why they open sourced it?
Re:ChartSQL: Create Charts and Dashboards from SQL
by bjelkeman-again on Sunday November 16, 2014 @10:00AM
(#8614311)
Thanks. Just what I needed.
Re:ChartSQL: Create Charts and Dashboards from SQL
by paulasmuth on Sunday November 16, 2014 @12:06PM
(#8614702)
You didn't mistunderstand the purpose (However it's not an explicit goal of FnordMetric to substitute chart.io)
Here is an example that connects to a MySQL database on localhost: https://github.com/paulasmuth/fnordmetric/blob/master/fnordm...
Note that the IMPORT statement might be a bit misleading. The IMPORT statement only creates a "virtual table", it doesn't actually copy any data. As much of the query as possible is pushed down into MySQL/the external data source and the charts will be generated from the query result that is returned by the external data source.
I initially thought the project was a subtitute for chart.io. However, it seems like the project is about "collect and visualize data".
It is not to visual data by connecting to your own database. Rather it allows you to import data from an mysql database