Tangra...:SQLite(3pm)

✨ Tangra...:SQLite ✨

okay bestie, come SIT DOWN because this one is a whole vibe 💅 it lives in the User Contributed Perl Documentation corner of the manual, and it's giving "tiny database, big feelings" 🦋

---

🌸 NAME 🌸

Tangram::Driver::SQLite — Orthogonal Object Persistence in SQLite databases 🎀

---

✨ SYNOPSIS ✨

no thoughts, just copy-paste energy, iykyk 👑

use Tangram;
use Tangram::Driver::SQLite;

$schema = Tangram::Driver::SQLite->schema( $hashref );

Tangram::Driver::SQLite->deploy($schema, $dbh);

$storage = Tangram::Driver::SQLite->connect( $schema,
   $data_source, $username, $password );

$storage->disconnect();

Tangram::Driver::SQLite->retreat($schema, $dbh);

---

💖 DESCRIPTION 💖

So like… this is THE entry point into the SQLite-specific object-relational persistence backend. That's it. That's the whole thing. It's the front door, the main character, the gateway 🚪✨

---

🫶 ERRATA 🫶

ngl there's some lore here and you're gonna wanna hear it.

• For reasons similar to the Tangram::Driver::Pg module, this back-end automatically encodes Tangram::Type::Dump::Storable objects via MIME::Base64 — this is so values don't get truncated on NUL bytes 💀 no truncation in this house, periodt.
• Also, bestie… plot twist: despite what it says on the front page of www.sqlite.org, SQLite is not actually an ACID database 😭 any writer to the database has to wait for all the other writers to finish before they can begin their transaction. the way that literally bottlenecks everything… 🙈

🚨 So make sure you start and complete your transactions as quickly as possible with this back-end. fast in, fast out, no lingering, we don't do that here 🧚

---

and that's the whole page, babe 🌈 hope you ate, because this backend is a snack 💅

perl v5.36.0 · 2022-10-16 · Tangra...:SQLite(3pm) 🎀 xoxo, go write some schemas 💜