My co-worker sent me a link to a new MySQL database administrator app call Sequel Pro. It’s free for Mac OS X. I’ve been using it for about two weeks now and it has now replaced phpMyAdmin and MySQL Query Browser as my primary database application. It is a native OS X app. It’s so easy to use, very fast and the interface is great.
I’ve used the MySQL tools for about a year now and find them to be slow and buggy. This is likely due to them being written in Java.
phpMyAdmin has been a great companion for many years but depending on your hosting provider, it can take 5+ clicks to get to their version of phpMyAdmin for your website. The interface is outdated and the ease of use just isn’t there anymore.
The only downside of Sequel Pro which is the same as the MySQL tools is that you need to have external connections open to your database which is a possible security hole. (Update: See Sequel Pro Docs about creating an SSH tunnel so you don’t have to open up external connections to your database. Thanks Bruno.)
For any other Mac web developers out there give Sequel Pro a look.
[carousel keywords=”mysql” category=”Books” tag=”damnsemi01-20″ showBorder=”True”]