All of my plugins should now be WordPress 2.8 compatible. For the majority of them the only issues involved were based on the use of the WordPress SQL escaping function. Previously I was calling this statically:
wpdb::escape
A bad habit I probably picked up from somewhere back in the WordPress 1.5 days that has stuck around. In WordPress 2.8 this function no longer works statically. The simple fix is to change it into:
$wpdb->escape
Back in 2007 I wrote about CocoaMySQL, a small GUI for MySQL that allows you to manipulate and manage MySQL databases through a native Cocoa application. Since then development of CocoaMySQL died off and it has since been abandoned. A shame really as it did have several frustrating quirks that spoiled an otherwise great application.
Recently I came across Sequel Pro, a fork of CocoaMySQL that has big plans to stabilise the core code and turn it into a multi-engine database management tool (with support for SQLite and PostgresSQL scheduled for the future). Despite being available since early 2008 I’ve seen very little mention of Sequel Pro.
In terms of functionality Sequel Pro seems to be an almost exact match for CocoaMySQL, only with a smarter interface and less annoying quirks. The account management is still inconsistent, and lengthy operations still lock the interface up, but otherwise it’s a good step in the right direction and has already replaced CocoaMySQL as my SQL tool of choice.
Theme: Guangzhou