RDF::T...SQLite(3pm)

💖 RDF::T...SQLite — the tea ☕

okay bestie, so this is a page from the User Contributed Perl Documentation set, and it's all about RDF::Trine::Store::DBI::SQLite. Yes the name is long, she's got main character energy, we love her anyway. 🎀

---

✨ NAME ✨

RDF::Trine::Store::DBI::SQLite — it's the SQLite subclass of the DBI store. That's the whole vibe. 🦋

---

🌸 VERSION 🌸

This doc describes RDF::Trine::Store::DBI::SQLite version 1.019. Periodt. 💅

---

🫶 SYNOPSIS 🫶

here's how you actually use her:

use RDF::Trine::Store::DBI::SQLite;
my $store = RDF::Trine::Store->new({
                                     storetype => 'DBI',
                                     name      => 'test',
                                     dsn       => "dbi:SQLite:dbname=test.db",
                                     username  => '',
                                     password  => ''
                                   });

look at that. dsn pointing at dbi:SQLite:dbname=test.db, empty username and password because SQLite said "no passwords, we're local, we're chill". iconic. 🔥

---

💀 CHANGES IN VERSION 1.014 💀

okay so this is the part where we sit down. 🪑 the schema used to encode RDF data in SQLite changed in RDF::Trine version 1.014, and it changed to fix a bug that was causing data loss. so like, important. very important.

but here's the catch, bestie, and it's a big one:

⚠️ This change is not backwards compatible, and it's not compatible with the shared schema used by the other database backends that RDF::Trine supports — that's PostgreSQL and MySQL. not a drill. 🚨

so if you wanna move data between SQLite and the other databases? you gotta export to an RDF serialization and then re-import it into the new database. that's the only way. no shortcuts, no sneaky direct copies. 🙈

---

🧚 METHODS 🧚

so beyond the methods we're documenting down here 👇, this class inherits methods from the RDF::Trine::Store::DBI class. free methods, we love a generous queen. 👑

• new_with_config ( \%config ) — returns a brand new RDF::Trine::Store object based on the config hashref you hand her. you give her a \%config, she gives you a store. fair trade. 🤝
• init — creates all the necessary tables in the underlying database. she's building the foundation, literally. 🏗️

---

🌈 BUGS 🌈

found a bug? got a feature request? pls pls pls report it through the GitHub web interface at <https://github.com/kasei/perlrdf/issues>. don't suffer in silence bestie, the issues tab is right there. 😭🫶

---

💜 AUTHOR 💜

Gregory Todd Williams — <gwilliams@cpan.org>. shoutout to the author, absolute legend. 👑

---

⭐ COPYRIGHT ⭐

Copyright (c) 2006-2012 Gregory Todd Williams. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. slay, open source. 🎀

---

and that's the whole page, babes 💖 this was documented on 2024-01-13, running under perl v5.38.2, brought to you by the User Contributed Perl Documentation crew. go forth and store your RDF responsibly. 🌸✨🦋