DbConsole


Author: Dale Anson
Version: 2.0.1

Introduction

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.