3

I am looking for a solution to generate graphs from MySQL tables (local MySQL server).

I would like it to work on Windows, and not be based on a server (like a PHP server). This is just basic stuff: extract the content of the table and generate a graph from that (the table has 2 columns).

I have tried Excel to do that, but it requires installing a plugin to support the MySQL connection, and the configuration is not really straightforward so it's not really fitting. The thing is a whole team will install the application, so I'm looking for the most straightforward solution.

Additionnaly, I've tried using cygwin and GNU plot, but it also requires installing plot through the cygwin installer... Not very simple. I'm just looking for an application (or a script) that can do it easily without extended configuration and installing dependencies.

Edit: To sum up, I am looking for the minimal setup process

closed as off-topic by Máté Juhász, fixer1234, jonsca, Twisty Impersonator, Burgi Mar 18 at 9:04

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions seeking product, service, or learning material recommendations are off-topic because they become outdated quickly and attract opinion-based answers. Instead, describe your situation and the specific problem you're trying to solve. Share your research. Here are a few suggestions on how to properly ask this type of question." – Máté Juhász, fixer1234, jonsca, Twisty Impersonator, Burgi
If this question can be reworded to fit the rules in the help center, please edit the question.

  • You do realize that the most minimal setup is using a web server. The client types in the URL and bang there it is. Maybe you add a user/pass to control access. Yes, you do have to setup a server, but only 1 time by 1 person. You can't get simpler than that. – cybernard Mar 14 at 13:41
  • @cybernard you do realize this question is 8 years old. And actually there is a simpler solution to this question than what you think: metabase.com Just download it and run it, "it can't get simpler than that" (you missed the point of "who is going to use it"). I'll add it as an answer and accept it. – Matthieu Napoli Mar 15 at 14:56
0

Have a look at iReport (Open Source). It takes a bit of setup but the results are worth it.

http://jasperforge.org/project/ireport

"iReport is the free, open source report designer for JasperReports. Create very sophisticated layouts containing charts, images, subreports, crosstabs and much more. Access your data through JDBC, TableModels, JavaBeans, XML, Hibernate, CSV, and custom sources. Then publish your reports as PDF, RTF, XML, XLS, CSV, HTML, XHTML, text, DOCX, or OpenOffice."

  • I'm looking for the minimal setup process. I'm going to emphasise about that in the question. – Matthieu Napoli Oct 7 '11 at 12:27
0

8 years later, I would recommend Metabase for these use cases.

It's simple to setup for a local usage:

  • download
  • open the app
  • configure your database
  • plot your graphs

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