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)
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.
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.
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.
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 )
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.
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)
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)
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.