CPAN::...te::DBI(3pm)

💖 NAME 💖

CPAN::SQLite::DBI — bestie, this is the DBI tea for the CPAN::SQLite database. 🫶

(It lives in the User Contributed Perl Documentation section of your man pages, so that's the vibe.)

---

✨ VERSION ✨

version 0.220 — yeah she's got a number and she's proud of it. 👑

---

🌸 DESCRIPTION 🌸

okay so listen. This module is the little backstage gremlin that CPAN::SQLite::Index and CPAN::SQLite::Search call up when they need to sort out some basic database information. It's giving stage crew, not main character, but without it the whole show collapses. 💅

She exports two variables. Two. That's it. Iconic minimalism fr fr.

• $tables — this one is a hash reference, and the keys of that hash are the table names. The values? Also hash references (we love a nested moment 🪆), whose keys are the columns of the table and whose values are the associated data types. So like: table → column → type. A whole lil family tree of your schema. 🌈
• $dbh — this is a DBI database handle, and she's the one actually connecting you to the database. Your plug, your portal, your lil doorway into the data. 🚪✨

The main method of this module is "make", and its whole job is to make the tables of the database. That's it. She makes tables. She ate and left no crumbs. 🍽️

---

🦋 SEE ALSO 🦋

Go give these two a follow, they're the ones actually using all this:

• CPAN::SQLite::Index
• CPAN::SQLite::Search

---

perl v5.36.0 · 2022-10-30 — that's the version and the date this page was born, bestie. Ty for coming to my TED talk, ily, go make some tables. 🎀💜🌸