SQLite::VirtualTable 0.03

SQLite::VirtualTable is a Perl module that can create SQLite Virtual Table extensions in Perl.

SYNOPSIS

on Perl:
package MyVirtualTable;
use base SQLite::VirtualTable;

sub CREATE {
...
and then from your preferred SQLite application or language, as for instance, the sqlite3 shell:
$ sqlite3
sqlite> .load perlvtab.so
sqlite> CREATE VIRTUAL TABLE foo USING perl ("MyVirtualTable", foo, bar, ...);
sqlite> SELECT * FROM foo WHERE col1 AND col1 > 34;
...

Virtual tables are a new feature in SQLite (currently still only available from the development version on CVS) that allows you to create tables using custom backends to access (read and change) their contents instead of being stored in the database file.

The SQLite::VirtualTable module allows you to create these backends in Perl embbeding a perl interpreter as a SQLite extension.
Note that extensions written using this module can be used from any SQLite application and programming language (C, Java, PHP, Perl, etc.).