# phpman > man > CGI::Session::Driver::sqlite(3pm)

## NAME
    [CGI::Session::Driver::sqlite](https://www.chedong.com/phpMan.php/perldoc/CGI%3A%3ASession%3A%3ADriver%3A%3Asqlite/markdown) - [CGI::Session](https://www.chedong.com/phpMan.php/perldoc/CGI%3A%3ASession/markdown) driver for SQLite

## SYNOPSIS
        $s = [CGI::Session](https://www.chedong.com/phpMan.php/perldoc/CGI%3A%3ASession/markdown)->new("driver:sqlite", $sid, {DataSource=>'/my/folder/sessions.sqlt'});
        $s = [CGI::Session](https://www.chedong.com/phpMan.php/perldoc/CGI%3A%3ASession/markdown)->new("driver:sqlite", $sid, {Handle=>$dbh});

    or

        $s = [CGI::Session](https://www.chedong.com/phpMan.php/perldoc/CGI%3A%3ASession/markdown)->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](https://www.chedong.com/phpMan.php/perldoc/DBD%3A%3ASQLite/markdown) DBI driver. More details see
    [CGI::Session::Driver::DBI](https://www.chedong.com/phpMan.php/perldoc/CGI%3A%3ASession%3A%3ADriver%3A%3ADBI/markdown), 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. If *Handle* is present it should be database handle ($dbh)
    returned by [DBI::connect](https://www.chedong.com/phpMan.php/perldoc/DBI%3A%3Aconnect/markdown)().

    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](https://www.chedong.com/phpMan.php/perldoc/CGI%3A%3ASession/markdown)