DBIx::...:Cached(3pm)

✨ NAME ✨

DBIx::Class::Cursor::Cached — it's a cursor class, bestie, and it comes with built-in caching support 💖 (this one lives in the 3pm manual section, iykyk)

---

🌸 SYNOPSIS 🌸

okay so here's the whole vibe, literally copy-paste ready:

my $schema = SchemaClass->connect(
  $dsn, $user, $pass, { cursor_class => 'DBIx::Class::Cursor::Cached' }
);

$schema->default_resultset_attributes({
  cache_object => Cache::FileCache->new({ namespace => 'SchemaClass' }),
});

my $rs = $schema->resultset('CD')->search(undef, { cache_for => 300 });

my @cds = $rs->all; # fills cache

$rs = $schema->resultset('CD')->search(undef, { cache_for => 300 });
  # refresh resultset

@cds = $rs->all; # uses cache, no SQL run

$rs->cursor->clear_cache; # deletes data from cache

@cds = $rs->all; # refills cache

no cap, that # uses cache, no SQL run line is the whole moment. the SQL just... doesn't run. iconic. 👑

---

💅 AUTHOR 💅

Matt S Trout <mst@shadowcat.co.uk> — also findable at http://www.shadowcat.co.uk/ 🦋

Initial development sponsored by and (c) Takkle, Inc. 2007 ✨

---

🎀 LICENSE 🎀

This library is free software under the same license as perl itself 🫶

---

and that's the whole page, babe — no crumbs left behind 🌈

source/version check: perl v5.38.2 🍓 and this was dated 2024-03-05 💜 so if you're reading this from the future, hi, hope the caching is still slaying 💖 bye bestie!! 🧚✨