Page 1 of 1
phpMyAdmin
Posted: Fri Jan 01, 2010 9:23 pm
by alex.barylski
Seems this is all there is for basic MySQL DB management, sadly enough. The program is horribly done could be so improved in many ways. I'm thinking I could or would possibly spearhead a project to replace the agin phpMyAdmin.
I know many of my colleges in times past refused to use phpMyadmin in favor of SQLyog, or other DBA tool but web based is just so accessible.
I would like to ask for any web-based alternatives, as well as whether you use it as a developer or not.
Re: phpMyAdmin
Posted: Fri Jan 01, 2010 11:14 pm
by flying_circus
I only use it when I have to.
I develop everything on a local machine and use mysql gui tools to build the database. About the only thing I use phpMyAdmin for is a quick fix, or importing data that I have exported from gui tools. I chose rarely.
Re: phpMyAdmin
Posted: Fri Jan 01, 2010 11:58 pm
by alex.barylski
I figured most will vote "yuck"
It is quite nice to have though, while building a site I might focus on building the front end as quickly as possible and want to defer admin development panels for a later time, while still allowing a limited few to add content to the DB. In these cases phpMyAdmin would be awesome, if only it was a little more user friendly and not so ugly and more configurable, in terms of permissions, etc.
Something like a lite Access done in PHP would be superb !!!
Cheers,
Alex
Re: phpMyAdmin
Posted: Sun Jan 03, 2010 10:51 am
by Bill H
I use it quite a lot and see nothing wrong with it. What is the objection that everyone is speaking of?
Re: phpMyAdmin
Posted: Sun Jan 03, 2010 11:04 am
by onion2k
I use it all the time, but mostly just to execute my own SQL code. It's not actually very useful if you're using advanced SQL stuff like procedures.
Re: phpMyAdmin
Posted: Sun Jan 03, 2010 11:28 am
by Darhazer
When I need web-based tool, I'm using phpminiadmin.
The only case I'm using phpMyAdmin is when it is already installed and I have easy access to it. In all other cases I'm using phpminiadmin or desktop programs (usually MySQL Query Browser / MySQL Administrator, as they are available on both Windows and Linux)
Re: phpMyAdmin
Posted: Sun Jan 03, 2010 4:36 pm
by alex.barylski
I use it quite a lot and see nothing wrong with it. What is the objection that everyone is speaking of?
Extremely outdated interface...but I suppose if you come from the 'ain't broke don't fix it' mindset then it's fine. If you have ever used SQLYog or similar tool you will instantly develop a new hate-on for PMA
It's not actually very useful if you're using advanced SQL stuff like procedures.
Yup that would be nice
Cheers,
Alex
Re: phpMyAdmin
Posted: Sun Jan 03, 2010 4:41 pm
by alex.barylski
When I need web-based tool, I'm using phpminiadmin.
Sweet thanks for that. I'm amazed by the lack of projects though, yikes.

Re: phpMyAdmin
Posted: Sun Jan 03, 2010 6:06 pm
by califdon
I'm close to BillH's position, I think it's a reasonably useful tool for occasional use to take a look at a suspect record, build a simple table, run a plain SQL query, etc. Is it pretty? No, but that doesn't bother me. Would I turn users loose on it? Certainly not. Would I appreciate a really well-done FOSS replacement? Of course. Would I be likely to pay for a license? Probably not.
Re: phpMyAdmin
Posted: Sun Jan 03, 2010 7:12 pm
by alex.barylski
For a very basic tool it does the job, I suppose. SQLYog does things like DB migrations, etc. PMA also doesnt generate any diagrams to help one understand the schema, nor does it make printing very feasible.
Last time I tried to print 6 tables, each printed on a separate page which really discourages me from printing as it feels so excessive. I now manually save the HTML and drop the stupid page-break CSS and print that way but it would be nice if PMA had this option or printed as PDF or something.
Re: phpMyAdmin
Posted: Sun Jan 03, 2010 7:42 pm
by califdon
Since it's probably the most commonly provided tool on web hosting sites, and thus nearly always available, it comes down to the old joke about the guy who meets his friend on the street and asks "How's your wife?", to which he replies, "Compared to what?"
Re: phpMyAdmin
Posted: Sun Jan 03, 2010 8:51 pm
by alex.barylski
LOL I guess so

Re: phpMyAdmin
Posted: Sun Jan 03, 2010 8:57 pm
by Christopher
Perhaps you have not turned on some of the cool features in phpMyAdmin? See the manual, but there are some nice history and visualization tools. All you need to do is create a "phpmyadmin" database and turn them on in the config.
Rather than creating a whole new tool, you could see how they add extras and write what you think is needed?
Re: phpMyAdmin
Posted: Sun Jan 03, 2010 10:01 pm
by alex.barylski
Rather than creating a whole new tool, you could see how they add extras and write what you think is needed?
Cool I wasn't even aware of these extras.
As for writing what I thought was needed, PMA source code is incredibly complex, I think if I were to attempt anything like that I would rather start from scratch.
I was actually hoping/testing the waters for a possible community project, not a rebuild of PMA but something light weight and equally flexible. I barely have time myself to dedicate to such a project, and I assume most others on here are just as busy, pipe dreams.
Cheers,
Alex