ChartSQL: Create Charts and Dashboards from SQL

Re:ChartSQL: Create Charts and Dashboards from SQL by sinatra on Sunday November 16, 2014 @01:50AM (#8613621)

This may be a good place to ask this question -- We are a small startup that has its data in MySQL database and google analytics. We are now focusing a lot more on our marketing/advertising efforts, and would love to have a dashboard on a big screen that can collect, show, and update this data everyday (or better still, real-time). What do people use for something like this?

[ Parent | on HN ]

Re:ChartSQL: Create Charts and Dashboards from SQL by Maxious on Sunday November 16, 2014 @02:05AM (#8613642)

If you can't afford Geckoboard, Dashing is open source https://shopify.github.io/dashing/

There's a tutorial specifically about MySQL https://github.com/Shopify/dashing/wiki/How-to%3A-send-mysql...

And a variety of Google Analytics (and other platform) widgets https://github.com/Shopify/dashing/wiki/Additional-Widgets

[ Parent | on HN ]

Re:ChartSQL: Create Charts and Dashboards from SQL by alexcash on Sunday November 16, 2014 @09:02AM (#8614210)

Check out http://www.sqldashboards.com/ live database charting and a command line version is available on the site aswell for generating reports.

[ Parent | on HN ]

Re:ChartSQL: Create Charts and Dashboards from SQL by rahilsondhi on Sunday November 16, 2014 @01:52AM (#8613623)

At InternMatch.com, we use Geckoboard - it pings our Rails app periodically for stats. Our Rails app uses this gem to expose endpoints to Geckoboard: https://github.com/ejdraper/chameleon

We do a bunch of other cool stuff too for stats. I'd be happy to help you if you ping me :)

[ Parent | on HN ]

Re:ChartSQL: Create Charts and Dashboards from SQL by sinatra on Sunday November 16, 2014 @02:00AM (#8613636)

Thank you! I'll definitely have to ping you in a day or two. BTW, Geckoboard seems to have most integrations that we would need. I'm wondering if you used any of them and if you'll say that the integration was very straight forward or if it needed to be told a lot to be useful

[ Parent | on HN ]

Re:ChartSQL: Create Charts and Dashboards from SQL by cheald on Sunday November 16, 2014 @02:06AM (#8613643)

Elasticsearch + Logstash + Kibana is a wonderful match for this if you want really deep dive into your data. You can slice and dice and aggregate and display it in a ton of different ways.

For counters, statsd + Librato is dead easy to set up and is really nice for communicating key metrics easily.

[ Parent | on HN ]

Re:ChartSQL: Create Charts and Dashboards from SQL by zhte415 on Sunday November 16, 2014 @02:47AM (#8613685)

Big screens are great for dashboards. I don't use Google Analytics (access and reliability of Google products is unstable where I am) so turned to Piwik, which stores analytical data in a database, so you have immediate access to, well, everything. Querying this can be easily automated.

[ Parent | on HN ]

Re:ChartSQL: Create Charts and Dashboards from SQL by takemikazuchi on Sunday November 16, 2014 @01:48PM (#8615009)

Chartkick is amazing:

http://ankane.github.io/chartkick/

[ Parent | on HN ]

Re:ChartSQL: Create Charts and Dashboards from SQL by IndianAstronaut on Sunday November 16, 2014 @02:51AM (#8613692)

Check out Shiny, which is a super easy platform I R to make dashboards.

[ Parent | on HN ]