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

Dear Monks

I was wondering if this existsed all ready. I tried the usual sources. Have an SQL data source and want to display the data though HTML and embed links in the data that goto other Views/tables, and also possibly have it allow the editing of the data.

I could probably implement it in PERL with XML to control the metadata ( like the links ) but I figured i'd ask before reinventing the wheel

Replies are listed 'Best First'.
Re: Database Grids
by phydeauxarff (Priest) on Mar 10, 2003 at 18:45 UTC
    You will want to checkout a couple of resources to get you on your way
    First, start with the Files and Databases Tutorial here.
    If you want to make your Microsoft life really easy manipulating SQL Data, checkout DBD::ODBC
    If you are using some other SQL datasource like mySQL or such...just do a CPAN search for DBD.
    and lastly, but certainly not leastly, if this is anything more than just a casual endeavor on your part you will want to own a copy of Programming the PERL DBI...never leave home without it ;-)
Re: Database Grids
by CountZero (Bishop) on Mar 10, 2003 at 19:54 UTC

    Although it is not a pure PERL solution (it uses some client side Java), wdbil (which stands for Web Database Interface language] seems to fit the bill.

    I first thought about suggesting wdbi (Web Database Interface) which used to be found at www.wdbi.net --Don't go there now though, it is surely no longer a site about programming-- which I used succesfully in the past, but seems no longer maintained now. If someone knows where it can be found now or if someone still updates it ...

    CountZero

    "If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law

Re: Database Grids
by meetraz (Hermit) on Mar 10, 2003 at 18:44 UTC
    I'm not familiar with any perl solutions that do this sort of thing, but PHP Lens sounds prettty close (http://phplens.com/).