DbConsole

Author: Dale Anson
Version: 2.0.1

DbConsole

DbConsole is a command-line Java application, that is, there is no GUI. DbConsole relies on the portability of Java and ubiquity of JDBC drivers to allow the user to run a single interface to relational databases regardless of the operating system or database server.

DbConsole allows the user to type in and execute SQL. A number of "meta" commands are built in, such as listing schemas, tables, and columns.

I used the "psql" application that comes with Postgresql (www.postgresql.org) as the model for the meta commands. I use psql a lot, and a similar program for Oracle, the two programs are close enough but different enough to cause me problems. Now I just use DbConsole for both, and it's no problem. I have used DbConsole with the McKoi database (www.mckoi.com/database) with very good success. I haven't tested much with other databases, I'd be interested in hearing any success or failure stories.

Here's a nice, unsolicited comment about DbConsole:
This program rocks!
I recently found myself in a situation where I need a console-based isql tool that is also database portable. I was hoping to find something Java based since I'm familiar with JDBC drivers. DbConsole fit the bill perfectly. Not only is it robust and intuitive, but it has a polished, "finished" feel to it that a lot of FOSS programs lack.