What is your experience with MySQL workbench?
Posted 16 July 2011 - 03:38 AM
In combination with Gii I was able to rapidly set up my business classes.
However sometime workbench crashes (Windows 7, 64 Bit), thus saving often is recommended.
Workbench is not providing a real migration tool at the moment, but is planned in one of the next releases.
For a freeware software you get a good value.
Thank you guys for your comments on the other tools, will check them out, too.
Posted 19 July 2011 - 03:52 AM
I also tried Navicat but they do not have native Linux distribution, but Windows distribution that should be run via Vine, which is slow, crash from time to time.
So, far, I am using phpmyadmin and mysql cli client most of time.
Posted 27 July 2011 - 04:09 PM
Posted 02 August 2011 - 11:49 AM
Every data management util I have used hangs all the time on selects, data manipulation and their editors are just real crap to work with - PHPStorm even does much better job at editing SQL queries.
As a design and structure sync tool - good. DB and model sync has some issues, like it generates ALTER TABLE in some cases when there is no change at all, because it generates SQL statment in one order and MySQL shows on SHOW CREATE TABLE options in different order. And it generates drop and create foreign keys all the time for many tables in my DB - is that order issues or what - but I have to strip them out all the time. And it definetly fails on table creation order when foreign keys are involved.
Could be that I didn't set it up properly - didn't have time to dig in deeply.
Mixed feelings so, but does the job I need and is free. I do not know good enoght free tool like Workbench.
Posted 01 September 2011 - 04:11 PM
Posted 23 November 2011 - 12:17 PM
o It is slow; nothing wrong with my system (Windows XP SP3, 4GB RAM, loads of disk space, etc...), everything else runs fine.
o The GUI is not as customisable as it needs to be; simple things such as icon view and list / detail views for tables are missing.
o The layout is not intuitive at all; it looks like everything good that went before has been thrown away, and all the poor designs used.
o It does not seem to like remembering passwords; sorts of defeat the purpose of entering them in the first place!
I'm used to using MySQL Query Browser, and various other tools depending on the database of the moment, and Workbench is the poorest by far, in all departments.
--- rant over ---
Posted 04 February 2012 - 02:50 PM
Posted 19 February 2012 - 10:12 AM
Posted 23 April 2012 - 11:04 PM
I use sequel pro that was posted on the first page and is just as stable as workbench.
I just don't like that workbench involves lots of clicking to build a diagram from tables that already exists. Maybe, I don't have it configured to auto-generate or something
Overall, very happy with both of the products and that they are free!