Looking for the best MySQL IDE on the market

Posted At : March 28, 2008 2:35 PM | Posted By : Dan Wilson
Related Categories: Rapid Development

I've been doing a lot of work with MySQL lately. A lot more than I ever have. As a normal fan of open source software, I am pleased to have such a feature rich database at my disposal. I do have one small problem that bothers me, however...

The various IDEs I have tried are really far behind the mark. I do not feel as productive when working on MySQL as I do when working on MSSQL. Rarely do I heap praise on Microsoft, but man do they know how to design and deliver an IDE.

To start off with, I tried the MySQL administration tool. I found it very clunky and upsetting to work with. I then found SQLyog, which is a lot more refined, but isn't quite there yet. I like how fast the editor performs but there are still moments with SQLYog confuses me. Favorite past times we share include obfuscating the values of Bit Columns in the Table Data Tab and Randomly Deleting Views.

Thusly, I am on the lookout for a top quality MySQL database administration tool. If you know of something applicable that you like to use, please share it with me in comments below. I run both Windows and Mac computers so only products with solutions for both platforms will be considered.

Comments (20) | Print | Send | del.icio.us | Digg It! | Linking Blogs | 1092 Views
Comments
[Add Comment]
As of 6 months ago the best IDE for both MySQL and PostgreSQL was EMS SQL Manager.

http://sqlmanager.net

The free version is great. If you do any regular DB administration though the full version is worth the small expense.
# Posted By Scott Fitchet | 3/28/08 2:57 PM
I also like the EMS tools. Work great for me.
# Posted By joshua cyr | 3/28/08 3:03 PM
EMS is beyond kick-ass.
# Posted By david buhler | 3/28/08 3:26 PM
Navicat no questions asked.
# Posted By Raul Riera | 3/28/08 3:31 PM
Free: HeidiSQL http://www.heidisql.com/

I love it.
# Posted By Kevin Sargent | 3/28/08 3:52 PM
Navicat is pretty good
# Posted By Akeem | 3/28/08 3:53 PM
Toad for mysql is worth investigating
http://www.quest.com/toad-for-mysql/
# Posted By David Farr | 3/28/08 4:21 PM
Navicat is the best but it costs $$ that is not a one time license. Of the free apps, I've found HeidiSQL to be best.
# Posted By Jeff | 3/28/08 4:30 PM
You may look at Aqua Data Studio if you need it for Mac and Windows.
# Posted By Nathan Mische | 3/28/08 4:40 PM
Aqua Data Studio for both Win, Linux and Mac that can touch both MSSQL and MySQL (and others)

if you want MySQL specifc, Navicat is the best and runs Win and Mac.
# Posted By Eric | 3/28/08 4:57 PM
Yet another vote for Navicat. They recently began offering a free edition. Fewer features, but good enough for about 95% of your day to day work.
# Posted By Damon Gentry | 3/28/08 7:24 PM
add another for navicat.. well worth the $$
# Posted By dave | 3/28/08 7:55 PM
Having used most of them, and originally a navicat user, I can tell you, hands down, that NOTHING compares to SQLYOG for mySql work!!!

I am actually shocked that no one has mentioned it yet.
# Posted By Anthony Webb | 3/28/08 8:30 PM
I use Navicat at work and SQLYog at home.
They both have their strengths and weaknesses. I
I think SQLYog is better but neither of them
is at the level of Microsoft's IDE.
# Posted By Rick Mason | 3/28/08 11:42 PM
Navicat - not because it's a decent DB IDE but because it backs up InnoDB tables like nothing else. mysqldump stopped being reliable for us - that's when we tried Navicat and haven't looked back.
# Posted By Dave Ross | 3/29/08 2:25 AM
I use Navicat as well , it works pretty well, never had any problems and would definitely recommend it...
# Posted By Anuj Gakhar | 3/29/08 5:34 AM
I highly recommend Navicat. I use it for mac and windows and it works great and never any problems.
# Posted By Alfio Raymond | 3/29/08 3:10 PM
like Eric said Aqua Data Studio is pretty good if you're crossing over a lot.

I'll have to check out Navicat, haven't used it yet. Thanks for all the recommendations for it! I love new software!!
# Posted By Dana K | 3/31/08 9:54 AM
Hands-down, my favorite tool for building queries is Aquadata Studio. I like using one IDE for various database platforms. I also like that you can review all SQL code before it executes. I find that handy for building upgrade packages.
I use a second app for general MySQL admin work, DBTools Manager, but it's a .NET app so probably won't work for you.
# Posted By Terry Schmitt | 3/31/08 11:27 AM
Dan,

Curious what you have tried and like - also wondering if any of these have an Eclipse perspective.

Thanks
# Posted By Dan O'Keefe | 4/23/08 8:00 AM
[Add Comment]
BlogCFC was created by Raymond Camden. This blog is running version 5.9.001. Contact Blog Owner