vsbabu.org

ViennaSQL and PostgreSQL

Now that we have installed PostgreSQL in Mandrake 9.1 and added Java connectivity, we can try using ViennaSQL, a simple and very light weight - just 230Kb - GUI client to browse and use the database.

Install & Start

Installation couldn’t be simpler! Download vienna.jar and drop it into any folder in your system.

To run it, execute the following command:

java -classpath $CLASSPATH:/usr/share/pgsql/pg73jdbc3.jar:vienna.jar \
 uk.co.whisperingwind.vienna.MainController

After the splash screen, you will see a simple GUI coming up.

Adding a connection to our database

Go to File -> Configure menu and switch to Connections tab. Click on New Connections button and fill out the connection information as below. Note that my database name and user name is vsbabu; yours will differ.

Options Screenshot

You can test if your connection works here.

Try a query

Once you have configured the connection, all you need to do is to select that connection from the drop-down on the top-right corner in the main menu. Once it is connected, you can type in a query and execute it. Results are shown in a nice table.

Sample Query Screenshot