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.
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.
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.
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 !!!
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)
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.
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.
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.
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?"
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?
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.