Orthogonal object persistence in sqlite databases
use Tangram; use Tangram::Driver::SQLite; $schema = Tangram::Driver::SQLite->schema( $hashref ); Tangram::Driver::SQLite->deploy($schema, $dbh); $storage = Tangram::Driver::SQLite->connect( $schema, $data_source, $username, $password ); $storage->disconnect(); Tangram::Driver::SQLite->retreat($schema, $dbh);
This is the entry point in the SQLite-specific object-relational persistence backend.
For reasons similar to the Tangram::Driver::Pg module, this back-end automatically encodes Tangram::Type::Dump::Storable objects via MIME::Base64 to avoid truncation of values on \s-1NUL\s0 bytes.
Also, note that despite what is mentioned on the front page of www.sqlite.org, SQLite is not actually an \s-1ACID\s0 database; any writer to the database has to wait for all other writers to finish before they can begin their transaction.
So make sure you start and complete your transactions as quickly as possible with this back-end.