Info

You are currently browsing the Tom Malaher’s BrainScan weblog archives for the day March 19, 2007.

Calendar
March 2007
S M T W T F S
« Dec   Apr »
 123
45678910
11121314151617
18192021222324
25262728293031
Categories

Archive for March 19, 2007

links for 2007-03-19

QueryForm

QueryForm: a Swing-based Java tool for editing database tables.

For those times when you just don’t want to write a CRUD interface or use raw SQL. DbVisualizer’s “Update where” and “Insert into” functionality is OK for one or two rows, but this tool lets you edit many rows almost painlessly.

powered by performancing firefox

DbVisualizer

DbVisualizer: essential tool. I practically live in it. I have it open all day every day. I use it for ad-hoc reporting, quick updates, and to build up, debug and validate the queries I put into my software. It will connect to anything that has a JDBC driver.

One of the features I’ve used is the charting of foreign-key relationships to build a cube-wall sized poster of the data model for a product we installed. I pasted together 9 letter-sized sheets (the product knows how to print the huge image in segments). Life saver.

I use the free version, and I’ve even tried out the “personal” (i.e. for-pay) version on a trial license for a while and the graphing capability was pretty fun too, but I have other ways to do that and so didn’t go for it.

powered by performancing firefox

|