Menu
I have a fairly simple mysql database. I want to extract data from it and display as a graph to analyze it. Nothing advanced, just line diagrams and such. As a programmer I can always write some code for this myself. But does anybody know of a program that can load data (using sql queries?) and display it in various graphs?
731
asked May 20 '11 07:05
Visualize your MySQL data and gather it into thematic dashboards from multiple sources, share the story your data tells with your team or extermal partners. Supported visualizations:Charts: Line, Bar, Area, Pie, ScatterBoxplotCohortSunburstWord CloudSankeyMapCounterPivot Table...and more are on the way.
Percona Monitoring and Management lets you plot MySQL data in real time. You do not have to move it anywhere or change anything! Just grant read access from PMM, and you can start to create your own graphs!
Just select a database, type an sql query & click Run Query. Chart Preview will render your chart. You will see charts being generated on the fly. Change type of chart by clicking on the list of chart types below the boxes (Table, Line, Bar, etc).
You can fetch data from MYSQL using the fetch() method provided by the mysql-connector-python. The cursor. MySQLCursor class provides three methods namely fetchall(), fetchmany() and, fetchone() where, The fetchall() method retrieves all the rows in the result set of a query and returns them as list of tuples.
Checkout DBPlot for Windows environment.
158
answered Oct 27 '22 05:10
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With