News for hackers. Stuff that matters.
Re:ChartSQL: Create Charts and Dashboards from SQL by sida on Sunday November 16, 2014 @01:27AM (#8613596)
Upon second look I believe I misunderstood the purpose of the project.

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

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.