Page 1 of 1

phpMyAdmin

Posted: Tue Feb 22, 2011 8:32 am
by alex.barylski
It's old, antiquated and quite literally a horrible mess.

I have been using SQLYog for a few years now and while it's far from perfect its light years ahead of PMA. I have been thinking, perhaps it's time someone takes a stab at re-writing PMA using a more AJAX approach for a fully web-based solution, possibly offered in community/commercial licenses.

In general is there any interest by the developer community to participate/support such an endeavour?

Just curious :)

Cheers,
Alex

Re: phpMyAdmin

Posted: Tue Feb 22, 2011 8:46 am
by John Cartwright
I would be definitely be interested to see something developed, and probably use on a day-to-day basis, however, I have no time to spare.

Good idea for a project though.

Re: phpMyAdmin

Posted: Tue Feb 22, 2011 8:58 am
by alex.barylski
Cool, good to know and hear. :)

I am not sure I am looking to start a project, but I need an improved tool and SQLYog just doesn't cut it. Others are to 'enterprise' and a web-based project is just slick and handy to have accessible from any where such as your desktop or couch or at work.

Would it make sense to list features/requests in this thread (I have a few changes I'd make to SQLYog) or would starting a new thread in another forum be more appropriate?

Cheers,
Alex

Re: phpMyAdmin

Posted: Tue Feb 22, 2011 9:03 am
by John Cartwright
Would it make sense to list features/requests in this thread (I have a few changes I'd make to SQLYog) or would starting a new thread in another forum be more appropriate?
Here would be fine (for lack of a better forum), we can always move it is anything comes from this thread.

Re: phpMyAdmin

Posted: Tue Feb 22, 2011 9:04 am
by Eran
Aside from the actual code, phpMyAdmin works quite well. What are you going to change feature / UI wise?

Re: phpMyAdmin

Posted: Tue Feb 22, 2011 10:11 am
by alex.barylski
Aside from the actual code, phpMyAdmin works quite well. What are you going to change feature / UI wise?
What I "would" change (never agreed to re-writing it myself :P):

1. The interface is cludgy and old-school. Clearly built in the 1800's :p
2. It's slow, hard/impossible to modify and uses FRAMES which always caused me headaches
3. Last I heard/read (may be wrong) PMA wasn't being regularly maintained
4. Migrations support
5. Views/Stored Procs/Triggers/etc I don't think were supported when I last used PMA

There are literally a 100 things I would change about PMA to large of a list to compile on the fly while at work and doing something else :)

SqlYog is a vast improvement but has some draw backs. Enterprise is a step in the right direction but is not "sweet" enough for me to justify the price.

I frequently want to rename columns and re-order columns. UI than facilitated drag and drop would be stellar. Generating migrations would be a bonus as well. Schema print-outs, GUI designers, transactional support, etc.

I don't think PMA holds a candle to most desktop software other than it's web-based and MySQL being predominently used in a web environement I think many developers would prefer web based SQL manager.

Cheers,
Alex

Re: phpMyAdmin

Posted: Tue Feb 22, 2011 1:34 pm
by alex.barylski
Seems there have been many attempts to create AJAX replacements for PMA but none of which I have ever heard of until now. :(

I wonder the lack of success? Perhaps there all buggy, or perhaps PMA was first and captured a significant market share and now holds a monopoly. I seriously had no idea any of these alternatives existed some seem very specialized, almost like CMS.

Cheers,
Alex