Best Database Management Tools

[shadowman123]

Well i was searching about the most Efficient Database management Programs

and i found that Topic


So what i Ask Actulay is 2 Questions :-

1 - Have any1 tried PhpMyAdmin ?

2 - Which one will you go for ?

[Korvacs]

Well that thread is 2 and a half years old and a completely retarded comparison as it depends entirely on what type of database you have.

For mysql i prefer phpmyadmin, for mssql i use microsofts sql management suite.

[bone-you]

MySQL,

I personally use the older, discontinued ones myself though.

Workbench is the successor to them, but I find the older ones to do exactly what I need to and with a cleaner interface.

[© Haydz]

Originally Posted by bone-you

I personally use the older, discontinued ones myself though.

Workbench is the successor to them, but I find the older ones to do exactly what I need to and with a cleaner interface.

+1 to that, I find that the old "MySQL Administrator" did the job perfectly, now the workbench application just feels like a mess.

[Kiyono]

I mostly use Navicat, it does what I want it to do and has a relatively simple interface. I use phpmyadmin every now and then just because I can. I tried to use MySQL GUI tools before but I simply didn't like it.

[Korvacs]

Workbench is just buggy and unreliable so keep well away from that, the older gui tools just seemed to take forever to execute large queries so i wouldnt suggest them either to be honest.

[tkblackbelt]

I also use MySQL workbench and never had any problems with it.

[bone-you]

GUI tools taking forever to execute a large query? A large query has nothing to do with the client. That'd be your server taking forever. I easily pull 20-100k rows regularly in mysql query browser. If it happens to be local, I'll get results within a second or two.

Workbench is fine when it comes to crossplatform though. When I happen to be on Linux I use it unless I can put WINE on Then I'll use query browser instead

[Korvacs]

Im not talking about a lookup, when using GUI/Workbench they just take forever to execute large inserts, updates, table creations, etc. On the same server phpmyadmin does this in a couple of seconds.

[bone-you]

Originally Posted by Korvacs

Im not talking about a lookup, when using GUI/Workbench they just take forever to execute large inserts, updates, table creations, etc. On the same server phpmyadmin does this in a couple of seconds.

I have never had that issue. I can restore an entire few hundred megabyte DB with hundreds of thousands of rows in over a hundred tables within seconds if the connection is local. Though ideally MySQL Administrator should be doing that action, and it does it even faster.

[Korvacs]

/shrug just my experience of them, would prefer not to have to have a webserver running with phpmyadmin installed just to administer a mysql database, but based on those experiences i feel i need to, of course since then ive moved the database to a webhost anyway so i dont need to worry about that, its running phpmyadmin for me anyway.

[Mr_Hitch]

iam using MySQL Community Server and its working fine for me

[Korvacs]

Thats a server, not management tools for a server...

[Spirited]

I use a few tools. Navicat is my editing tool. I use it to manage data in my tables because it's fast and easy.I sometimes edit the table structure using Navicat if it's a small change, but in general, I use Microsoft SQL Management Studio because of it's advanced options when creating a new table. Navicat just doesn't cut it sometimes, though it's great for small, quick changes or large imports from files. You should use what you're comfortable with. I use MsSql btw.

[Mr_Hitch]

ah yeah well am usign navicat its working fine for me