I've been messing around with MySQL Query Browser.. Quite honestly it's a piece of shit. Actually kinda surprises me that MySQL even came up with the damn thing. I haven't been too impressed with MySQL/InnoDB lately either.. but.. yeah.. anyway. So I've been having problems with it and doing foreign key stuff properly. Sometimes it works, sometimes it doesn't. There's no easy way to set FOREIGN_KEY_CHECKS=0 in Query Browser and doing stuff via commandline is even more annoying sometimes.

So yesterday I tried something new.. Navicat. Claims to be the best GUI for MySQL on Windows, Mac and Linux... interesting that it's so cross platform. Apparently they have a version of it for Postgresql, but I think Postgresql's Admin GUI program is pretty damn good.

Anyway.. so far it's been a really cool program. Fixes my foreign key problems with no issues at all.. extremely intuitive user interface if you know what you're doing with SQL... it's pretty too.. and it's low resource consuming and extremely fast. It's not free though.. $75 for educational version.. yikes. But it's definitely worth a look.. free trial and everything.

if anyone knows about something free that's this good i would love to hear about it.