Apache...SQLite(3pm)

🌸 NAME 🌸

okay so bestie, this is Apache...SQLite(3pm) — a User Contributed Perl Documentation page, and it is literally here to store persistent data in a SQLite database. no cap 💅

• Apache::Session::Browseable::Store::SQLite — Store persistent data in a SQLite database

---

✨ SYNOPSIS ✨

here’s the starter pack, bestie — copy it, love it, run it:

use Apache::Session::Browseable::Store::SQLite;

my $store = new Apache::Session::Browseable::Store::SQLite;

$store->insert($ref);
$store->update($ref);
$store->materialize($ref);
$store->remove($ref);

---

🦋 DESCRIPTION 🦋

Apache::Session::Browseable::Store::SQLite fulfills the storage interface of Apache::Session. Session data is stored in a SQLite database. that’s it, that’s the whole description, and it ate ✨💖

---

🎀 SCHEMA 🎀

To use this module, you will need at least these columns in a table called sessions, or another name if you supply the TableName parameter. lowkey important, bestie:

id char(32)     # or however long your session IDs are.
a_session text  # This has an ~8 KB limit :(

To create this schema, you can execute this command using the sqlite program:

CREATE TABLE sessions (
   id char(32) not null primary key,
   a_session text
);

If you use some other command, ensure that there is a unique index on the table's id column. periodt 🫶

---

💅 CONFIGURATION 💅

The module must know what datasource, username, and password to use when connecting to the database. These values can be set using the options hash (see Apache::Session documentation). The options are:

• DataSource
• UserName
• Password
• Handle
• TableName

Example, bestie — look at it, it’s giving connection details:

tie %hash, 'Apache::Session::Browseable::SQLite', $id, {
    DataSource => 'dbi:Pg:dbname=database',
    UserName   => 'database_user',
    Password   => 'K00l'
};

Instead, you may pass in an already-opened DBI handle to your database. so convenient, honestly:

tie %hash, 'Apache::Session::Browseable::SQLite', $id, {
    Handle => $dbh
};

---

👑 AUTHOR 👑

This modules was written by Jeffrey William Baker <jwbaker@acm.org> — iconic 💜

A fix for the commit policy was contributed by Michael Schout <mschout@gkg.net>. slay 🔥

---

🌈 SEE ALSO 🌈

go give these a read too, bestie:

• Apache::Session
• Apache::Session::Store::DBI

---

okay that’s the whole page, bestie — it’s from perl v5.40.1, dated 2026-05-14, and the manual page is Apache...SQLite(3pm). mwah 💋🫶