Web GUI for database editing

dda has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: Web GUI for database editing by phaylon (Curate) on Oct 06, 2005 at 13:56 UTC
Sounds like you're in search for Scaffolding. You should be able to use every Framework that supports that. I for myself prefer Catalyst. There's also a Scaffolding Movie. hth, p Ordinary morality is for ordinary people. -- Aleister Crowley	[reply]
Re: Web GUI for database editing by pboin (Deacon) on Oct 06, 2005 at 14:02 UTC
I don't know what OS you're on, or which DB you intend to use, but there are (at least) two pre-rolled for linux. You need to provide a lot more detail -- it sounds like you want to re-invent some pretty well established wheels. www-sql "www-mysql is a web interface for the mySQL database. SQL commands can be embedded into web pages; these are executed on the server by www-mysql and the resulting web page sent to the browser. All SQL commands and queries supported by mySQL can be used via www-mysql." webmin-mysql "This module allows webmin (a web-based interface for system administration for Unix) to setup databases, tables, and permissions in your MySQL database server."	[reply]
Re: Web GUI for database editing by monkey_boy (Priest) on Oct 06, 2005 at 14:27 UTC
This is exactly what Maypole was designed for. This is not a Signature...	[reply] [d/l]
Re: Web GUI for database editing by davidrw (Prior) on Oct 06, 2005 at 14:41 UTC
as pboin pointed out, we have to guess as to your os/db .. i will add to his suggestions phpMyAdmin as a very good tool (written in php) for MySQL dbs (runs on windows or linux).	[reply]
Re: Web GUI for database editing by dda (Friar) on Oct 06, 2005 at 15:25 UTC
Well, sorry for the incomplete description. I'm under unix (linux), and database is Oracle. The GUI should be provide access to several predefined tables and fields, so standard tools like phpMyAdmin will not do the job. Drop-down lists should be provided for some field values, or checkboxes to boolean types. I will study suggested options tomorrow, many thanks for your help! Any other suggestions are welcome. --dda	[reply]


Pathologically Eclectic Rubbish Lister
	PerlMonks