Apache::Session::SQLite3 - Use DBD::SQLite 1.x for Apache::Session storage


Apache-Session-SQLite3 documentation  | view source Contained in the Apache-Session-SQLite3 distribution.

Index


NAME

Top

Apache::Session::SQLite3 - Use DBD::SQLite 1.x for Apache::Session storage

VERSION

Top

This document describes version 0.03 of Apache::Session::SQLite3, released February 2, 2005.

SYNOPSIS

Top

    use Apache::Session::SQLite3;

    tie %hash, 'Apache::Session::SQLite3', $id, {
        DataSource => 'dbi:SQLite:dbname=/tmp/session.db'
    };

    # to purge all sessions older than 30 days, do this:
    tied(%hash)->{object_store}{dbh}->do(qq[
        DELETE FROM Sessions WHERE ? > LastUpdated
    ], {}, time - (30 * 86400));

DESCRIPTION

Top

This module is an implementation of Apache::Session. It uses the DBD::SQLite backing store. It requires DBD::SQLite version 1.00 or above, due to its use of SQLite3 API for BLOB support. Also, an extra LastUpdated field is populated with the current time().

There is no need to create the data source file beforehand; this module creates the session table automatically.

AUTHOR

Top

Autrijus Tang <autrijus@autrijus.org>

COPYRIGHT

Top

SEE ALSO

Top

Apache::Session, Apache::Session::SQLite, DBD::SQLite


Apache-Session-SQLite3 documentation  | view source Contained in the Apache-Session-SQLite3 distribution.