OOPS, my bad...that should be www.presicient.com/dbixchart....
Dean Arnold
> I'm pleased to announce the first release of DBIx::Chart, a DBI
> extension (via sublass) that makes any reasonably SQL compliant
> DBMS with a DBD appear to natively support chart rendering
> capability. Refer to www.prescient.com/dbixchart for usage details
> with numerous examples. As an example, to render a piechart from an
> Oracle query:
>
> use DBIx::Chart;
> my $dbh = DBIx::Chart->connect('dbi:Oracle:bunceville', $user, $pass)
> or die "Cannot connect\n";
> #
> # example: create a pie chart
> #
> $rsth = $dbh->prepare(
> "SELECT region, sum(sales) FROM widget_sales_tbl
> WHERE year=2002 AND product='widgets'
> GROUP BY region
> RETURNING PIECHART(*)
> WHERE WIDTH=400 AND HEIGHT=400 AND
> TITLE = '2002 Widget Sales By Region' AND
> COLOR IN ('red', 'green', 'blue', 'lyellow', 'lpurple') AND
> BACKGROUND='lgray' AND
> SIGNATURE='Copyright(C) 2001, GOWI Systems, Inc.'");
> $rsth->execute;
> $rsth->bind_col(1, \$buf);
> $rsth->fetch;
>
>
> In support of DBIx::Chart, I've also released DBD::Chart 0.80,
> which provides some extensions to support DBIx::Chart, as well
> as corrections for some cosmetic issues:
>
> - improved 3-D piechart rendering/labeling
> - experimental support for programmable fonts
> - BORDER property to select whether the image will have a border
>
> The modules should be appearing on CPAN shortly, and are available now
> at www.presicient.com/dbixchart and www.presicient.com/dbdchart.
>
> Regards,
> Dean Arnold
> Presicient Corp.
>
>
