Page 1 of 1
MySQL WorkBench equivelant
Posted: Fri Nov 28, 2008 5:09 pm
by alex.barylski
I downloaded mysql work bench OSS...had a go with it...and slightly disappointed...I recall the first version being much easier to use...
I'm not even sure I understand most of the functionality in that tool...more for DBA's I guess.
Anyways I'd like a Windows/Desktop alternative...phpMyAdmin is a PITA to use although it's what I'm confortable using I'd prefer a tool desktop tool. Suggestions?
Re: MySQL WorkBench equivelant
Posted: Sat Nov 29, 2008 5:58 am
by Kieran Huggins
My honest suggestion is to learn to love the command line client - it's not as difficult as it seems.. really!
Also, you'll be MUCH faster.
Re: MySQL WorkBench equivelant
Posted: Sat Nov 29, 2008 6:15 am
by Eran
Some people swear by MySQL navicat. Personally, I don't use those kind of programs
Re: MySQL WorkBench equivelant
Posted: Sat Nov 29, 2008 10:44 pm
by alex.barylski
My honest suggestion is to learn to love the command line client - it's not as difficult as it seems.. really!
Also, you'll be MUCH faster.
Whoa...theres a face I haven't seen in ages.
Anyways...dude...what? Much faster? Are you insane? I bet you 1000 bucks I can create 10 tables anf their properties faster than you can using phpMyAdmin than you using the CLI.
Seriously though....GUI is uaually much faster and when done right , equally flexible...it's whey most people use a GUI. I have used the CLI and in my experience it slows me down..then again I don't remember every little syntax as I am not a DBA but a application developer so I guess it depends on your specific domain.
Cheers

Re: MySQL WorkBench equivelant
Posted: Sun Nov 30, 2008 12:32 am
by Kieran Huggins
I find it faster... though I can see how other people may prefer gui clients... I guess this is starting to smell of the age-old Text Editor vs. IDE debate
Maybe it's just because I've grown accustomed to using the keyboard as much as possible. Much of that might be due to using Ubuntu on my laptop pretty much full time...
One thing I'll give the command line is that it forced me to learn SQL in a hurry! Looking up every little command (repeatedly) tends to have that effect on people

Also, I always found SQL gui's to be difficult to understand, but it's quite possible I was just never using the right ones!
Re: MySQL WorkBench equivelant
Posted: Sun Nov 30, 2008 1:03 am
by alex.barylski
I find it faster... though I can see how other people may prefer gui clients... I guess this is starting to smell of the age-old Text Editor vs. IDE debate
I suppose so...my only point is that GUI typically speeds things up by making things more abstract or higher level. For instance do you do everything from CLI or did you connect via Windows and use IE/FF/OP to post this message, which could in theor be done in CLI but would take ages, unless you did it every day and knew the protocols, etc off by heart and even then I bet I could beat that indivdual in a race to post a message.
Maybe it's just because I've grown accustomed to using the keyboard as much as possible. Much of that might be due to using Ubuntu on my laptop pretty much full time...
Ubuntu...ugh...don't even get me started

It's nice...but it still offers a GUI...
CLI is great I find when things need to be automated in which case piping/chainging commands togather works well...I have a far easier time setting up my Debian server using apt then I do configuring Windows exactly the way I like it...it's been three days so far setting up 3 machines...actually only two Windows machines...but I'm finally reaching the point of "ahhhhh" finally.
One thing I'll give the command line is that it forced me to learn SQL in a hurry! Looking up every little command (repeatedly) tends to have that effect on people Also, I always found SQL gui's to be difficult to understand, but it's quite possible I was just never using the right ones!
Hmmm...I would say the CLI would force you to become intimate with the lesser used SQL DDL as opposed to DML which developers are usually more accustomed with...but yes CLI forces you to learn the administration side of things...
I know idea Email systems were so complex until I started tinkering with Postfix on Debian.
Cheers,
Alex
Re: MySQL WorkBench equivelant
Posted: Mon Dec 01, 2008 5:54 pm
by panic!
For things like importing data, dumping tables/databases CLI wins hands down.
Creating tables, manually editing records is faster on GUI, though I wouldn't touch PhpMyAdmin out of choice, it is vile.