Yii Framework Forum: What is your experience with MySQL workbench? - Yii Framework Forum

Jump to content

  • (3 Pages)
  • +
  • 1
  • 2
  • 3
  • You cannot start a new topic
  • You cannot reply to this topic

What is your experience with MySQL workbench? Rate Topic: -----

Poll: MySQL Workbench (118 member(s) have cast votes)

What are your experiences with MySQL Workbench? (multiple answers possible)

  1. Never tried it (11 votes [6.92%] - View)

    Percentage of vote: 6.92%

  2. Will try it soon (5 votes [3.14%] - View)

    Percentage of vote: 3.14%

  3. Tried but discarded it (15 votes [9.43%] - View)

    Percentage of vote: 9.43%

  4. Use it rarely (19 votes [11.95%] - View)

    Percentage of vote: 11.95%

  5. Use it always (31 votes [19.50%] - View)

    Percentage of vote: 19.50%

  6. It's running stable (19 votes [11.95%] - View)

    Percentage of vote: 11.95%

  7. It's mostly stable with rare crashes (29 votes [18.24%] - View)

    Percentage of vote: 18.24%

  8. It's crashing frequently (20 votes [12.58%] - View)

    Percentage of vote: 12.58%

  9. It's unusable (10 votes [6.29%] - View)

    Percentage of vote: 6.29%

Vote Guests cannot vote

#21 User is offline   Sebastian K. 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 65
  • Joined: 29-May 11

Posted 16 July 2011 - 03:38 AM

I am currently playing around with the latest version and like MySql Workbench. It is a great tool to quickly set up a new schema, manage relations and updating the underlying database.
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.
0

#22 User is offline   Ivica 

  • Advanced Member
  • PipPipPip
  • Yii
  • Group: Members
  • Posts: 317
  • Joined: 25-May 11

Posted 19 July 2011 - 03:52 AM

Well, first I had so much trouble to install it on Debian Squeze 64bit, and once I installed it I am disappointed.

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.
Zurmo: Yii Powered Open Source CRM
zurmo.org
0

#23 User is offline   Da:Sourcerer 

  • Elite Member
  • PipPipPipPipPip
  • Yii
  • Group: Members
  • Posts: 1,222
  • Joined: 30-March 11
  • Location:Berlin, Germany

Posted 27 July 2011 - 04:09 PM

I am constantly using MySQL WB on Fedora, (K)Ubuntu and Windows 7. I am under the impression it tends to crash on Ubuntu more likely. Especially when synchronizing models with existing databases and/or scripts. Apart from that: Absolutely love it for designing purposes.
programmer /ˈprəʊgramə/, noun: a device that converts ►coffee into ►code
0

#24 User is offline   Psih 

  • Standard Member
  • PipPip
  • Yii
  • Group: Members
  • Posts: 114
  • Joined: 30-June 10

Posted 02 August 2011 - 11:49 AM

Using it for building databases in graphical representation - works quite fine. Some times it can crash, but mostly does work. Kind'a slow on UI responce and can definetly be faster, but I'm not using it for data management at all - console is my best friend.
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.
0

#25 User is offline   chanh 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 86
  • Joined: 09-March 09
  • Location:Seattle

Posted 02 August 2011 - 02:28 PM

it is getting better but I don't know why they don't allowed the database rename in workbench.
http://ongetc.com (COAddOns for Mambo, Joomla, MiaCMS & forks and HowTo)
http://mosecms.tk (Mose framework & CMS)
0

#26 User is offline   GSTAR 

  • Master Member
  • PipPipPipPip
  • Yii
  • Group: Members
  • Posts: 1,035
  • Joined: 30-October 09
  • Location:UK

Posted 01 September 2011 - 04:11 PM

MySQL Workbench is rubbish, it takes ages to do something very simple. I still use MySQL Query Browser, which lets me do what I need to do, though it can be a bit annoying. All they had to do is update MySQL Query Browser but instead they've discontinued it and bought out the pile of crap that is MySQL Workbench.
0

#27 User is offline   BornToDrink 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 46
  • Joined: 31-December 09
  • Location:Bulgaria

Posted 13 September 2011 - 03:32 AM

I found MySQL WB not user friendly and not very stable at all.
It's good for free IDE, but I tried SqlYog and it's much better, but it cost money.
Anyway, there is 30-day trial version, if someone is interested.
0

#28 User is offline   yagoozle 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 3
  • Joined: 16-October 11

Posted 16 October 2011 - 07:17 PM

I used to use MySQL Query Browser but then that got discontinued. It's a real shame, too, because I found it far surperior to MySQL workbench.
0

#29 User is offline   marco@sms 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 30
  • Joined: 08-August 11
  • Location:Hamburg, Germany

Posted 26 October 2011 - 02:01 AM

I tried to build an application with it, but I found out that I am quicker setting up database structures using phpmyadmin
0

#30 User is offline   Techie42 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 17
  • Joined: 16-November 10
  • Location:Berkshire, UK

Posted 23 November 2011 - 12:17 PM

Workbench is annoying as hell:

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 ---
0

#31 User is offline   mmx 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 64
  • Joined: 20-June 11
  • Location:Virginia Beach, VA USA

Posted 04 February 2012 - 02:50 PM

View Postjacmoe, on 07 November 2010 - 08:47 AM, said:


Is it powered by Java ?

At least Python partly in external components. Earlier versions including its DbDesigner predecessor were written in C++ and I think this is still the case.
0

#32 User is offline   yugene 

  • Advanced Member
  • PipPipPip
  • Yii
  • Group: Members
  • Posts: 513
  • Joined: 08-August 09

Posted 19 February 2012 - 10:12 AM

Hm, I'm using mysql workbench on Opensuse 11.4 (version 5.2.31), mostly for db scheme creation, and it works just fine. I'm surprised to see so many disappointed people here :).

Quote

but I don't know why they don't allowed the database rename in workbench.
- Just use "Edit scheme" section (right click on scheme tab-name)
0

#33 User is offline   dotangelo 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 17
  • Joined: 06-April 10

Posted 28 February 2012 - 02:34 PM

I've been recently working on some complex EER diagrams in MySQL WB, and it showed up, that they export to MySQL just fine. You'll get used to GUI very quickly.
"Because some things, just need to be improved."
0

#34 User is offline   Sisko 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 54
  • Joined: 27-September 10

Posted 21 March 2012 - 06:48 AM

Since I am using eclipse, I switched to rmbench. A really nice tool. But I did not test the synchronize functionality.
0

#35 User is offline   SapporoGuy 

  • Standard Member
  • PipPip
  • Yii
  • Group: Members
  • Posts: 177
  • Joined: 25-December 10
  • Location:Sappor Beer Refinery

Posted 23 April 2012 - 11:04 PM

Use workbench on OSX for the diagrams only. Pretty stable and only has problems if I put my machine to sleep and the connection to MySQL goes dead. Other than that it's been stable.

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!
0

#36 User is offline   eMontano 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 10
  • Joined: 28-March 12

Posted 27 April 2012 - 08:26 PM

I use Sybase Powerdesigner and Navicat Lite for Mysql.
0

#37 User is offline   waterloomatt 

  • Advanced Member
  • PipPipPip
  • Yii
  • Group: Members
  • Posts: 545
  • Joined: 09-April 10

Posted 08 May 2012 - 08:11 AM

http://www.chive-project.com/ - and it's built in YII.
0

#38 User is offline   SapporoGuy 

  • Standard Member
  • PipPip
  • Yii
  • Group: Members
  • Posts: 177
  • Joined: 25-December 10
  • Location:Sappor Beer Refinery

Posted 12 May 2012 - 07:55 AM

Will have to check out from my pc.
The grass and social buttons block everything on my iPhone. Very irratating to try to get around those!
0

#39 User is offline   ekerazha 

  • Advanced Member
  • PipPipPip
  • Yii
  • Group: Members
  • Posts: 525
  • Joined: 10-October 08
  • Location:European Union

Posted 13 May 2012 - 05:42 AM

I use MySQL Workbench since the first 5.2.x release, I like it, no major issues on a Windows 7 x64 laptop (Core i5 Sandy Bridge, 4 GB of RAM, Intel SSD).
Yii user #37
0

#40 User is offline   andrew1 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 15
  • Joined: 09-May 12

Posted 14 May 2012 - 09:09 PM

Started using workbench in past few days on mac, no issues so far
0

Share this topic:


  • (3 Pages)
  • +
  • 1
  • 2
  • 3
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users