Some of you may have seen this elsewhere (perlmonks or my use.perl.org journal), so forgive me.
I've just uploaded the first public version of DBD::SQLite to CPAN. What is it? DBD::SQLite is a DBD driver that contains the database engine in the driver. That means you don't need to install anything else - just DBD::SQLite, and you get a full transaction capable SQL92 RDBMS that uses a single disk file for the whole database. It is based on the copyright free SQLite engine at http://www.hwaci.com/sw/sqlite/, but you don't need to download and insall that to use DBD::SQLite - due to the copyright free nature I was able to include all the code directly into DBD::SQLite. It's a type-less database, much like CSV files, but you can specify types when you create the tables (no doubt this will be supported better in the future). It supports atomic commit and rollback - something you can't do with CSV. It supports table indexes. And it appears to be fast - about 30 to 50 times faster than DBD::CSV on my box doing normal insert/select operations. It's all AL/GPL'ed. If you reply, please CC me as I don't subscribe to dbi-users. -- <!-- Matt --> <:->Get a smart net</:->
