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

       Autrijus Tang <autrijus@autrijus.org>

       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>

       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.

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

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

perl v5.34.0                                       2022-06-06                      Apache::Session::SQLite3(3pm)

           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));

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