Google Chart API with Perl -Dancer - SQLite DB

Barbie barbie at missbarbell.co.uk
Tue Apr 17 13:47:55 BST 2012


Hi Taka,

Possibly late in the day, but ...

> 
> I'm current working on the project that requires using Dancer,
> SQLite, Template::Toolkit and Google API to build a test database
> web application that will allow users to add and delete, or modify
> data in the database and the result should be shown on the table and
> Google Chart on the web.
> 
> I have so far managed to get the table done, I can can add and
> removed data from the database and the results are shown on the web
> page. However, I'm struggling with the Google Chart API. I have
> looked the Google::Chart and Template::Plugin::GoogleChart modules,
> but I found them quite hard to digest, so no much luck so far.

Have a look at my Graphs module [1] for the CPAN Testers Statistics
website [2]. It includes most of the parameters you're likely to need.
It took a lot of experimenting, so hopefully you'll find it useful.

Note this module uses simple CSV files, but should be simple enough to
tie into a database.

[1]
http://cpansearch.perl.org/src/BARBIE/CPAN-Testers-WWW-Statistics-0.97/lib/CPAN/Testers/WWW/Statistics/Graphs.pm
[2] http://stats.cpantesters.org

Cheers,
Barbie.
-- 
Birmingham Perl Mongers <http://birmingham.pm.org>
Memoirs Of A Roadie <http://barbie.missbarbell.co.uk>
CPAN Testers Blog <http://blog.cpantesters.org>
YAPC Conference Surveys <http://yapc-surveys.org>
Ark Appreciation Pages <http://ark.eology.org>



More information about the london.pm mailing list