SQLite::DB SQLite::DB module provides an object oriented wrapper to SQLite databases using DBI and DBD::SQLite modules.
Download

SQLite::DB Ranking & Summary

SQLite::DB Tags

SQLite database SQLite DBI object oriented wrapper

SQLite::DB Description

SQLite::DB module provides an object oriented wrapper to SQLite databases using DBI and DBD::SQLite modules. SQLite::DB module provides an object oriented wrapper to SQLite databases using DBI and DBD::SQLite modules.SYNOPSIS use SQLite::DB; my $db = SQLite::DB->new('file'); $db->connect; $db->select("select * from table where field = value",{}) || print $db->get_error."n"; $db->select("select * from table where field = ?",{},"value") || print $db->get_error."n"; $result = $db->select_one_row("select max(field) as total FROM table"); print $$result{TOTAL}; $db->transaction_mode; $db->exec("INSERT (a,b,c) VALUES 'a','b','c'"); $db->exec("INSERT (a,b,c) VALUES ?,?,?",'a','b','c'); $db->exec("update table set field = value") || print $db->get_error."n"; $db->commit || print $db->get_error."n"; $db->rollback || print $db->get_error."n"; my $resultset = $db->get_dblist("select * from table","display_field","keyfield"); if (!ref $resultset) { print $db->get_error."n" } else { for (@$resultset) { print $resultset->->{id}." - ".$resultset->->{value}."n"; } } $db->disconnect; Requirements: · Perl

SQLite::DB Related Software