I have looked into CDBI a bit more (it was I that started all of this several days ago). I am still concerned about handling joins. I agree that it (CDBI) looks fantastic for getting information from a single table at a time, but I often need to pull data from different columns in several tables at a time or perform a join (or multiple) to get the information that I want. In my particular case, I have some 50 tables, many with only 2-3 columns because of the relationality of the data, so performing multiple selects to "drill down" to data from a fourth or fifth join using the CDBI framework seems quite tedious and successfully defeats the power of modern SQL engines for performing these joins in a very systematic fashion, using more than just a primary key if possible. I recognize that CDBI still allows the flexibility of straight-up SQL, which is why I may ultimately use it, but I am curious if there is more coming along in joins than has been discussed. This is certainly getting outside the realm of CGI::App list, but I have had so many recommendations from users here that I thought I might benefit from a tad bit more insight.
Sean ----- Original Message ----- From: "William McKee" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 04, 2004 9:53 AM Subject: Re: [cgiapp] Building Complex Applications with C::A and helper modules > On Sat, Oct 02, 2004 at 01:11:54AM -0400, Caleb Rutan wrote: > > That is somewhere in the neighborhood of pre-alpha. The caching stuff > > is not there, and the DB abstraction is not clean at all. It doesn't > > handle multi-column keys for tables well, nor does it do joins very > > smoothly. Those issues are almost done. > > Hi Caleb, > > Thanks for sharing your framework design. I'm curious why you don't use > Class::DBI. Is there some limitation in its design? I find that it works > just as well for external scripts accessing the database as for my > CGI::App applications. > > I had started down the road of building a custom database interface > module and am very glad to have found a community who has already made > much further progress than I had. CDBI can handle multi-column primary > keys and has some alpha support for joins. > > > William > > -- > Knowmad Services Inc. > http://www.knowmad.com > > --------------------------------------------------------------------- > Web Archive: http://www.mail-archive.com/[EMAIL PROTECTED]/ > http://marc.theaimsgroup.com/?l=cgiapp&r=1&w=2 > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- Web Archive: http://www.mail-archive.com/[EMAIL PROTECTED]/ http://marc.theaimsgroup.com/?l=cgiapp&r=1&w=2 To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
