PGnJ

PGnJ Publisher's Description:
PGnJ is an application, written in Java, for managing PostgreSQL databases. Unlike many database management applications, PGnJ provides (and will continue to provide more) extended functionality and information by generating and running SQL statements. By doing this, it is easy to create a unified interface rather than having, for instance, one window to view table information, one window to view data and another completely separate window for running arbitrary SQL statements. PGnJ provides a single, un-congested window for a single connection. I feel that this interface design is much cleaner and generally more enjoyable to use than other implementations of database management applications.

Features

* Connect from connection bookmarks
screenshot 1 screenshot 2 screenshot 3
* Create new connection bookmarks
screenshot 1 screenshot 2
* Table list loaded when connection established
screenshot
* View table data by double clicking a table
screenshot
* Get column names and types
screenshot 1 screenshot 2
* Execute arbitrary SQL statements
screenshot
* Reports SQL errors along with syntax suggestions
screenshot 1 screenshot 2
* Open multiple browser windows
screenshot
* Load SQL from file
screenshot 1 screenshot 2
* Save SQL to file
screenshot 1 screenshot 2 screenshot 3


What's new in this version:
Although this is only version 0.2, it overs a huge upgrade in functionality and overall general experience in version 0.1 and makes a big step towards the general interface philosophy I have in mind for PGnJ. In this update, I have rewritten the original UI. Despite looking similar, the way the interface functions, as opposed to version 0.1, is quite different. I implemented custom dialogs for making connections and creating new connection bookmarks while removing the idea of connecting to bookmarks through the tree list and a menu item.