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

Greetings Monks

I'm looking for a CGI for editing database tables.

I just got done writing a perl script for editing a rather complicated table and I found myself pushing more and more code into general purpose things when it occurred to me -- this must have been done before! So I looked. I want a generic interface to database tables that will generate interfaces where my users can add, edit and delete rows. Lo and behold, in 2002 someone wrote the very excellent A generic CGI script for database editing, but alas it is a generic interface to MySQL tables. I need oracle. So I am translating it to oracle.

Is there a better way?

Replies are listed 'Best First'.
Re: generic CGI table editing?
by NetWallah (Canon) on Dec 15, 2007 at 06:16 UTC
    I have been looking for such a beast myself, having been former fan of GenericDB, which is now way obsolete.

    The most discussed and flexible option seems to be using PHP , called DADABIK.

    I'm sure other monks here will direct you toward a more perly MVC solution, like Catalyst, which is probably overkill for simple apps.

         "As you get older three things happen. The first is your memory goes, and I can't remember the other two... " - Sir Norman Wisdom

[reply]
Re: generic CGI table editing?
by shmem (Chancellor) on Dec 15, 2007 at 09:21 UTC
    Have a look at Gantry.

    --shmem 

    _($_=" "x(1<<5)."?\n".q·/)Oo.  G°\        /
                              /\_¯/(q    /
----------------------------  \__(m.====·.(_("always off the crowd"))."·
");sub _{s./.($e="'Itrs `mnsgdq Gdbj O`qkdq")=~y/"-y/#-z/;$e.e && print}
[reply]
Re: generic CGI table editing?
by NetWallah (Canon) on Dec 15, 2007 at 23:36 UTC
    I had forgotten about this piece of code I wrote - it gets you visibility of a table on the web.

    All parameters are at the top.

    Read more... (10 kB)

         "As you get older three things happen. The first is your memory goes, and I can't remember the other two... " - Sir Norman Wisdom

[reply]
[d/l]
Re: generic CGI table editing?
by zby (Vicar) on Dec 16, 2007 at 10:41 UTC
[reply]

Back to Seekers of Perl Wisdom