2007W


Instructor
TA




MAT259 Visualizing Information(4 units)


George Legrady
Charlie Roberts


Lecture: Tuesday 10:00-12:00, Lab: Thursday 10:00-12:00 - e-studio/Arts2220


Lab 4

We started today with a review of how to define a class in Processing, then reviewed how to parse xml/rss feeds and store our results inside of the class we just created to be animated. Below is the example from class:

SuperText.zip

We then jumped into MySQL, using the MySQL Query Browser application to program our databases and test sample queries. Finally, we looked at the Processing MySQL library, and used it to import information from our database and visualize it. The example is below:

mysql_a.pde

Below are a couple of links to cheat sheets for doing MySQL programming:

http://www.ilovejackdaniels.com/cheat-sheets/mysql-cheat-sheet/
http://www.nparikh.org/unix/mysql.php

Here's a link to the MySQL Query Browser:

http://mysql.com/products/tools/query-browser/

And last but not least, here's a link to the MySQL library for Processing:

http://www.bezier.de/mysql/


Assignment 4 due 2/8/07
 

The assignment is to create a table in MySQL using a data source of your choice. The table should contain at least 6 columns of multiple data types. For extra credit, after getting the data into MySQL, bring it into Processing (via the MySQL library) and visualize it.