MySQL WorkBench equivelant

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
alex.barylski
DevNet Evangelist
Posts: 6267
Joined: Tue Dec 21, 2004 5:00 pm
Location: Winnipeg

MySQL WorkBench equivelant

Post 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?
User avatar
Kieran Huggins
DevNet Master
Posts: 3635
Joined: Wed Dec 06, 2006 4:14 pm
Location: Toronto, Canada
Contact:

Re: MySQL WorkBench equivelant

Post 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.
User avatar
Eran
DevNet Master
Posts: 3549
Joined: Fri Jan 18, 2008 12:36 am
Location: Israel, ME

Re: MySQL WorkBench equivelant

Post by Eran »

Some people swear by MySQL navicat. Personally, I don't use those kind of programs
alex.barylski
DevNet Evangelist
Posts: 6267
Joined: Tue Dec 21, 2004 5:00 pm
Location: Winnipeg

Re: MySQL WorkBench equivelant

Post 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. :P

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. :P

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 :)
User avatar
Kieran Huggins
DevNet Master
Posts: 3635
Joined: Wed Dec 06, 2006 4:14 pm
Location: Toronto, Canada
Contact:

Re: MySQL WorkBench equivelant

Post 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!
alex.barylski
DevNet Evangelist
Posts: 6267
Joined: Tue Dec 21, 2004 5:00 pm
Location: Winnipeg

Re: MySQL WorkBench equivelant

Post 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. :P
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 :P 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. :P
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
User avatar
panic!
Forum Regular
Posts: 516
Joined: Mon Jul 31, 2006 7:59 am
Location: Brighton, UK

Re: MySQL WorkBench equivelant

Post 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.
Post Reply