If you use WordPress installed on your own server, sometimes the most efficient way to achieve a task is to go direct to the MySQL database. Of course you can use phpMyAdmin from your website’s Control Panel, but that can be slow and clunky too.
No, one way to really take charge of the database behind the scenes of any WordPress blog is with software that interacts directly with it. Maria and I explained how in Chapter 10 of our book WordPress 2 Visual Quickstart Guide.
Until now I’ve been using CocoaMySQL-SBG, but it’s had a few glitches. Hooray for Sequel Pro — a MySQL database management app for Mac OS X:
It started as a fork of the abandoned CocoaMySQL project, and has grown into a great looking Mac OS X database management app.
Sequel Pro looks very promising. It’s current, it’s
under active development, and it remembers my login details for the half dozen blogs I manage.
Take a look at it, and see if you can even contribute to its further development. And thanks to the Project Owners abhibeckert, mattlangtree and avenjamin, for moving this excellent tool forward.