phpMyAdmin

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

Do you use PMA

Never
1
8%
Daily
4
31%
Weekly
3
23%
Monthly
0
No votes
On very rare occassions
5
38%
 
Total votes: 13

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

phpMyAdmin

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

I would like to ask for any web-based alternatives, as well as whether you use it as a developer or not.
User avatar
flying_circus
Forum Regular
Posts: 732
Joined: Wed Mar 05, 2008 10:23 pm
Location: Sunriver, OR

Re: phpMyAdmin

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

Re: phpMyAdmin

Post by alex.barylski »

I figured most will vote "yuck" :P

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
User avatar
Bill H
DevNet Resident
Posts: 1136
Joined: Sat Jun 01, 2002 10:16 am
Location: San Diego CA
Contact:

Re: phpMyAdmin

Post by Bill H »

I use it quite a lot and see nothing wrong with it. What is the objection that everyone is speaking of?
User avatar
onion2k
Jedi Mod
Posts: 5263
Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com

Re: phpMyAdmin

Post 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.
User avatar
Darhazer
DevNet Resident
Posts: 1011
Joined: Thu May 14, 2009 3:00 pm
Location: HellCity, Bulgaria

Re: phpMyAdmin

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

Re: phpMyAdmin

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

Re: phpMyAdmin

Post 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. :)
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: phpMyAdmin

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

Re: phpMyAdmin

Post 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.
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: phpMyAdmin

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

Re: phpMyAdmin

Post by alex.barylski »

LOL I guess so :)
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: phpMyAdmin

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

Re: phpMyAdmin

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

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