Since getting out of the database business a few years ago,
I haven't had to sully myself with things like foreign keys or even SQL for a while. But now that it looks like I'll be
building a site using MySQL and PHP, it's back to the db again. Luckily, developer Thomas Mango sent in a tip about his
PGnJ app. It's written in Java, and serves as a database manager for
PostgreSQL and MySQL databases. Even better, everything is in one unified interface, with tables, fields, and data all
in one place. This is also one of the only tools I know of for this job, in OS X, that'll do it for free. Thanks
Thomas!
Tags: database, freeware, mysql, postgresql, sql, tuaw
Suspected PayPal Hackers Seek Deal To Stay Out Of Prison
Scripps Employees Called 'Hackers' For Exposing Massive Security Flaw
Comments
5
Subscribe to commentsJonathan HarfordApr 6th 2006 1:21PM
Java... and yet not cross-platform?
Come on!
metric152Apr 6th 2006 2:27PM
There is another program called YourSQL that's free for OSX.
http://yoursql.ludit.it/index.html
I tried using it for awhile, but found it lacking in features. The above program sounds ok, but it looks like you can't create tables or indexes. I purchased Navicat for OSX because it does everything phpMyAdmin does in a app. I was really tired of switching browser windows all the time. It retails for $99, but if you're a student it's $75. Very worth the purchase.
http://navicat.com/
Thomas MangoApr 6th 2006 3:02PM
Jonathan,
Actually PGnJ is cross platform, I just haven't posted an executable .jar file yet. There are so many great database management applications for Windows that I figured most people already have what they are looking for on that front. I will post one in a few days though, just have to work out some packaging kinks with the included jdbc drivers and icons.
Thomas MangoApr 6th 2006 3:10PM
metric152,
You are correct, there is currently no wizard to help in creating a table or index in PGnJ. Keep in mind, though, that PGnJ is still in its very early stages of development. I have plans to add wizards for creating various database objects at some point, but I have opted to push those into future releases, rather than include them in these earlier builds because you can still create a table or index by just running a SQL statement.
Please feel free to send me all feedback and feature requests. All comments contributed by users will help make PGnJ a very powerful, free database management application! There are options in the help menu to send feedback and request features. Thanks for checking it out!
Jonathan HarfordApr 6th 2006 4:45PM
Mr. Mango, you are a "class act".