Apache...QLite3(3pm)

💖 Apache::Session::SQLite3 — the man page, but make it cute 💖

okay bestie, so this is the man page for Apache::Session::SQLite3(3pm) — yes the header truncates it to Apache...QLite3(3pm) because man pages are dramatic like that, but you and me both know the real name. let's get into it 🫶

---

✨ NAME ✨

Apache::Session::SQLite3 — use DBD::SQLite 1.x for Apache::Session storage 💅

✨ VERSION ✨

This doc describes version 0.03 of Apache::Session::SQLite3, released February 2, 2005. vintage. iconic. a little elder-millennial but we respect her 🎀

✨ SYNOPSIS ✨

the vibe check, in code:

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

so you tie a hash, you point it at your SQLite file, and boom — sessions. and if you want to clear out the old ones, that last bit is literally how you do it. no cap. 🦋

✨ DESCRIPTION ✨

okay so. this module is an implementation of Apache::Session. she's giving "backing store" energy. it uses the DBD::SQLite backing store 💖

important bestie: it requires DBD::SQLite version 1.00 or above — that's because it uses the SQLite3 API for BLOB support. so if you're rocking something ancient, no BLOB for you. 💀

also, an extra "LastUpdated" field gets populated with the current "time()". she keeps receipts. ⭐

and the best part: there is no need to create the data source file beforehand — this module creates the "session" table automatically. it's giving main character energy, it sets itself up 👑

✨ 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 🦋

---

and that's the whole page bestie, you ate it. ✨ this little doc came from perl v5.34.0, dated 2022-06-06, filed under that Apache...QLite3(3pm) name at the bottom of every page — periodt, go tie some sessions 💖🌸💅