Discover the best of the web!
Learn more about Digg by taking the tour.
Visual Database Explorer in Ruby
igvita.com — A how-to for a quick visual database explorer in Ruby. Learn how to build a quick threaded web-server, access SQL databases from Ruby, and how to create SVG graphs on the fly. The result.. A dynamic visual browser to help you find that needle in the haystack of information hidden away in your databases!
iGrigorik- 567 diggs
- digg it
- JoeBaynham, on 10/12/2007, -33/+8Wow seems helpful. Not doubt I will get dugg down for saying just that.
- acetv, on 10/12/2007, -11/+24No, you'll get dugg down for saying that you'll get dugg down for saying that.
- headzoo, on 10/12/2007, -4/+10Site is dead. No Dugg Mirror cache. No Google cache. No Coral cache. No Archive.org cache.
Nothing to see here folks. BTW - Why do hosting companies pull the plug on a site's database when it's getting dugg? Is that really the professional way to handle things?- rprouse, on 10/12/2007, -0/+9No, just most cheap hosts have MySQL set up with a very low connection limit to prevent excess load on the server. Many of the hosts today either host dozens of sites on each server or if you have your own server, it is actually a virtual server sharing a real one. Either way, one heavily dugg site can slow down many others.
Too many people here blame wordpress for this, but it is just the victim of the low connection limit. Any dynamic web site that doesn't have pre-cached pages would be affected the same way. Some people like moveabletype for that, but I always hated rebuilding my site with every change. - rprouse, on 10/12/2007, -1/+5I always makes me laugh when people around here immediately blame Wordpress (because it is the only CMS with an identifiable error message.) How many other sites out there get dugg to death and stop even responding? You don't bitch about those because you don't even know what they are running.
The person to blame is the site's owner, no matter what they are running, for expecting some two bit host that they pay a few dollars a month for to stand up to any real load. Reliable hosting costs money. - RetroRufio, on 10/12/2007, -3/+2@rprouse
Dude, MySQL rocks cheap or no - habibbijan, on 10/12/2007, -3/+0The site's back up now, but it's funny that digg killed the site. Ironically, the site owner is also the owner of a web hosting company (see his "about" page).
One would think that as the FOUNDER of a hosting company, he would have the resources not to get dugg to death. - rprouse, on 10/12/2007, -1/+4@RetroRufio
I called the hosting companies cheap, not MySQL. MySQL rocks, but it is not much good when your hosting company sets it up with something like a 6 connection limit. - RetroRufio, on 10/12/2007, -2/+2@rprouse
My apologies, I misunderstood...
Will you still be my friend? :) - rprouse, on 10/12/2007, -2/+1@RetroRufio
I'll forgive you this time, but don't let it happen again ;P
- rprouse, on 10/12/2007, -0/+9No, just most cheap hosts have MySQL set up with a very low connection limit to prevent excess load on the server. Many of the hosts today either host dozens of sites on each server or if you have your own server, it is actually a virtual server sharing a real one. Either way, one heavily dugg site can slow down many others.
- SirSpank, on 10/12/2007, -11/+0Wow that's great. Maybe the site hosting the link needs it too. Here's the error message I got when I clicked on the link:
WordPress
Error establishing a database connection
This either means that the username and password information in your wp-config.php file is incorrect or we can't contact the database server at localhost. This could mean your host's database server is down.
* Are you sure you have the correct username and password?
* Are you sure that you have typed the correct hostname?
* Are you sure that the database server is running?
If you're unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress Support Forums. - vSanity, on 10/12/2007, -5/+8http://duggmirror.com/programming/Visual_Database_Explorer_in_Ruby/
They have cache of the site down.- rprouse, on 10/12/2007, -2/+4Looks like a cache of the error message to me :D
- leobaby, on 10/12/2007, -1/+3thats what he said.
- jlgosse, on 10/12/2007, -9/+2No, they don't.
- val8ntin, on 10/12/2007, -2/+4Duggmirror cached the error page and not the actual site. Thats what he means.
- leobaby, on 10/12/2007, -5/+1duggmirror dontmirror
- macboy, on 10/12/2007, -5/+9That is crazy. The site is down, and there is NO cache, yet it is still getting dugg!! I just checked, it went up 2 diggs in 2 minutes. Proof many diggers don't read the articles!
- tpaine, on 10/12/2007, -3/+10i just dugg it so i could come back later and read it ;-)
- prockcore, on 10/12/2007, -9/+2Yet another dead wordpress blog. Stop using wordpress, people!
- rprouse, on 10/12/2007, -1/+6No, stop using cheap hosts with low database connection limits AND install the wordpress caching plugin. Any dynamic site will go down under load if your crap cheap host has a 6 connection limit in MySQL.
See my post above for more info... - prockcore, on 10/12/2007, -0/+3Yes, but wordpress is the only blog software that makes 27 separate queries to load a single blog entry.
That means it can only handle 1/10th the traffic of other blogs, on the same host with the same restrictions.
- rprouse, on 10/12/2007, -1/+6No, stop using cheap hosts with low database connection limits AND install the wordpress caching plugin. Any dynamic site will go down under load if your crap cheap host has a 6 connection limit in MySQL.
- Blizzardman, on 10/12/2007, -5/+3I seriously wish someone would just buy Wordpress and delete the entire ***** thing.
- vSanity, on 10/12/2007, -0/+3Wordpress is a good and easy to use system. But they do need to include a cache system by default, and advise users to actually USE IT!
- cosequin, on 10/12/2007, -1/+0it should be on by default, but that would mess many things up.
- laz45, on 10/12/2007, -2/+6It's not the fault of Wordpress that the site is down idiots...
- stelt, on 10/12/2007, -5/+0Thanks digg. After http://www.digg.com/programming/New_SVG_Features_in_Firefox_3_Alpha and http://www.digg.com/programming/The_Wii_Supports_SVG_in_its_Opera_Browser and
http://www.digg.com/software/Adobe_MARS_Looks_Interesting this is the 4th thing to add to my SVG links on http://svg.startpagina.nl - SirSpank, on 10/12/2007, -6/+1Just goes to show you how many ignorant ***** there are out there. All of the idiots who dug me down failed to see the irony in my message. I wasn't blaming WordPress for anything. I was making a ***** joke that this link was supposed to lead to information about a database tool that I ended up getting a database error on. Lighten up and get a ***** life you assholes!
- technoweenie, on 10/12/2007, -0/+1Go ruby! Though, I'm wondering why he wrote a socket web server from scratch when he could have just used mongrel?
- iGrigorik, on 10/12/2007, -0/+2I can answer that... The entire app was 'in a spur of the moment' type project. I stumbled on Scruffy, got the idea and an hour later I had it up and running. Now, I could have used ActiveRecord and Mongrel (Webrick even), but it just came down to the first thing that popped into my mind. And it just so happened that I recently finished a c++ project for a distributed systems course.. sockets were fresh in my mind.
To make long story short, it's the availability bias!
- iGrigorik, on 10/12/2007, -0/+2I can answer that... The entire app was 'in a spur of the moment' type project. I stumbled on Scruffy, got the idea and an hour later I had it up and running. Now, I could have used ActiveRecord and Mongrel (Webrick even), but it just came down to the first thing that popped into my mind. And it just so happened that I recently finished a c++ project for a distributed systems course.. sockets were fresh in my mind.
- jrsims, on 10/12/2007, -0/+4That is a beautiful charting library he's using!
Does anyone know if there's anything like Scruffy for Python?
Yes, I know there are charting libraries for Python out there already, but I haven't seen anything that gives output as nice as Scruffy does.
BTW, the Scruffy site:
http://scruffy.rubyforge.org/- gdm9000, on 10/12/2007, -0/+1I've spent a long time looking for something this beautiful for Python. I use Excel for Python (for paper reports - not web apps), and my main problem with it is I've outgrown its limitations. I've seen some really nice charting tools for .Net and Java, but Python is lacking. Scruffy would seriously make me consider Ruby if I did web app charting. Presentation is beautiful, but I'd also have to consider its capabilities.
- floguy, on 10/12/2007, -0/+1Why use that when you can use something that looks great and works client-side like PlotKit? The site is located here: http://www.liquidx.net/plotkit/
Digg is coming to a city (and computer) near you! Check out all the details on our 
© Digg Inc. 2008 —
Content posted by