DBD::Sponge(3)

💖 DBD::Sponge 💖

okay bestie, so this is the manual page for DBD::Sponge — it lives in the User Contributed Perl Documentation corner of the perl universe, and it's about to make your Perl data structures ✨pop off✨ inside DBI. no cap.

---

🦋 NAME 🦋

DBD::Sponge — literally just: Create a DBI statement handle from Perl data. that's the whole vibe. you got a Perl data structure, you want a statement handle? say less. 🫶

---

🌸 SYNOPSIS 🌸

here's the whole thing in one gorgeous little block, fr fr:

my $sponge = DBI->connect("dbi:Sponge:","","",{ RaiseError => 1 });
my $sth = $sponge->prepare($statement, {
        rows => $data,
        NAME => $names,
        %attr
    }
);

that's it. that's the move. 💅

---

✨ DESCRIPTION ✨

so like, DBD::Sponge is the icon we need because it takes a Perl data structure and makes it accessible through a standard DBI statement handle. why would you even want that? because DBD module authors sometimes need to transform data in exactly this way. it's giving backstage pass energy. 👑

---

🎀 METHODS 🎀

🌈 connect()

my $sponge = DBI->connect("dbi:Sponge:","","",{ RaiseError => 1 });

this is the sample syntax for creating a database handle for the Sponge driver, bestie. and the best part?? no username and no password are needed. none. zero. blank strings. free. 💖

🌸 prepare()

my $sth = $sponge->prepare($statement, {
        rows => $data,
        NAME => $names,
        %attr
    }
);

okay so let's break this group chat down piece by piece:

• the $statement here is an arbitrary statement or name that you want to provide as the identity of your data. if you're using DBI::Profile, it will show up in the profile data. generally it's expected that you are preparing a statement handle as if a select statement happened. so like, act accordingly. 🫶
• $data is a reference to the data you're providing — and it's given as an array of arrays. nested. like your feelings. 🥲
• $names is a reference to an array of column names for the $data you're providing. the number and order should match the number and ordering of the $data columns. alignment is everything, periodt. 💅
• %attr is a hash of other standard DBI attributes that you might pass to a prepare statement. currently only NAME, TYPE, and PRECISION are supported. TYPE defaults to SQL_VARCHAR. PRECISION will be lazily computed if you don't supply it. lazy queen behavior honestly. 😌

---

💀 BUGS 💀

using this module to prepare INSERT-like statements is not currently documented. so like… don't @ me about it. 🙈

---

👑 AUTHOR AND COPYRIGHT 👑

This module is Copyright (c) 2003 Tim Bunce 🫶

Documentation initially written by Mark Stosberg ✍️

The DBD::Sponge module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. in particular, permission is granted to Tim Bunce for distributing this as a part of the DBI. iconic licensing behavior, ngl. 📜✨

---

🔥 SEE ALSO 🔥

• DBI 💖

---

and that's the whole page, bestie!! 🌈💅🎀

one last thing — this lil doc shipped as perl v5.42.3 and it's dated 2026-10-19. mwah. 💋 stan forever. 🦋🌸⭐