The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

NAME

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

VERSION

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

SYNOPSIS

    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

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

Autrijus Tang <autrijus@autrijus.org>

COPYRIGHT

Copyright 2004, 2005 by Autrijus Tang <autrijus@autrijus.org>.

This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

See http://www.perl.com/perl/misc/Artistic.html

SEE ALSO

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