---
name: "Apache::Session::SQLite3"
section: "3pm"
platform: "linux"
package: "libapache-session-sqlite3-perl"
version: "0.03-2"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/Apache::Session::SQLite3"
---

# Apache::Session::SQLite3(3pm)

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

## 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