Apache...gHstore(3pm)

💖 NAME 💖

Hey bestie 💖 welcome to Apache...gHstore(3pm) — the Apache::Session::Browseable::PgHstore page from the User Contributed Perl Documentation. It’s giving Hstore type support for Apache::Session::Browseable::Postgres, periodt ✨

🌸 SYNOPSIS 🌸

First up: enable the hstore extension in your PostgreSQL database, no cap:

CREATE EXTENSION hstore;

Then create the table:

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

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 the iconic plot twist is that you don’t need to declare indexes 💅

🦋 DESCRIPTION 🦋

Okay so Apache::Session::Browseable provides some class methods to manipulate all sessions and adds the capability to index some fields to make research faster. Obsessed.

Apache::Session::Browseable::PgHstore implements it for PosqtgreSQL databases using the hstore extension to be able to browse sessions. Slay 💖

🌈 SEE ALSO 🌈

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

🎀 COPYRIGHT AND LICENSE 🎀

The author lineup, preserved exactly because we do not erase receipts:

• 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.

---

Okay that’s the whole page, bestie 💖 — it’s Apache...gHstore(3pm) from the User Contributed Perl Documentation, shipped as perl v5.40.1 and dated 2026-05-14. Byeee 🫶✨