I must admit that there's nothing that's really "it" in CPAN. A few months ago I spent a lot of time looking through the modules that Joshua described and never found what I wanted. I didn't know about phpLens until now, but it looks sweet. Instead, I've been writing some Apache::ASP tags that, if I do say so myself, nicely abstract away a lot of the database code. I'm only concerned with view and search (not editting (data entry), which I believe to be a separate can of worms for all but the simplest databases). I hope to release it some day.
The basic idea is <dbb:form> <dbb:table table="foo" DSN=$DSN /> </dbb:form> and it magically inserts a paginated, CSS savvy, searchable table to your HTML document. It relies on simple meta-data in the database to control things like layout of numerics, etc. and you can write your own little perl "rendering" methods to display a cell of a table however you like. Additional tags <dbb:selection> and <dbb:qset> allow for exporting a selection set or the results of a query to a tab delimited or Excel output. Sound interesting to anyone besides me? If so, I might put more energy into making a releasable package. -d > -----Original Message----- > From: Joshua Chamas [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 21, 2002 6:08 PM > To: Jim Helm > Cc: [EMAIL PROTECTED] > Subject: Re: OT: (slightly) RAD RDBMS tools for perl/Apache::ASP > > > Jim Helm wrote: > > > > This isn't specific to Apache:ASP, but I've seen a lot of > good advice > > here, and hopefully someone has already been through this. > > > > I was just wondering if anyone had used/knows of anything for perl > > similar to phpLens. I haven't actually used it, but it looks pretty > > impressive. I'd prefer to stick with perl, though. I've searched > > through CPAN, and on google, and haven't found anything > obviously like > > phpLens for perl, but there's a lot out there and I may > have just missed > > it. The closest I think I've seen so far is > DBIx::HTMLView, but it's > > only for mySQL and mSQL (needs some extra coding for other > DBD drivers - > > I think). > > > > I have always rolled by own application by application, but my > apps have always had to be pretty tight to the database for > high performance with mixed OLAP/OLTP environments. > > If you feel that RAD does not have to be GUI RAD, I might look > at these: > > CGI::FormBuilder ( promises 4x code reduction ) > DBIx::XHTML_Table > > If you want something closer do the database, and don't mind doing > your own HTML, check out: > > DBIx::Recordset > Alzabo > > They at least abstract DBI slightly away from you. > > > all the bells and whistles of phpLens - though they would > be nice. And > > I need to be able to make updates - simply displaying data is fairly > > trivial, and I wouldn't need to ask for tools to do that - > they are a > > phpLens looks nice. You you want something that is more of a > CMS in perl, > you can try Bricolage or Mason: > > http://bricolage.thepirtgroup.com/ > http://www.masonhq.com/ > > Sorry, I don't think any of these quite hit it on the head for > you, but I thought I'd try! Best of luck, and if you find anything > interesting please share it with the rest of us, as it seems > to be a fairly common problem. Also, you might try the mod_perl > list & I am sure you will get some opinions :) > > --Josh > _________________________________________________________________ > Joshua Chamas Chamas Enterprises Inc. > NodeWorks Founder Huntington Beach, CA USA > http://www.nodeworks.com 1-714-625-4051 > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]