Followup on Managing MySQL on Mac OS X
by Robert Daeley
A couple of weeks ago, my article Managing MySQL on Mac OS X was published, detailing some of the best Mac options for interacting with the popular database management system. There were some good tidbits in the comments of that article that I'd like to pull out as a followup.
In the article, I mentioned CocoaMySQL having problems with newer installs of MySQL and the project having been forked to fix the problem. 'PhilipTrauring' pointed out the forked version is available at www.theonline.org/cocoamysql/. As that page points out, however:
It works for me and a few of my coworkers. That said we are all running 10.4.2 and connecting to MySQL server(s) running various patch levels of 4.0 and 4.1. So it may or may not work for you. I don't have time to test everything in all combinations, I know it works for me and we find my changes useful. Perhaps some others will as well.
Next, 'malcolmrigg' revealed that the official MySQL Query Browser application is now available for Mac OS X.
Reader 'Paul_Furbacher' likes Minq's dbVis free edition, which is upgradeable for more features for $99.
Responding to 'brocklee''s question regarding a comporable list for PostgreSQL, 'Vanish' pointed to phpPGAdmin, Aqua Data Studio (which will also work with MySQL), dbVis, and PostAdmin (which I couldn't track down after a cursory search). There's also the Java-based SQL4X Manager J which might be worth looking into, though I've not tried it out.
And finally, 'leeg' was good enough to point out an issue with my MAMP acronym:
I think you mean DAMP - Darwin, Apache, MySQL, Perl. The 'WebObjects' is silent :-)With which I must agree, especially since DAMP fits better with MySQL's dolphin logo. :)
I'm partial to Mac OS X / Apache / Rails / SQLite ...
Even more MySQL develper tools...
In addition to the excellent MySQL clients already mentioned, there is also our SQL development tool, SQLGrinder (http://www.sqlgrinder.com) which uses JDBC to connect to MySQL, as well as to pretty much any database that you have a JDBC driver for.