Planetarion Forums

Mong · 11 Sep 2003, 11:27

Hi, the MySQL Control Center is pure pants, and PHPMyAdmin just isn't up to scratch. Now I'm fine using it, but I'm trying to get more of the MS people here to use MySQL. Their #1 complaint is that the dev environment is nowhere near as intuitive and powerful as that for MS-SQL.

To be honest, they're totally right

So does anybody use a decent graphical dev environment, that can compete with the MS offerings, or at least better than PHPMyAdmin?

Cheers,

M.

Dave · 11 Sep 2003, 16:26

I use windows.

I use PHPMyAdmin and its totaly satisfactory.

Structural Integrity · 11 Sep 2003, 16:30

Quote:

Originally posted by Dave
I use windows.

I use PHPMyAdmin and its totaly satisfactory.

I have nothing to add

NEWSBOT3 · 11 Sep 2003, 21:55

Quote:

Originally posted by Dave
I use windows.

I use PHPMyAdmin and its totaly satisfactory.

Mong · 11 Sep 2003, 23:10

Well you guys are obviously too easily pleased!

Today I've trialed two pieces of software, and both have noticeably ramped my productivity.

PHPMyAdmin is not a bad tool at all, but it has many annoying quirks - notably that if you get one thing wrong when creating a very large table, and it wipes all the work you already did on that table.

So no, you guys need to checkout some of the commercial tools available I'm afraid.

I do know what I'm on about, you know

M.

Goon · 12 Sep 2003, 05:09

Quote:

Originally posted by Mong
Well you guys are obviously too easily pleased!

Today I've trialed two pieces of software, and both have noticeably ramped my productivity.

PHPMyAdmin is not a bad tool at all, but it has many annoying quirks - notably that if you get one thing wrong when creating a very large table, and it wipes all the work you already did on that table.

So no, you guys need to checkout some of the commercial tools available I'm afraid.

I do know what I'm on about, you know

M.

Which tools do you reccommend? - I'm interesting in finding an alternative to phpMyAdmin as well, because it has annoyances.

Mong · 12 Sep 2003, 10:51

Quote:

Originally posted by Goon
Which tools do you reccommend? - I'm interesting in finding an alternative to phpMyAdmin as well, because it has annoyances.

Nice intuitive (usually) interface, reminds me a bit of Access or SQL Server:
http://ems-hitech.com/mymanager/

Interface a bit weird, but maybe a little more powerfull:
http://www.mysqlstudio.com/

M.

Goon · 12 Sep 2003, 13:29

ta, I will check them out.

wu_trax · 12 Sep 2003, 13:38

i used DBDesigner for creating my last database if thats the kind of thing you are looking for. (search on goolge, its freeware)

Atamur · 16 Sep 2003, 00:49

I type faster than I click. I find it quicker to type up CREATE TABLE sql statement in vim and paste it into mysql than I can do the same thing through myCC.

Raging.Retard · 17 Sep 2003, 02:58

Quote:

Originally posted by Atamur
I type faster than I click. I find it quicker to type up CREATE TABLE sql statement in vim and paste it into mysql than I can do the same thing through myCC.

But back in the real world thats just not done.

For the average person it is far quicker to type in a few column names and then select a type from a drop down than it is to type a CREATE TABLE statmentet, then an ALTER TABLE to add the keys and indexes, then another ALTER TABLE to add the constraints and default values. People dont care if you are l33t and can type tables in raw SQL, they care that if they are paying you 'x' you can get 'y' done in a reasonable time.

To be honest I generally disbelive people who claim they are quicker typing their create statements anyway. Its like people who claim its quicker to build complex websites in notepad over a more advanced editor.

Further more when looking at editing somebody eles's database, a GUI system often allows a far better view of the overall structure (eg via the use of relational diagrams), this becomes particularly important in larger DBs where the immediate function of everything is not clear.