/ 
Apache-Session-Browseable-1.3.14
River stage one • 2 direct dependents • 3 total dependents
/ Apache::Session::Browseable::PgHstore

NAME

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

SYNOPSIS

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

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::PgHstore implements it for PosqtgreSQL databases using "hstore" extension to be able to browse sessions.

SEE ALSO

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

COPYRIGHT AND LICENSE

2009-2023 by Xavier Guimard
2013-2023 by Clément Oudot
2019-2023 by Maxime Besson
2013-2023 by Worteks
2023 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.