Alzabo...greSQL(3pm)

📦
version 0.92 · 2 versions
  • 0.92 · debian bookworm, debian trixie, ubuntu noble, ubuntu resolute, ubuntu stonking (latest)
  • 0.92 · ubuntu jammy
, in debian bookworm, debian trixie, ubuntu noble, ubuntu resolute, ubuntu stonking

💖 Alzabo::Driver::PostgreSQL 💖

okay bestie, so this one lives in the User Contributed Perl Documentation corner of the manual universe, and it's filed under the very cute, very truncated name Alzabo...greSQL(3pm) because the header couldn't fit the whole thing. iconic honestly.

✨ NAME ✨

Alzabo::Driver::PostgreSQL — the PostgreSQL-specific Alzabo driver subclass. it's giving "Alzabo but make it Postgres." 🐘

🌸 SYNOPSIS 🌸

use Alzabo::Driver::PostgreSQL;

that's it. that's the whole vibe. 🫶

🦋 DESCRIPTION 🦋

so basically this module hands you some PostgreSQL-specific implementations for the virtual methods that live over in Alzabo::Driver. no cap, that's the entire job description. 💅

👑 METHODS 👑

💜 connect, create_database, drop_database

on top of all the parameters already listed in the Alzabo::Driver docs (go read those, bestie, they're not optional reading), these three will also accept:

  • options
  • tty

that's the bonus content right there. ✨

💜 schemas

this method takes the exact same parameters as the connect() method. matching set, as it should be. 🎀

💜 get_last_id

returns the last id created for a sequenced column. that's the whole thing, she's simple and she delivers. 💖

💜 identifier_length

returns the maximum identifier length the database will allow.

real talk: this is really a guess based on the server version, because the actual value gets set when the server is compiled. so like, it's an educated guess, not a promise. 💀

💀 BUGS 💀

okay so during testing, the author found some problems using Postgres in a very specific situation: you start the app, connect to the database, get some data, fork, reconnect, and then get more data. 😭

their suspicion is that this has more to do with the DBD::Pg driver and/or Postgres itself than with Alzabo. and they don't believe this would be a problem for an app that forks before it ever connects to the database (think mod_perl). so like — not Alzabo's fault, probably. 🙈

🌈 AUTHOR 🌈

Dave Rolsky, <autarch@urth.org>

and that's the whole page, bestie!! this absolute gem is documented as part of perl v5.34.0, dated 2022-06-14, under the name Alzabo...greSQL(3pm) — slay, go forth and connect to your database responsibly 💅✨💖

📦 where this page comes from