Recommended reading

• How many lines of code does it take to create the Android OS? – Gubatron.com – Quite a nice way to show, in one table, how complex a project actually is. Wonder what the Objective-C is for? 😉
• Schema Sync › a MySQL Schema Versioning and Migration Utility – A nice commandline utility for versioning and migrating your schemas

I spent ages combing the web for a decent ERD tool for the Mac, and for some time resigned to using dbwrench, a java binary the provides decent but limited functionality and is free of charge.

The choice of tools for ERD work is much narrower than what’s available on Linux or the PC, where something like DBDesigner 4 is fantastic and can handle pretty much any job you throw at it.

Then finally I stumbled across SQLEditor and I have to say it’s excellent.  It has a sharp and clean GUI with the attention to detail you’d expect from a first rate Mac app.  However there is a price tag, $79, and after years of being able to depend on high quality apps that are available for free, I have to say paying such a price takes some getting used to.  In this case I think it’s totally worth it and would recommend this tool for any Mac-based software developer.

NB: As phpMyAdmin has collapsed in recent versions, you might also be looking for a decent MySQL client.  Here are some I’ve had a good experience with:

• Navicat Lite
• Sequel Pro

I’m always amazed to discover quite high profile sites letting goofy errors out in the open.

Quite a nice snippet from the php_london ML by Michael Stillwell

Site searches are really really bad. Even from organisations that should know how to do search. I really don’t understand why.

Try, e.g.

http://search.oracle.com/search/search?start=1&nodeid=&fid=&keyword=oracle+client+download&group=All

(Business Intelligence Beans Installation Guide and Release Notes as first result)

versus

http://www.google.com/search?q=site:oracle.com+oracle+client+download

Or

http://www.mysql.com/search/?q=query+browser+download&charset=&x=0&y=0
(Greek as first result)

versus

http://www.google.com/search?q=site:mysql.com+query+browser+download

Mentat Technologies , leaders in database administration software development. Today announced the new DreamCoder for MySQL Ver 4.2.

What’s new in DreamCoder for MySQL?

* Improved connection stability.
* Reestablish connection option .
* Improved SSH connections.
* Enhanced alias description.
* Improved Query Builder usability.
* Enhanced data compare.
* Several minor bugs are fixed.

You can learn more about DreamCoder for MySQL at:
http://www.sqldeveloper.net/mysql-manager-developer/dreamcoder-for-mysql.html

You can download DreamCoder for MySQL at:
http://www.sqldeveloper.net/download.html