Database Grids

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

Comment on Database Grids

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 ;-)	[reply]
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	[reply]
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/).	[reply]