Preparing for the move - MySQL GUIs
With my purchase of an iBook looking imminent, I’ve started thinking about Mac equivalents for some of the software I use on a regular basis. There’s no problem as far as PHP is concerned, as Zend IDE is available for the Mac too, as are the usual suspects from Macromedia and Adobe. However for MySQL administration and development I use a nice, simple GUI front-end called SQLyog (free), but that’s not currently available for Mac.
After a bit of Googling, I got somewhat sidetracked by EMS MySQL Manager (free trial / $134) which, although only available on Windows, is a fantastic program, packed full of nice features and tools for MySQL development.
I did find Navicat (free trial / $95) which is available for Windows, Linux and Mac. Although not quite as feature-laden as EMS MySQL Manager, it’s not too far behind, and includes lots of similar tools (such as a visual query designer).
On the subject of applications, here are two free programs I recommend to anyone wanting to analyse their Apache logs offline rather than on the server.
Funnel Web Analyzer by Quest Software is available for Windows, Linux and Mac, and produces really comprehensive, attractive reports (and graphs) on just about every aspect of visitor activity. Also worth a look is Relax, a free log analysis tool for referrer information processing.
Very jealous about ibook purchase!
*glowers*
Well, we all deserve the odd treat every now and again. I’m sure if you try really hard you’ll find some way to justify the expense to yourself Hanni… ;-)