User interface to mysql database?

[fos]

I would like to develop a form based interface to a mysql database. I'm comfortable with the command line interface but I would like to write something that would be easy for a non-programming user to use to update and access the data.

Do any of you have experience in this field?

Thank you,
fos....

[danieldk]

Sounds like phpmyadmin:
http://www.phpmyadmin.net/home_page/index.php

Though, nothing comes close to pgadmin3 (at least, for my use):
http://www.pgadmin.org/

[fos]

Thanks for the link to pgadmin. It looks very interesting.

Don't ask why, but I prefer mysql for no particular reason.

I am looking for something self contained that doesn't rely on a web server running, a stand along application that only requires an operating database server. As usual, I would like something quick and easy! :)

fos....

[danieldk]

Posgres scales far better, doesn't have licensing problems (MySQL is dual-licensed), and is generally more modern (OO (inheritance et al), good support for triggers, etc.). Though most web hosters offer MySQL.

For stand-alone use PostgreSQL on the server and pgadmin3 on the client works great. I use it for $WORK.

[fos]

I tried it years ago while it was still maintained by a university group. I believe it was the first open source database server. It is time for another look.

fos

[fos]

I keep getting back to TCL/TK. Are there any drawbacks considering newer development systems such as gtk or qt?

fos....

[danieldk]

I keep getting back to TCL/TK. Are there any drawbacks considering newer development systems such as gtk or qt?

fos....

It does not really fit in when it comes to look and feel. I don't know TK too well, but GTK and Qt are modern object-oriented (or faked object-oriented :)) APIs, that can easily integrate with other components. Besides they have far better font and graphics handling. E.g. GTK2 + Pango + Cairo is beautiful.