Apache...:PgJSON(3pm)

🌸 NAME 🌸

Apache...:PgJSON(3pm) is the manual page for Apache::Session::Browseable::PgJSON — literally Hstore type support for Apache::Session::Browseable::Postgres. Bestie, that's the whole name vibe 💅.

✨ SYNOPSIS ✨

Okay so first you gotta create the table:

CREATE UNLOGGED TABLE sessions (
    id varchar(64) not null primary key,
    a_session jsonb,
);

Optionally, add indexes on some fields. Example for Lemonldap::NG:

CREATE INDEX uid1 ON sessions USING BTREE ( (a_session ->> '_whatToTrace') );
CREATE INDEX  s1  ON sessions ( (a_session ->> '_session_kind') );
CREATE INDEX  u1  ON sessions ( ( cast(a_session ->> '_utime' AS bigint) ) );
CREATE INDEX ip1  ON sessions USING BTREE ( (a_session ->> 'ipAddr') );

Use it like Apache::Session::Browseable::Postgres except that you don't need to declare indexes. Slay ✨.

🦋 DESCRIPTION 🦋

Apache::Session::Browseable provides some class methods to manipulate all sessions and add the capability to index some fields to make research faster. Iconic behavior, no cap.

Apache::Session::Browseable::PgJSON implements it for PosqtgreSQL databases using "json" or "jsonb" type to be able to browse sessions. Yep, PosqtgreSQL is exactly what the page says — that spelling is not me, bestie 😭.

🌈 SEE ALSO 🌈

• <http://lemonldap-ng.org>
• Apache::Session::Postgres

👑 COPYRIGHT AND LICENSE 👑

• 2009-2025 by Xavier Guimard
• 2013-2025 by Clément Oudot
• 2019-2025 by Maxime Besson
• 2013-2025 by Worteks
• 2023-2025 by Linagora

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.10.1 or, at your option, any later version of Perl 5 you may have available.

---

Signed, sealed, and delivered by perl v5.40.1, dated 2026-05-14, and filed under Apache...:PgJSON(3pm) 🫶💖