About Dan Wilson
Dan Wilson
Dan Wilson
Model-Glue:Gesture for Fun and Profit
Watch Video
Presentation Files
DataCurl LLC, My Company
2010 Speaking Engagements
Video Interviews
DZone Articles
Looking for the best MySQL IDE on the market
Posted By : Dan Wilson
March 28, 2008 2:35 PM
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.
There are no comments for this entry.
Add Comment
Subscribe to Comments
I also like the EMS tools. Work great for me.
EMS is beyond kick-ass.
Navicat no questions asked.
Free: HeidiSQL http://www.heidisql.com/
I love it.
Toad for mysql is worth investigating
http://www.quest.com/toad-for-mysql/
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.
You may look at Aqua Data Studio if you need it for Mac and Windows.
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.
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.
add another for navicat.. well worth the $$
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.
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.
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.
I use Navicat as well , it works pretty well, never had any problems and would definitely recommend it...
I highly recommend Navicat. I use it for mac and windows and it works great and never any problems.
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!!
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.
Dan,
Curious what you have tried and like - also wondering if any of these have an Eclipse perspective.
Thanks
Hey guys, sqlyog runs fairly well with all Windows version (98SE to Vista) and also on Linux with WINE and is worth. You know one thing sqlyog offers fantastic free community edition but navicat does not. then why navicat? Even its too fast when compared to old versions and stable also. i am finding best out of it. Just try once and get the difference.
thumbs up for HeidiSql
Not so far I have found new cool tool to work with mySQL - Valentina Studio. Its free edition can do things more than many commercial tools!!
I very recommend check it. http://www.valentina-db.com/en/valentina-studio-ov...
dbForge Studio is the best as for me: https://www.devart.com/dbforge/mysql/studio/
Suscribe
Follow Us
Contact
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.