Want to stay on top? Ruby Weekly is a once-weekly e-mail newsletter covering the latest Ruby and Rails news.
     Feed Icon

The Development of a Visual Database Explorer with Ruby

By Peter Cooper / December 12, 2006

Vdbex

Ilya Grigorik has put together a great article explaining how he has used Ruby, along with the Scruffy graphing library, to develop a basic visual database explorer.

Last night I wrote a quick database explorer for one of my projects (screenshot above). I had a database of lead stories for BBC, Yahoo News and NY Times over a period spanning Sept. 2004 to Aug. 2005 and I wanted to juxtapose and visualize different queries. The concept is simple, given two words (ex: war / peace), I wanted to see some aggregate calculations over the available document corpus.

At first, I wanted to write about a great Ruby graphing library (Scruffy) I found, but later realized that I could nail three different concepts at once: writing a simple threaded web-server, interfacing with a database, and generating live graphs (SVG/XML). It’s a nice trifecta and I learned a few nice tricks along the way, hopefully you’ll pick up something as well.

Check it out. I look forward to reading more stuff from Ilya.

Comments

  1. ariekeren says:

    http://www.igvita.com/blog/2006/12/11/visual-database-explorer-in-ruby/
    argh wordpress error...

  2. Peter Cooper says:

    Looks like it's okay again now.

Other Posts to Enjoy

Twitter Mentions