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

asked 20 Jan '11, 10:58

KingsNewClothes's gravatar image

KingsNewClothes
0111
accept rate: 0%


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.

link

answered 22 Jan '11, 22:19

rgrp's gravatar image

rgrp ♦♦
501122027
accept rate: 14%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×3
×2
×1
×1

Asked: 20 Jan '11, 10:58

Seen: 907 times

Last updated: 12 Jul, 08:09

powered by OSQA