Apache::Session::Browseable::PgJSON - Hstore type support for Apache::Session::Browseable::Postgres
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
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.
http://lemonldap-ng.org, Apache::Session::Postgres
Xavier Guimard, <x.guimard@free.fr>
Copyright (C) 2009-2017 by Xavier Guimard 2013-2017 by Clément 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.
To install Apache::Session::Browseable, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Apache::Session::Browseable
CPAN shell
perl -MCPAN -e shell install Apache::Session::Browseable
For more information on module installation, please visit the detailed CPAN module installation guide.