CPAN::...:Index(3pm)

💖 CPAN::SQLite::DBI::Index 💖

okay bestie, so this one's from the User Contributed Perl Documentation corner of the internet, and it's giving very much plumbing energy — like, it's the module that does the behind-the-scenes database stuff so everything else can be cute and functional. her whole name is CPAN::SQLite::DBI::Index, iykyk. 🫶

✨ VERSION ✨

version 0.220 — yes queen, we're on 0.220. 💅

---

🌸 DESCRIPTION 🌸

so basically this module is the ~backstage crew~ for CPAN::SQLite::Index. it brings a whole lil toolbox of methods that handle indexing and populating the database from the index files. no cap, it's the one doing the actual work while everyone else takes the credit. iconic behavior honestly. 👑

here's the full rundown, don't skip a single one:

• create_tables — makes the database tables. like, builds the whole setup from scratch. main character construction energy. 🏗️✨
• drop_table — drops a table. just. yeets it. gone. 💀
• sth_insert — hands you back an $sth statement handle for inserting values into a table. it's giving here's your handle, go put stuff in there. 💖
• sth_update — returns an $sth statement handle, this time for updating values into a table. glow-up era for your rows. 🦋
• sth_delete — yep, another $sth statement handle, but this one's for deleting values from a table. not me romanticizing data loss but okay. 🙈

reminder bestie: every one of those sth_* methods gives you back an $sth statement handle — that's the whole point. don't lose it, it's important fr fr. 💅

---

🔥 SEE ALSO 🔥

• CPAN::SQLite::Index — the big sister module this one's out here supporting. go read her too, she's the moment. ✨

---

and that's the whole page, bestie — short, sweet, and fully booked. 🎀

this lil slice of documentation comes to you from perl v5.36.0, dated 2022-10-30, under the title CPAN::...:Index(3pm). slay, goodbye, mwah 💖✨🌸