CGI::Session::Driver::sqlite - CGI::Session driver for SQLite
Contents
Bugs And Limitations
None known.
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. Atmost 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. If Handle is 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'.
Licensing
For support and licensing see CGI::Session
perl v5.40.1 2025-02-18 CGI::Session::Driver::sqlite(3pm)
Name
CGI::Session::Driver::sqlite - CGI::Session driver for SQLite
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,
});
