NAME

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

SYNOPSIS

       Create 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

DESCRIPTION

       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::PgJSON implements it for PosqtgreSQL databases using "json"
       or "jsonb" type to be able to browse sessions.

SEE ALSO

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

AUTHOR

       Xavier Guimard, <x.guimard@free.fr>

COPYRIGHT AND LICENSE

       Copyright (C) 2009-2017 by Xavier Guimard
                     2013-2017 by Clement Oudot

       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.