layout hack
layout hackMain Pagelayout hack
layout hack
RSS Feed RSS Feed Main page
layout hack
layout hack
layout hackAbout Melayout hack
layout hack
Software I wrote
Resume
Friends of mine
Pictures
Musicianship
Stuff I have for sale
layout hack
layout hack
layout hackPersonal Newslayout hack
layout hack
2010:
March, April.
2009:
January, March, August.
2008:
Jan, Feb, Apr, May, July, August, September, October.
2007:
Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec.
2006:
Jan, Feb, Mar, Apr, Jun, Jul, Aug, Sep, Oct, Nov, Dec.
2005:
Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec.
2004:
Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec.
2003:
Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec.
2002:
Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec.
2001:
Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec.
2000:
Jan, Feb, Apr, May, Jun, Jul, Aug, Oct, Nov, Dec.
1999:
Jan, Feb, Jun, Oct, Dec.
1998:
Jul, Aug, Sep, Nov.
layout hack
layout hack
layout hackGeek Stuff (computer related)layout hack
layout hack
Digital Music
Java
Why LiveWire Sucks
Why ASP Sucks (a bit)
Linux
MacOS
Unix
Oracle
Perl
Emacs
O'Reilly
layout hack
layout hack
layout hack(some of) My Interestslayout hack
layout hack
Humor
Sony Playstation
Cars
layout hack
layout hack
layout hackSearchlayout hack
layout hack

layout hack
layout hackAdslayout hack
layout hack



SQL Tool (nice creative name eh?)

I wrote a JDBC SQL tool to help me execute statements against databases, so I could see what was coming out via JDBC. There are character based tools (ISQL, SQL Worksheet, SQL*Plus, etc.) that let you execute statements too but they don't use JDBC, and the output is formatted with fixed-width fonts so it's a pain to read. Mine is better because you can (a) pick a driver class at runtime, (b) pick a JDBC URL at runtime (which is useful if you haven't figured out what it should look like yet), and (c) the output is formatted in an HTML table for readability. There are other advantages, such as the query timer (how many seconds did it take?) and the fact that you can just hit "back" a few times to get your old queries back too. It's a Java Servlet, since Servlets rock and that was what I was using when I needed to see what was up with some Oracle queries I was optimizing.

BTW I based the JDBC SQL Tool on an NT-Perl SQL Tool which uses Dave Roth's Win32::ODBC module. There isn't a Unix Perl SQL Tool with DBI because by the time I wrote the NT Perl one I was already fed up with the poor performace of Perl CGI scripts, and FastCGI wasn't cutting it either due to stability issues. So I was not inclined to develop more Unix Perl CGI's that used databases.