CGI::Se...:sqlite(3)

💾 CGI::Session::Driver::sqlite(3) — the SQLite driver for CGI::Session 🎀

okay so bestie, you found the page 💅 this is CGI::Session::Driver::sqlite, from the User Contributed Perl Documentation collection, and honestly? it's giving "small but mighty." it's the driver that lets CGI::Session stash your session data in SQLite files. let's get into it ✨

---

🌸 NAME 🌸

CGI::Session::Driver::sqlite — the CGI::Session driver for SQLite. that's it, that's the whole name, no notes 🫶

---

🦋 SYNOPSIS 🦋

here's how you summon it, first flavor:

    $s = CGI::Session->new("driver:sqlite", $sid, {DataSource=>'/my/folder/sessions.sqlt'});
    $s = CGI::Session->new("driver:sqlite", $sid, {Handle=>$dbh});

or, and hear me out, the second flavor:

    $s = CGI::Session->new('driver:sqlite', undef,
    {
        TableName=>'session',
        IdColName=>'my_id',
        DataColName=>'my_data',
        Handle=>$dbh,
    });

both slay, pick whichever fits your vibe 🔥

---

✨ DESCRIPTION ✨

so the sqlite driver does exactly what it says on the tin (iconic behavior, honestly): it stores session data in SQLite files, using the DBD::SQLite DBI driver. for the deeper lore, go read CGI::Session::Driver::DBI — that's its parent class, the main character it inherits from 👑

---

💅 DRIVER ARGUMENTS 💅

the supported driver arguments are DataSource and Handle. and bestie, listen: at most only one of these can be set while you're creating the session object. one. not both. pick a lane 💀

• DataSource — should be in the form of "dbi:SQLite:dbname=/path/to/db.sqlt". and here's the cute part: if the "dbi:SQLite:" prefix is missing, it gets prepended for you 🎀 no effort required.
• Handle — if this is present, it should be the database handle ($dbh) that DBI::connect() returned.

🚨 okay important one, don't scroll past: as of version 1.7 of this driver, the third argument is NOT optional. using a default database in the temporary directory is a security risk, because literally anyone on the machine can create and/or read your session data 😭 like, not a vibe. but if you've read all that, fully understand the risks, and still want the old behavior? you can set the "DataSource" option to '/tmp/sessions.sqlt'. your call, i'm just the messenger 🙈

---

🌈 BUGS AND LIMITATIONS 🌈

none known 🦋✨ (we love a clean bill of health)

---

👑 LICENSING 👑

for support and licensing, go see CGI::Session — it's all over there, i promise 🫶

---

and that's the whole page, bestie! 🌸 before you go — this beauty is perl v5.42.2, dated 2026-07-28, and filed under CGI::Se...:sqlite(3) in the User Contributed Perl Documentation. mwah, go write some sessions 💖💅