Re: [sqlite] new support for virtual tables written in Perl

[Mark Lawrence]

Hi Laurent,

> This is to announce that next version of DBD::SQLite (the Perl
> driver for accessing SQLite databases) will include support for
> virtual tables written in Perl.

Thanks for the effort you put into this. I'm glad to see DBD::SQLite
continuing to improve, although I already consider it one of the
best interfaces to SQLite from a scripting language.

> * PerlData

This I could have used about a year ago. In one of my Perl programs
I dynamically generate a large list of values which I then need to
join with rows in SQLite. Currently I create a temporary table and
insert each value as it appears. The PerlData virtual table would
instead let me keep them in an @array variable to be used in a
single, simple, SQL statement at the end. This would dramatically
reduce the number calls I make into SQLite.

-- 
Mark Lawrence
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] new support for virtual tables written in Perl

[Laurent Dami]

Hi,

This is to announce that next version of DBD::SQLite (the Perl driver 
for accessing SQLite databases) will include support for virtual tables 
written in Perl. This is easier than writing virtual table extensions in 
C code, so I hope to see creative uses of this feature  from fellow Perl 
programmers.


To anybody interested : the dev release is at
https://metacpan.org/pod/release/ISHIGAKI/DBD-SQLite-1.43_05/lib/DBD/SQLite.pm
and the source repository is at
https://github.com/DBD-SQLite/DBD-SQLite .

The distribution includes two builtin virtual tables :

* FileContent 
(https://metacpan.org/pod/release/ISHIGAKI/DBD-SQLite-1.43_05/lib/DBD/SQLite/VirtualTable/FileContent.pm) 
: a variation on test_fs.c from the sqlite source, useful for using FTS4 
indices on content stored in the filesystem rather than in sqlite tables.


* PerlData 
(https://metacpan.org/pod/release/ISHIGAKI/DBD-SQLite-1.43_05/lib/DBD/SQLite/VirtualTable/PerlData.pm) 
: a variation and generalization on test_intarray.c from the sqlite 
source. Various kinds of Perl datastructures can be viewed as SQLite 
tables, both as input and as output, and this can be an easy way to 
communicate between a Perl program and a sqlite database, or for joining 
data from various sources.


The stable release should be published in next September or October.

Comments / remarks are welcome.

Cheers, Laurent Dami


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users