Protovis (vis.standford.edu) is very flexible tool to show data. Protovis is based on Javascript. I am looking for a detailed sample to get data from a MySQL (Postgres or Oracle) database into a Javascript array to show it in a Protovis Graph. Additionally it would be vers interesting to see how interactively the data shown in the graph is changed/varied |
I've written an explorer for http://wheredoesmymoneygo.org/ that pulls data dynamically: http://rufuspollock.org/wdmmg/explorer.html However, is uses the Where Does My Money Go API rather than a mysql database. In your case, an one approach would be do dump the data you needed from mysql to csv, and then convert it to json which you could then handle from javascript. I know this isn't very specific advice. However it is difficult to answer your question properly as I don't know exactly what data structure (and visualization in protovis) you want to use. |