• Log in

Virtual tables in Perl for SQLite

By Laurent Dami (‎dami‎) from Geneva.pm
Lightning talk
Target audience: Any
Language: English
Tags: database dbd sqlite

You can find more information on the speaker's site:

• Abstract: https://metacpan.org/release/ISHIGAKI/DBD-SQLite-1.43_07
• Talk: http://fr.slideshare.net/ldami/sq-lite-virtualtables

SQLite has a concept of "virtual tables" which look like regular tables but are implemented internally through specific functions. In the next version of DBD::SQLite (due Sept 2014) it will be possible to implement virtual tables in Perl. This offers lots of exciting possibilities, like joining regular DBMS data with some other kind of data within your
Perl programs, or having virtual columns containing file contents.