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

Hello Monks,

I need a module (or a bundle) for customizable database table(s) presentation via CGI script. It is a need to browse database table page by page, and edit records. Is there any piece of code that may help? I have searched CPAN and found only DBIx::CGI and DBIx::CGITables, but they do not provide necessary features. I'd like it to be template-based if possible, but it is not a must, of course.

Thanks.

--dda

  • Comment on Module for viewing/editing database table (DBI, CGI)?

Replies are listed 'Best First'.
Re: Module for viewing/editing database table (DBI, CGI)?
by strat (Canon) on Jul 18, 2002 at 11:03 UTC
    Although it is not written in Perl (but in PHP), maybe PhpMyAdmin might be interesting for you.

    Best regards,
    perl -e "s>>*F>e=>y)\*martinF)stronat)=>print,print v8.8.8.32.11.32"

[reply]
      I would liken Gossamer's MySQLMan (Free, Perl) to PhpMyAdmin. In fact, the info page says that it was based on PhpMyAdmin. I've used it on many occasions, without incident.
[reply]
        LTjake, thanks for the link! It is interesting stuff indeed!

        --dda

[reply]
      Thanks. I saw it in action, it is really nice. But I want a perl solution :)

      --dda

[reply]
      Or you can use MySQLTool which is a perl module/cgi script. I I believe that PhpMyAdmin is based on this. I may be wrong but its an Easy and good tool to use.
[reply]
Re: Module for viewing/editing database table (DBI, CGI)?
by anolte (Novice) on Jul 18, 2002 at 19:20 UTC
    The most advanced web environment with DB access that I know of ist OpenInteract. See www.openinteract.org or sourceforge.net/projects/openinteract. OI is a full framework for developing web apps and uses a persistence framework called SPOPS, which lets you define an object type with transparent storage. If you do not mind passing the learning curve, this is for you. Documentaion is excelent and the author - Chris Winters, is really active helping out on the mailing list.

    If you want s.th. simpler, you could go for the Template-Toolkit www.template-toolkit.org. This is a great template engine, which has tons of plugins. One is for directy accessing DBI datasources from whithin the template code.

    Of course, these are not the only choices you might have, but the choices I made. You also might want to look at embperl, mason - www.mason-hq.org , and slash ( the stuff which runs slashdot ).

    have fun reading all this ;-)

    Andreas

[reply]
Re: Module for viewing/editing database table (DBI, CGI)?
by BigGuy (Friar) on Jul 18, 2002 at 21:00 UTC
    I like this one the best. It is DB Browser, by summersault software it works with postgresql, mysql, and oracle. It is gpl'ed (i think) and the author is a former(maybe current) monk. It is very simple to configure, has lots of options including edit, add, and delete.

    BigGuy
    "One World, one Web, one Program" - Microsoft promotional ad
    "Ein Volk, ein Reich, ein Fuhrer" - Adolf Hitler
[reply]

Back to Seekers of Perl Wisdom