The limitations of phpMyAdmin finally got the best of me. Imports and exports were always failing when there were foreign key constraints, the ugly interface was always annoying (and the only attractive theme is outdated), and the overhead of sending all that HTML back and forth was painful on slow connections.
I finally went ahead and hunted down a native OS X binary for doing work. I tried MySQL Workbench (Free), NaviCat MySQL Lite (Paid), Sequel Pro (Free), and another one whose name I’ve forgotten.
Sequel Pro was the awesome-est of all of them and is now my main MySQL client. It’s a native OS X client (e.g. not an open source linux project which was later ported to OS X). It’s got an attractive interface and does everything an administrator would need. I highly recommend giving it a try. My only feature wish is that it would support Postgres SQL (and maybe even SQLite), otherwise it’s perfect. It even supports the new Lion fullscreen functionality.
Sequel Pro Browse Table Screenshot
Hi, I’m Tom, and Renowned Media is my professional blog for web development tutorials. Traditionally, I’m a PHP/MySQL developer, but recently I’ve done a lot of JavaScript and Backbone.js development. Right now I’m really interested in Node.js and NoSQL technologies. I love developing on a mac and deploying apps to Linux servers.
Category: MySQL Tutorials • OS X Tutorials
real kickass devs only need cli mysql client.