perldoc > CGI::Session::Driver::sqlite

📛 NAME

🔗 CGI::Session::Driver::sqlite — CGI::Session driver for SQLite

🚀 Quick Reference

📋 SYNOPSIS

$s = CGI::Session->new("driver:sqlite", $sid, {DataSource=>'/my/folder/sessions.sqlt'});
$s = CGI::Session->new("driver:sqlite", $sid, {Handle=>$dbh});

or

$s = CGI::Session->new('driver:sqlite', undef,
{
    TableName=>'session',
    IdColName=>'my_id',
    DataColName=>'my_data',
    Handle=>$dbh,
});

📖 DESCRIPTION

📂 sqlite driver stores session data in SQLite files using DBD::SQLite DBI driver. More details see CGI::Session::Driver::DBI, its parent class.

⚙️ DRIVER ARGUMENTS

Supported driver arguments are DataSource and Handle. At most only one of these arguments can be set while creating session object.

• 📁 DataSource should be in the form of dbi:SQLite:dbname=/path/to/db.sqlt. If dbi:SQLite: is missing it will be prepended for you.
• 🔗 Handle – if present it should be database handle ($dbh) returned by DBI::connect().

⚠️ As of version 1.7 of this driver, the third argument is NOT optional. Using a default database in the temporary directory is a security risk since anyone on the machine can create and/or read your session data. If you understand these risks and still want the old behavior, you can set the DataSource option to '/tmp/sessions.sqlt'.

🐛 BUGS AND LIMITATIONS

None known.

📄 LICENSING

For support and licensing see CGI::Session.