Something Better Than phpMyAdmin
Moderator: General Moderators
Something Better Than phpMyAdmin
I have been using phpmyadmin for the past 6 years.
These last few days i tried some other mysql database management software such as SQLyog, navicat and heidisql, and wasn't convinced by them finally. I find the interfaces too complexe and not user friendly enough.
Maybe i am too used to phpMyAdmin...
So now i am wondering if anyone used any application that they feel is "better" than phpMyAdmin.
Do you know anything more user friendly than phpMyAdmin ?
Please avoid mentioning shell ;) ...
Thanks
JB
These last few days i tried some other mysql database management software such as SQLyog, navicat and heidisql, and wasn't convinced by them finally. I find the interfaces too complexe and not user friendly enough.
Maybe i am too used to phpMyAdmin...
So now i am wondering if anyone used any application that they feel is "better" than phpMyAdmin.
Do you know anything more user friendly than phpMyAdmin ?
Please avoid mentioning shell ;) ...
Thanks
JB
I still like it and use it.jmut wrote:I would second feyd on command line.
But what is that you lack as functionality in phpmyadmin. Why don't you like it no more?
I d like to find something where i store procedures, where i can a global view of my tables, something a bit more dynamic (ajax), i am open to desktop apps as well as it would simplify access to production servers (No more command lines
Just trying to find something with more functionalities... As i said i tried 3 desktop apps , and i think they are not very user friendly and messy...
Command line is all but user friendly. For example, take an intern guy in your office, show him phpmyadmin then tell him if he prefers to use mysql command line. In most cases the guy will use phpmyadmin... ( Looks like a debate on using "vi / emacs" or an IDE )
- CoderGoblin
- DevNet Resident
- Posts: 1425
- Joined: Tue Mar 16, 2004 10:03 am
- Location: Aachen, Germany
Ok but when you are in your office you can find better tools to work faster ?CoderGoblin wrote:Another one for the command line. Something to bear in mind is if you are ever at a client, you may not have access to anything but the command line. You should know how to do everything from it.
Do you wear army boots while sitting in your sofa
well working comand line is ways faster..that is for sure.jbflam wrote:Ok but when you are in your office you can find better tools to work faster ?CoderGoblin wrote:Another one for the command line. Something to bear in mind is if you are ever at a client, you may not have access to anything but the command line. You should know how to do everything from it.
Do you wear army boots while sitting in your sofa?
The thing is you should invest more time upfront to get used to it and see the benefits.
I know mysql support guys (I suppose all them do) who uses command line only. And it is not only that he does not hava phpmyadmin where client is, the main reason is that it is just faster.
P.S. Don't take this as do not look for a good tool
Let us know when you find the one.
- AKA Panama Jack
- Forum Regular
- Posts: 878
- Joined: Mon Nov 14, 2005 4:21 pm
Not hardly.jmut wrote: well working comand line is ways faster..that is for sure.
Some of the things I do with phpMyAdmin would be tedious and mind numbingly slow. One of the nice things about phpMyAdmin is you can select from the list view a number of totally disparate entries and change them all on one screen. It makes for some very, very fast editing.
If I had to resort to using the command line I would probably shoot myself in the head. The command line really isn't any faster. Especially if you have to make a bunch of changes to many different things. Plus the command line is more difficult to keep track of many different tables, databases and other data. With phpMyAdmin I can have a dozen different windows open on different databases, tables, etc and easily move data around between them.
Command Line = Doing trig calculations totally by hand.
phpMyAdmin = Doing trig calculations using a math calculator.
The purists like doing it by hand but the people who want to get the most work done use the calculator.
- dibyendrah
- Forum Contributor
- Posts: 491
- Joined: Wed Oct 19, 2005 5:14 am
- Location: Nepal
- Contact:
- CoderGoblin
- DevNet Resident
- Posts: 1425
- Joined: Tue Mar 16, 2004 10:03 am
- Location: Aachen, Germany
If my wife would let me yesjbflam wrote:Do you wear army boots while sitting in your sofa?
I admit phpMyAdmin and it's ilk do have some advantages when it comes to finding out information if you are unsure of your database structure and for other tasks, such as renaming tables, it seems to be quicker. I could argue though that if you rely on always having the database structure supplied to you graphically, you are less likely to learn it and profit from the speed increase that knowledge brings. If you have to look things up to write a request in PHP, it will be slower that if you had that knowledge in your head and could just type it.
We could discuss this "until the cows come home" and it doesn't really answer your question but here is a possible useful link (although I do not know the status of it - workbench at the moment is only Alpha at the time of writing), MySQL GUI Tools Downloads. When the workbench is stable and fully released I can see it being a very useful tool even outside MySQL.
- daedalus__
- DevNet Resident
- Posts: 1925
- Joined: Thu Feb 09, 2006 4:52 pm