Patch to support create_function and create_aggregate in DBD::SQLite

[Francis J. Lacoste]

Hello M. Sergeant,

I'm a developer for the Stichting LogReport Foundation 
(http://www.logreport.org) and we are now
using DBD::SQLite as a database engine in our Lire report generation
framework.

We needed to be able to take advantage of the possibility offered by the
sqlite library to register new functions and aggregates with the parser.
Since the sqlite_create_function() and sqlite_create_aggregate() API 
weren't accessible from the DBD driver, I added support for it. This now
makes it possible to implement SQLite functions and aggregates using 
perl.

Since this feature is of general-interest, we hope you can integrate
that feature in future releases of the driver. You'll find attached to
this email a patch in unified diff format against DBD-SQLite 0.25. The
patch also adds tests and documentation for the new features.

There is an issue in the current version of sqlite which prevents errors
in aggregate functions from being reported. This is ticket #330 on the
sqlite library. There are comments in the code about that issue. At the
moment, errors in aggregate function are reported as warnings.

Thank you very much for making DBD::SQLite.

Kind regards


Francis J. Lacoste

-- 
Francis J. Lacoste              . .           http://www.logreport.org
/^LogReport$/               . .               flacoste at logreport.org
-------------- next part --------------
A non-text attachment was scrubbed...
Name: DBD-SQLite-0.25.patch
Type: text/x-patch
Size: 19674 bytes
Desc: not available
Url : http://lists.logreport.org/pipermail/development/attachments/20030530/311f9883/attachment.bin 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://lists.logreport.org/pipermail/development/attachments/20030530/311f9883/attachment-0001.bin