Search Mac Software Downloads
|
MacUpdate Desktop 5     |     Weekly Popular  |  Hot Picks  |  iPhone  |  Mac OS X  |  About     |     Deals: Daily  /  Discount StoreAdd 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.

IMPORTANT: With OS X Java Update 4, there are some problems with 64bit java. If PGnJ immediately crashes when trying to start it up, navigate to /Applications/, right click on PGnJ, select Get Info and ensure that you have "Run in 32 Bit Mode" checked. Please email me if you have *any* problems whatsoever.

Download Now
WHAT'S NEW
Version 1.1:
  • PGnJ is now free. Enjoy!
  • When using the DataBrowser (double click a table from the database tree in the sidebar), you can how double click any cell to edit the contents (PostgreSQL and MySQL only).
  • Developed a brand new, one of a kind feature that I call QuickJoin (see a demo). When you open the DataBrowser, it will automatically add a QuickJoin bar to the top of the window with a list of all foreign keys for the current table. Clicking a foreign key will bring up a drop down list of all fields in the referenced table. Selecting a column (you can select as many as you want, across as many referenced tables as you want) will automatically generate JOINs under the hood and display the selected column right inline next to the fk column.
  • Fixed a major crashing bug that came about with OS X Java Update 4. Essentially, the application must be run in 32 bit mode.
REQUIREMENTS
Mac OS X 10.4 or later.

Bookmark and Share

SCREENSHOT

Developer:Thomas Mango
Downloads:8,909
  - Version d/l:606
Development:Editors
License:Free
Date:07 Aug 2009
Platform:PPC/Intel
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 ]