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.
February 9th, 2010 at 23:17
navicat is a piece of shit! mysql browser and the new workbench are absolute rubbish!
i’m looking into aquafold but it’s not free, well navicat isn’t free and it’s a POS too.. the interface is totally clunky… windows 3.1 clunky!
do not pay for navicat you are doing yourself a big dis-service… get something else like i dunno, maybe razor sql or aquafold, havent tried them but their interfaces look much better
June 19th, 2010 at 03:59
Yep, MySQL Workbench, what a load of fuking crap, the original query tool and admin front ends were simple and worked, but this rubbish crashes, and you need to import DB before you can do anything, and once imported, you say new to open the query tools and removes you downloaded snap shot, and for fuck sake, my brother lost his whole database with it.
Well alternatives, not many good ones around, but I find Toad is a better interface that that piece of Oracle shit. and its free for mysql.
May 18th, 2011 at 14:41
Just found HeidiSQL and looks as a nice replacement for the good old tools. A bit heavier than Querybrowser, but still lighter than the rubbish MySQL Workbench.