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

In reply to Re: Module for viewing/editing database table (DBI, CGI)? by anolte
in thread Module for viewing/editing database table (DBI, CGI)? by dda

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.