SimpleMyAdmin (MySQL Database Management)

[RainCT]

Hi,

I'm working on SimpleMyAdmin, an Open Source script that aims to provide a lightweight, fast and user-friendly MySQL database management script, as an alternative to phpMyAdmin for the most (not to much advanced) projects. It's being developed with PHP and makes use of Ajax for a better user experience.

Okay, enough with good words :P. I'm opening this discussion to ask you what you would like it to have, what you don't like from phpMyAdmin, how to make it easy for users that are new to MySQL, and any other thought you have. Also please say if you will consider using it.

There is no release yet and the website has not much content at moment but you can see it at simplemyadmin.sf.net.

Thanks

[Motoma]

I would really like to see the ability for both users and administrators to customize a user's interface in the system. For instance, a user could select perhaps a "simple interface" and an administrator could set this as the default for all users, unless a user specifically sets the "advanced interface."

[RainCT]

Whatever the administrator wants. This should be both automatically tailored by the permissions of the user, as well as by the user's preferences.

[devsusen]

I mostly use phpMyAdmin though some cases I need to access it via command line using SSH.
phpMyAdmin is really good to use for the beginner or experts. I really like its features. The only thing I dislike little bit is that its first download time and consumption of bandwidth. I know this is because it downloads lots of javascripts for further use at first time. After that the speed is quite good.

susen

[daveiro]

Please include support to updatable views.

Since MySQL has updatable views, one can use them to facilitate data insertion while keeping a well organized DB schema below. Up to now I only found phpMyAdmin as the only MySQL frontend which allows possibility of editing data in views and then automatically updating the relevant table.

It's only possible to update one underlying table at at time, but this is more than enough for a lot of useful scenarios of information editing/adding.

Regards,
David

[RainCT]

Please include support to updatable views.

Since MySQL has updatable views, one can use them to facilitate data insertion while keeping a well organized DB schema below. Up to now I only found phpMyAdmin as the only MySQL frontend which allows possibility of editing data in views and then automatically updating the relevant table.

Thanks for your feedback, David.

Excuse my ignorance but can you explain what "updatable views" are? Thanks!

[RainCT]

Well I just created an IRC channel for it:

Channel: #simplemyadmin
Server: irc.freenode.net

I will be many hours a day there, would be great if you enter there to tell me your thoughts, or just post them here if I'm not online when you enter (or you don't want to enter) :).

All feedback is welcome!