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.
