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

#1 User is offline   Mike 

  • Elite Member
  • PipPipPipPipPip
  • Yii
  • Group: Members
  • Posts: 3,016
  • Joined: 06-October 08
  • Location:Upper Palatinate

Posted 07 November 2010 - 07:26 AM

For some years now i give MySQL workbench a try from time to time - and everytime i do, i'm very disappointed. This seems like the most unstable software i've ever seen. It's crashing so often, you hardly can't use it for anything. Unfortunatley its predecessor DbDesigner isn't developed any further (and also has bugs).

But as many users seem to be very satisfied i start to wonder wether it's just me. So what are your experiences with MySQL Workbench? (Multiple answer possible to separate usage frequency and stability)
0

#2 User is offline   jacmoe 

  • Elite Member
  • Yii
  • Group: Moderators
  • Posts: 2,601
  • Joined: 10-October 10
  • Location:Denmark

Posted 07 November 2010 - 08:47 AM

I tried it some years ago (IIRC) and wasn't impressed.

Then I started using it a month ago, and I'm very happy with it. :)

I am running Vista, btw.

I haven't experienced more than one single crash, and then a semi-crash in a dialogue (model synch), and all I had to do was clicking OK and then the program recovered.

I am sorry to hear that it's unusable for you.
Is it powered by Java ?
Maybe your installation is borked?

Could also be my use of it: I only import existing model from database, and then keep the two synched.
"Less noise - more signal"
0

#3 User is offline   diggy 

  • Standard Member
  • PipPip
  • Yii
  • Group: Members
  • Posts: 112
  • Joined: 18-November 09
  • Location:Ukraine, Khmelnitsky

Posted 07 November 2010 - 09:27 AM

I also tried and very dissapointed on every run.

For manage mysql I mostly use mysql console and for difficult queries I use phpMyAdmin.
0

#4 User is offline   jacmoe 

  • Elite Member
  • Yii
  • Group: Moderators
  • Posts: 2,601
  • Joined: 10-October 10
  • Location:Denmark

Posted 07 November 2010 - 09:32 AM

I am not using it to run queries or manage mySQL, so I wouldn't know if it sucks there.
It probably does.

What I do use it for is to design the schema and synch between database and model.
I really like that feature, thus is why I use it. ;)
I like to be able to design my database graphically, so I am using it as a modelling tool.
"Less noise - more signal"
0

#5 User is offline   Mike 

  • Elite Member
  • PipPipPipPipPip
  • Yii
  • Group: Members
  • Posts: 3,016
  • Joined: 06-October 08
  • Location:Upper Palatinate

Posted 07 November 2010 - 12:50 PM

View Postjacmoe, on 07 November 2010 - 09:32 AM, said:

What I do use it for is to design the schema and synch between database and model.


Yeah, that's basically all i want, too. But as soon as the model only gets slightly more complex (and only talking about 10 tables here) and i start to edit some detail properties e.g. the 'on delete' event of a foreign key relation and then double click the next table it crashes on about every second table i click. I've got used to save after each click, but that's of course a great PITA. :)
0

#6 User is offline   qiang 

  • Yii Project Lead
  • Yii
  • Group: Yii Dev Team
  • Posts: 5,900
  • Joined: 04-October 08
  • Location:DC, USA

Posted 07 November 2010 - 01:29 PM

I don't have experience with workbench. For my visual DB design needs, I mainly use Sybase PowerDesigner, which supports multiple DBMS.
0

#7 User is offline   jacmoe 

  • Elite Member
  • Yii
  • Group: Moderators
  • Posts: 2,601
  • Joined: 10-October 10
  • Location:Denmark

Posted 07 November 2010 - 02:07 PM

To be honest, most of my MySQL work happens in HeidiSQL.
I guess I just use workbench to get a graphical overview of my schema, and I keep it up to date.
It also means that I can generate a database from the schema if something goes wrong.
But HeidiSQL for my day-to-day database needs.
Yes, I am only using MySQL..
"Less noise - more signal"
0

#8 User is offline   Antonio Ramirez 

  • Elite Member
  • Yii
  • Group: Yii Dev Team
  • Posts: 1,450
  • Joined: 04-October 10

Posted 07 November 2010 - 03:25 PM

Had a try and wasn't impressed at all. For me, very troublesome to work with...

I am now working with Navicat for mySQL macosx version for administration tasks and SQLEditor for DB design and I am very, very happy with them.
¿How long would it take for you to understand that you own nothing in this world?

www.ramirezcobos.com
www.2amigos.us
www.github.com/tonydspaniard
www.github.com/2amigos


Posted Image
0

#9 User is offline   jacmoe 

  • Elite Member
  • Yii
  • Group: Moderators
  • Posts: 2,601
  • Joined: 10-October 10
  • Location:Denmark

Posted 24 November 2010 - 01:44 PM

Workbench is free and gratis.
So I make do.;)
Use Heidi SQL for most things, though.
"Less noise - more signal"
0

#10 User is offline   Mike 

  • Elite Member
  • PipPipPipPipPip
  • Yii
  • Group: Members
  • Posts: 3,016
  • Joined: 06-October 08
  • Location:Upper Palatinate

Posted 26 November 2010 - 08:40 AM

Tried Version 5.2.30 today. Looks like it's a fraction more stable. But still it feels like you are holding 10 raw eggs on your hands, while you try to work... :)

So if anyone knows about other free visual DB design tools, here's the place to share (AFAIK Sybase PowerDesigner unfortunately isn't).
0

#11 User is offline   Mike 

  • Elite Member
  • PipPipPipPipPip
  • Yii
  • Group: Members
  • Posts: 3,016
  • Joined: 06-October 08
  • Location:Upper Palatinate

Posted 19 February 2011 - 11:29 AM

To say the least: I'm very impressed by this here:

http://code.google.c...wwwsqldesigner/
Demo: http://ondras.zarovi...keyword=default

Purely browser/js based with a innovative layout. But still the UI is not perfect, IMO.
0

#12 User is offline   outrage 

  • Advanced Member
  • PipPipPip
  • Yii
  • Group: Members
  • Posts: 313
  • Joined: 10-November 09
  • Location:Blackpool, United Kingdom

Posted 20 February 2011 - 10:03 PM

I'm so surprised at anyone who finds this software unstable over the last few years.

Over the last 9 months it's even better than ever. It was once a real resource hog but they seem to have sorted that out now. I suppose on an old computer it may still be slow.

Fact is I've built many large and complicated relational db's over the last decade and I can honestly say, MySQL Workbench has been solid for at least the last 3 years. In recent times I've seen many new features implemented, you know, the stuff that was greyed out in the menus... and even more stuff they've added that I didn't expect.

The only times I've had a problem is in backwards compatibility with older '.mwb' files, but stability... no way.
I'm on Windows platform btw but used extensively across xp, vista and win 7.

EDIT:

Just looked over the replies and noticed some of you are speaking of Workbench as more of a db management software. Most of my experience with it has been in producing schemas and syncing with db.
For your usual db management, imports, exports, updates etc... I use Navicat, so friendly, although not without it's own bugs.

For schema design and syncing, workbench is the best.
0

#13 User is offline   Mike 

  • Elite Member
  • PipPipPipPipPip
  • Yii
  • Group: Members
  • Posts: 3,016
  • Joined: 06-October 08
  • Location:Upper Palatinate

Posted 21 February 2011 - 02:53 AM

Thanks for your feedback. Must be my PC then. Still i find it odd - no other software i use has such problems.
0

#14 User is offline   EdoFre 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 48
  • Joined: 24-February 11
  • Location:Groningen, The Netherlands

Posted 09 March 2011 - 05:54 AM

I've used it a bit a few weeks ago, was good at first but after a period of time the program started to slow down alot for me, dragging tables and entering fields was a painfully slow progress this way. ( on ubuntu 10.10 )
Moi,
0

#15 User is offline   synthetic 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 14
  • Joined: 15-December 08
  • Location:Francavilla-al-Mare, Italy

Posted 09 March 2011 - 07:01 AM

FYI, the Windows version of MySQLWorkbench works quite well (on XP at least), the Linux version is still alpha (thanks, Oracle!) and unusable - it's not included in most repos, unlike the GUI tools.

When MySQL was still owned by Sun, the statement was made that MySQL-WB would replace DBDesigner (a FabForce product that was the only free design tool at the time). MySQL-WB never made it out of alpha before Oracle ate up Sun. I've seen no real evidence of development activity since.

I periodically trawl the Net for possible alternatives, but to date I have not found anything that does what DBDesigner did...

EDIT: Apparently v 5.2.32 was released a few days ago (for all platforms, 32 and 64 bit). I'll be testing the Ubuntu 10.04 64bit over the next few days - will report results here.

Rgds,
Synthetic
0

#16 User is offline   Sisko 

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

Posted 09 March 2011 - 09:47 AM

I am using the rpm packages for opensuse 11.3 (64bit) and the MySQL workbench is running very stable. I can't remember a crash since I used it.
0

#17 User is offline   Mike 

  • Elite Member
  • PipPipPipPipPip
  • Yii
  • Group: Members
  • Posts: 3,016
  • Joined: 06-October 08
  • Location:Upper Palatinate

Posted 10 March 2011 - 02:26 AM

View Postsynthetic, on 09 March 2011 - 07:01 AM, said:

EDIT: Apparently v 5.2.32 was released a few days ago (for all platforms, 32 and 64 bit). I'll be testing the Ubuntu 10.04 64bit over the next few days - will report results here.


I tried on my Ubuntu box at home now too: It's the same. Frequent crashes, e.g. when i edit a table column then double click in the diagram to select another table. If i click too fast - crash...
0

#18 User is offline   nickcv 

  • Standard Member
  • PipPip
  • Yii
  • Group: Members
  • Posts: 154
  • Joined: 23-November 10

Posted 11 April 2011 - 06:01 PM

i see mostly windows solutions here.

on the mac i like using sequel pro for db management, supports well even ssh tunneling and the GUI is sleek (just like most mac sf btw)
Posted Image
Posted Image
Posted Image
Posted Image

i can manage users too, and most of all i don't have to pay a penny for it (although i made a donation)

it's extremely stable (never ever had a crash in two years).

the only thing i cannot do with it are ER diagrams, but i use a different software for that (sqlEditor that is not free, but the free trial never expires plus you get the sequel of almost every single sql dialect you want)
sometimes it's just like teaching pigs how to fly

Posted Image
Posted Image looking for some invite keys? welcome on B4K!
0

#19 User is offline   EdoFre 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 48
  • Joined: 24-February 11
  • Location:Groningen, The Netherlands

Posted 21 April 2011 - 03:01 AM

View Postnickcv, on 11 April 2011 - 06:01 PM, said:

i see mostly windows solutions here.
on the mac i like using sequel pro for db management, supports well even ssh tunneling and the GUI is sleek (just like most mac sf btw)


Yeah great program, I started using it a few days ago and works like a charm, It indeed lacks the functionality of creating relations with an ERD style view as MySQL workbench does. But then again if you draw it out yourself it's easy to add the relations in yourself.
Moi,
0

#20 User is offline   bglee 

  • Standard Member
  • PipPip
  • Yii
  • Group: Members
  • Posts: 152
  • Joined: 21-November 10
  • Location:Oak Park, IL

Posted 29 April 2011 - 03:57 PM

I used Erwin for database design for a number of years. Of course somebody else was paying for it at the time. :)
Power Architect Data Modeler (free version still around I think) isn't bad. A little quirky. I'm running it on Ubuntu.
It takes 2 points to draw a straight line, but at least 3 to draw a conclusion.
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