Search Mac Software Downloads
|
Deals: Daily  /  Discount Store  |  Weekly Popular  |  Hot Picks  |  iPhone  |  Mac OS X  |  AboutAdd a File +
DESCRIPTION
PGnJ is an intuitive SQL Database Development Environment for Mac OS X. PGnJ is surprisingly simple, yet extremely powerful for working with databases. Unlike alternative clients, PGnJ’s unique, single window interface gives you everything you need, right at your fingertips. PGnJ supports PostgreSQL, MySQL, Oracle and SQLite.
Download Now
WHAT'S NEW
Version 1.0:
  • [NEW] Oracle support added. (Thanks, Lorgio!)
  • [NEW] SQLite support added. (Thanks, Milan!)
  • [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. (Thanks, Lorgio!)
  • [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 tree's 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 editor's 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 it's 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. (Thanks, Manton!)
  • [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 doesn't 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 isn't 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. (Thanks to Werner, the Quaqua developer!)
  • [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. (Thanks to Werner, the Quaqua developer!)
  • [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. (Thanks to Werner, the Quaqua developer!)
  • [FIX] Columns of a table no longer sporadically appear multiple times in the table details area.
REQUIREMENTS
Mac OS X 10.4 or later.


SCREENSHOT

Developer:Thomas Mango
Downloads:8,272
  - Version d/l:540
Development:Editors
License:Demo
Date:03 Dec 2008
Platform:PPC/Intel
Price:$49.00
RATING
****½
OTHER PEOPLE SUGGEST
Suggest something else:
PGnJ User Reviews (3 posts)Write A Review
sort: smiles | time
Feb 17 2008
****.

STOSH1985  This is an excellent application! Anyone working postgres on Mac OS X will find this a wonderful tool to aide in their development. I've been working with postgres for a year and a half and when I first started I missed the lack of utilities that other DB servers like MySQL had available to them. Finding PGnJ filled the gap and has helped me immensely. I've even come to use it for MySQL development as it's so much better than the unstable MySQL distributed GUI Client. It's light-weight, fast and does the right job - what more could you ask for? Keep up the great work!  
(Version 0.8)

praisebury
+1
[ Reply ]
Aug 7 2007
*****

KOODOUGH  Great simple App. I found it hard to view all of my data in my database when I starting to learn SQL until I found PGnJ.

Just one thing that needs to be changed. I'm not able to edit my connection presets. I'm a bad at typing and I have all of these misspelled presets I can't edit nor delete them.  
(Version 0.7)

praisebury
+1
[ 2 Replies - Reply ]
Replies:
Aug 7 2007

THOMAS MANGO  KOODOUGH,

Thank you for your review! I wanted to just let you know that you can manage your bookmarks (change, add, remove) by selecting 'Manage Bookmarks' from the 'Database' menu.

Here is a quick screencast showing how to use this feature. Thank you for using PGnJ!  
(Version 0.7)

praisebury
0
Aug 7 2007

THOMAS MANGO  KOODOUGH,

Sorry, I forgot the link to the screencast. Here you go: http://www.screencast.com/t/ugl1uJh5  
(Version 0.7)

praisebury
0

Jun 20 2005
****.

MATTEO RATTOTTI  This is a very nice postgres client, you've done a good work.

This program need to grow a little bit, but it's very promising ;-)  
(Version 0.4)

praisebury
+1
[ Reply ]