Apache::Session::Browseable::PgHstore - Hstore type support for Apache::Session::Browseable::Postgres

       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.

perl v5.40.1                                       2025-04-12              Apache::Sessio...eable::PgHstore(3pm)

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

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

       Apache::Session::Browseable::PgHstore - Hstore type support for Apache::Session::Browseable::Postgres

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

       Enable "hstore" extension in PostgreSQL database

         CREATE EXTENSION hstore;

       Create 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 that you don't need to declare indexes