Re: Class::DBI::* module proposal

This sounds like you're implementing a bit of a data cube (think OLAP). You may want to look and see what there is for calculating cubes on data via Class::DBI. If you were going to do this it'd help if you were aware of the space you're working with.

Comment on Re: Class::DBI::* module proposal

Replies are listed 'Best First'.
Re: Re: Class::DBI::* module proposal by dcvr69 (Beadle) on May 20, 2004 at 00:46 UTC
You're right - I'll go through the CDBI namespace (again - haven't done so recently... past month or so) and see if there's anything out there already... maybe I'll be lucky and there is. :) Update: Class::DBI::ConceptSearch, mentions aggregates in it's description, but isn't really about min/max/... Class::DBI::Extension (which another PM mentioned to me) almost does it - get_count_from_sql and get_range are nice, but don't allow for searches like AbstractSearch does - which is ironic, since they're from the same author. Class::DBI::Plugin::CountSearch is almost a winner - but isn't quite as flexible as AbstractSearch on the where clause logic. Had I seen this first though, I may have just lived with the limitation. It also only does COUNT(*), not any of the others (min/max/...). This (and CDBI::search) will be good reference for adding in column support on the min/max/... methods. If there is anyting that has all the functionality I'm looking for, it's not in the Class::DBI namespace.	[reply]

Replies are listed 'Best First'.

Re: Re: Class::DBI::* module proposal
by dcvr69 (Beadle) on May 20, 2004 at 00:46 UTC

You're right - I'll go through the CDBI namespace (again - haven't done so recently... past month or so) and see if there's anything out there already... maybe I'll be lucky and there is. :)

Update:

Class::DBI::ConceptSearch, mentions aggregates in it's description, but isn't really about min/max/...

Class::DBI::Extension (which another PM mentioned to me) almost does it - get_count_from_sql and get_range are nice, but don't allow for searches like AbstractSearch does - which is ironic, since they're from the same author.

Class::DBI::Plugin::CountSearch is almost a winner - but isn't quite as flexible as AbstractSearch on the where clause logic. Had I seen this first though, I may have just lived with the limitation. It also only does COUNT(*), not any of the others (min/max/...). This (and CDBI::search) will be good reference for adding in column support on the min/max/... methods.

If there is anyting that has all the functionality I'm looking for, it's not in the Class::DBI namespace.

[reply]