WordPress behind the scenes

18 September 2008 · 0 comments

One way to really take charge of the database behind the scenes of any WordPress blog is with software that interacts directly with it.

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.

Use phpMyAdmin to work with the WordPress database.

Use phpMyAdmin to work with the WordPress database.

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.

CocoaMySQL-SBG sees the database differently.

CocoaMySQL-SBG sees the database differently.

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.

 

Sequel Pro sees the database differently.

Sequel Pro sees the database differently.

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.

Be the first to comment ⇒

Tagged as: database, mysql

Tell us what you think.
Note: there may be a delay before your comment appears. I now approve all comments from new visitors, in an attempt to keep spam at bay.

Add your Comment

Older Post:

Newer Post: