Apache...:Oracle(3pm)

💖 Apache::Session::Oracle — the 3pm girlies' guide 💖

okay so bestie, you're looking at the manual page for Apache::Session::Oracle, and it lives in section 3pm of your friendly neighbourhood Perl docs. she's giving "I make your sessions persist in Oracle" energy, and honestly? iconic. let's get into it. 🫶

---

✨ NAME ✨

Apache::Session::Oracle — an implementation of Apache::Session. that's it, that's the whole name. short, sweet, slays. 💅

---

🌸 SYNOPSIS 🌸

so here's how you'd actually use her. first option: you want Apache::Session to open brand new DB handles for you. then you do:

use Apache::Session::Oracle;

#if you want Apache::Session to open new DB handles:

tie %hash, 'Apache::Session::Oracle', $id, {
   DataSource => 'dbi:Oracle:sessions',
   UserName   => $db_user,
   Password   => $db_pass,
   Commit     => 1
};

#or, if your handles are already opened:

tie %hash, 'Apache::Session::Oracle', $id, {
   Handle => $dbh,
   Commit => 1
};

second option, for when your handles are already opened (look at you, so prepared ✨): just hand over the Handle and the Commit and you're done. both paths are valid, both are gorgeous, pick the one that matches your vibe. 🦋

---

💜 DESCRIPTION 💜

this module is an implementation of Apache::Session. it uses the Oracle backing store and — important — no locking. that's the whole deal, no cap. for the deets, go look at the example and the documentation for Apache::Session::Store::Oracle. iykyk. 👑

---

🎀 USAGE 🎀

okay so here's the tea. the special Apache::Session argument for this module is Commit.

you MUST provide the Commit argument. not optional. mandatory. the whole shebang.

what does it even do? it tells this module to either commit the transaction when it's finished, or to simply do nothing. and why, you ask? because this feature exists so that this module will not have adverse interactions with your local transaction policy, nor with your local database handle caching policy. 💀

and yes, the argument is mandatory on purpose — specifically "in order to make you think about this problem." the module is literally making you sit with your choices. respect. 🙈

she also respects the LongReadLen argument, which specifies the maximum size of the session object. if you don't specify it, the default maximum is 8 KB. so if your sessions are thicc, you know what to do. 🍓

---

⭐ AUTHOR ⭐

this module was written by Jeffrey William Baker <jwbaker@acm.org>. king behaviour, honestly. 👑

---

🌈 SEE ALSO 🌈

go read these next, bestie, they're all in the family:

• Apache::Session::File
• Apache::Session::Flex
• Apache::Session::DB_File
• Apache::Session::Postgres
• Apache::Session

---

and that's the whole page, gorgeous. this was brought to you by perl v5.36.0, dated 2022-11-19, straight out of the User Contributed Perl Documentation ✨ mwah, go tie some hashes. 💖🧚🌸