DBIx::...ariaDB(3pm)

🦋 DBIx::SearchBuilder::Handle::MariaDB 💅

okay bestie, so this is a page from the User Contributed Perl Documentation collection, and the module we're screaming about is DBIx::SearchBuilder::Handle::MariaDB — a MariaDB specific Handle object. yep that's the whole name, she's long but she's worth it ✨

---

✨ NAME ✨

DBIx::SearchBuilder::Handle::MariaDB — A MariaDB specific Handle object 🎀

---

🌸 SYNOPSIS 🌸

okay so. there is literally nothing here. no synopsis. empty. a blank canvas. the synopsis said "not today" 💀 and honestly? iconic of her.

---

💖 DESCRIPTION 💖

So real talk: this module hands you a subclass of DBIx::SearchBuilder::Handle that exists purely to compensate for some of the idiosyncrasies of MySQL. like, MariaDB said "I'm gonna be quirky" and this module said "bet, I'll handle it for you" 🫶

---

👑 METHODS 👑

💅 Insert

Takes a table name as the first argument, and then just assumes the rest of the arguments are an array of key-value pairs to be inserted. bold assumption, love that for her ✨

If the insert goes through? You get the id of the insert back, slay. If it doesn't? You get a Class::ReturnValue object with the error reported in it. so like, read your errors bestie 😭

---

🧚 KnowsBLOBs

Returns 1 if the current database supports inserts of BLOBs automatically. Returns undef if the current database has to be told about BLOBs for inserts. like, she needs a heads up first. communication is key 💜

---

⭐ BLOBParams FIELD_NAME FIELD_TYPE

Returns a hash ref for the bind_param call — its whole job is identifying the BLOB types used by the current database for a particular column type. it's giving very specific, very ✨specialised✨

---

🔥 SimpleUpdateFromSelect

This is a customization of "SimpleUpdateFromSelect" in DBIx::SearchBuilder::Handle. Here's the tea: Mysql doesn't support update with subqueries when those fetch data from the table that is updated. so yeah, that's the problem she's out here solving 🙈

---

🌈 DatabaseVersion

Returns the MariaDB version, with any -foo identifier trimmed off. clean. polished. no extra baggage 💅

---

🎀 CaseSensitive

Returns undef, because MariaDB's searches are not case sensitive by default. lowercase, uppercase, she does not care, she loves all letters equally 🫶

---

💜 SimpleDateTimeFunctions

Returns a hash reference with specific date time functions of this database, for "DateTimeFunction" in DBIx::SearchBuilder::Handle. time is fake but these functions are real ⭐

---

🦋 ConvertTimezoneFunction

A custom implementation of "ConvertTimezoneFunction" in DBIx::SearchBuilder::Handle.

Use the following query to get the list of timezones:

SELECT Name FROM mysql.time_zone_name;

See also details on how MariaDB works with mysql timezone tables:

https://mariadb.com/kb/en/time-zones/

no cap, go read the docs, they're right there 🔥

---

🌸 QuoteName

Quotes a table or column name so you can avoid reserved word errors. she's literally holding the door open for your identifiers, what a queen 👑

---

✨ HasSupportForCombineSearchAndCount

MariaDB 10.2+ supports this. periodt. ✨

---

💌 a little sign-off

this page came to you from the User Contributed Perl Documentation, built on perl v5.40.1, dated 2026-05-07, and yeah the manpage title really do say DBIx::...ariaDB(3pm) because it got truncated mid-name like a text message that got cut off 😭 stay hydrated, read your error objects, and go forth and query responsibly bestie 💖🦋🎀🌸💅