Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am looking for a free data graphing application that can pull data from MySQL and display it on a trend graph without any programming. It should use a GUI to select the data to be plotted, start time, end time etc. Ideally it could be historical data or live real-time data.

  • LiveGraph looks like it has all the features but it works with CSV data
  • Cacti is similar but it requires the data to be in RRDtool

Is there anything similar that is designed to retrieve data from a SQL database?

share|improve this question
    
What is your price range? ... Or free? –  BrianAdkins Jul 17 '12 at 0:12
    
Yes, Free. Prefer open source but not required. Modified original question –  Automate Jul 17 '12 at 0:38
    
How about excel? You could set up an odbc data source and suck the data into excel for graphing –  BrianAdkins Jul 17 '12 at 0:50
    
As BrianAdkins mentioned, Excel is probably your best option, if you have it? –  dav Jul 17 '12 at 11:42
    
I would rather not use Excel. I am leaning toward setting up something that dumps the DB table to a CSV file and then use LiveGraph –  Automate Jul 17 '12 at 16:13

3 Answers 3

Simple and free real time charts: sqlDashboards Connects to mysql/postgresql, allows heatmaps, bar charts, area charts, pie charts.. plotted straight from SQL queries and refreshed in realtime (5-10 seconds)

Disclaimer: I work for the company but I believe it fits exactly what you are looking.

share|improve this answer

I use tableau for BI data visualization, but it ain't cheap. However, it could work for your purposes, and they have a free trial.

http://www.tableausoftware.com/tableau-software

share|improve this answer
    
Thanks, I am familiar with Tableau but was looking for something simple and free. –  Automate Jul 17 '12 at 0:40

What about Stack Exchange's own Data Explorer?

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.