PGnJ 1.0

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.
Rather than having one window to view table information, one window to view data and another for executing SQL, PGnJ provides a single, uncluttered window for a single connection.

Main features:
- Supports PostgreSQL and MySQL.
- Connection bookmarks.
- Database tree and column inspector.
- Query editor.
- Syntax highlighting and error suggestion.
- Table data viewer and editor.
- SQL execution history with quick navigation from editor.
- Export data in SQL, XML, CSV, HTML and TSV.
- Automatic software update.

Enhancements
- [NEW] Oracle support added.
- [NEW] SQLite support added.
- [NEW] Tab completion support for table and column names added to the query editor.
- [NEW] A Script Library for managing SQL scripts added (:variables supported).
- [NEW] A template system for generating DDL SQL templates.
- [NEW] A common toolbar has been added to the Query Editor and Script Library views.
- [NEW] A filter bar (CMD+F to focus) to filter and order data with SQL added in the DataBrowser.
- [NEW] The bookmark manager can now remember connection passwords.
- [NEW] The execution engine has been completely rebuilt from scratch to better handle multiple queries regardless of type.
- [NEW] The database tree now automatically refreshes when DDL is detected.
- [NEW] The database trees state is now recalled when the database is refreshed (expanded nodes remain expanded, selected node remains selected).
- [NEW] SQL can now be executed directly from a file without first loading it into the query editor (for larger scripts).
- [NEW] It is now possible to drop one more files directly onto the query editors input area to load sql.
- [NEW] Right clicking on a result set now reveals a pop-up menu that allows copying the content of either a single cell or the entire row in CSV format to the clipboard.
- [NEW] The bookmark manager now remembers the last selected database type to ease the task of adding bookmarks.
- [NEW] Table details are now pre-fetched in a background thread after connection to database is established.
- [NEW] A drag handle has been added to the bottom left action bar to make resizing the sidebar easier.
- [NEW] PGnJ can now remain running without any windows open (like standard Cocoa applications).
- [NEW] Experimental horizontal scroll wheel support added (use preference to toggle).
- [NEW] Added preference to convert all zero datetimes in MySQL to NULL (on by default; off causes exception).
- [NEW] Added menu items and keyboard shortcuts to navigate the table details at the bottom of the sidebar.
- [NEW] A shortcut (CMD+T) to focus on the database tree in the sidebar has been added.
- [NEW] A shortcut (CMD+W) to close the preferences window when it is visible has been added.
- [NEW] When started, PGnJ now specifically asks if its okay to check for updates rather than defaulting to autochecking.
- [CHANGE] CSV Export no longer wraps integers, floats and booleans in quotes.
- [CHANGE] The connection sheet and bookmark manager are now fully keyboard navigable.
- [CHANGE] The connection sheet now cancels on escape.
- [CHANGE] The keyboard shortcut CMD+E and menu item Database > Execute SQL now executes SQL when the QueryEditor is visible and reloads the DataBrowser when the DataBrowser is visible.
- [CHANGE] Altered the row selection behavior on the database tree so that clicking on an expand/collapse arrow doesnt highlight that row unless the currently selected row is a child of that row.
- [CHANGE] When using CMD-UP/CMD-DOWN quick history from the Query Editor, if there is SQL currently in the Editor, it is added to the history so that it isnt lost.
- [CHANGE] The history browser (CMD-SHIFT-H) no longer automatically executes a SQL statement after selecting it and appropriately cleans up the query editor before loading the selected SQL.
- [CHANGE] Connection sheets are now correctly document modal.
- [CHANGE] Menu items are now properly enabled or disabled based on the context of the application.
- [CHANGE] Where necessary, tooltips are assigned to disabled menu items to explain how they can be enabled.
- [CHANGE] All tables are now borderless to be more in line with current trends in OS X application design.
- [CHANGE] The background color of the sidebar has been darkened slightly to better resemble the sidebar background colors of other OS X applications.
- [CHANGE] Polished dialogs with more appropriate copy and icons.
- [CHANGE] The QueryEditor now receives focus upon a successful connection to a bookmark.
- [CHANGE] When resizing the window, the sidebar now only grows the area containing the database tree rather than the table details section at the bottom.
- [CHANGE] Updated Quaqua LAF to version 5.0.1.
- [FIX] Now able to issue ALTER, CREATE and DROP statements to MySQL databases.
- [FIX] When a new bookmark is setup to connect to, it is now only added if the connection is successful.
- [FIX] The AutoCheckForUpdates preference is no longer (accidently) ignored.
- [FIX] Style changes in the query editor are no longer registered in the undo/redo history.
- [FIX] When loading a sql file, the QueryEditor properly replaces the current view.
- [FIX] Dialogs (sheets) now correctly gain focus, enabling keyboard interaction.
- [FIX] Columns of a table no longer sporadically appear multiple times in the table details area.