1Apache::Session::BrowseUasbelre:C:oPngtJrSiObNu(t3e)d PeArplacDhoec:u:mSeenstsaitoino:n:Browseable::PgJSON(3)
2
3
4

NAME

6       Apache::Session::Browseable::PgJSON - Hstore type support for
7       Apache::Session::Browseable::Postgres
8

SYNOPSIS

10       Create table:
11
12         CREATE UNLOGGED TABLE sessions (
13             id varchar(64) not null primary key,
14             a_session jsonb,
15         );
16
17       Optionally, add indexes on some fields. Example for Lemonldap::NG:
18
19         CREATE INDEX uid1 ON sessions USING BTREE ( (a_session ->> '_whatToTrace') );
20         CREATE INDEX  s1  ON sessions ( (a_session ->> '_session_kind') );
21         CREATE INDEX  u1  ON sessions ( ( cast(a_session ->> '_utime' AS bigint) ) );
22         CREATE INDEX ip1  ON sessions USING BTREE ( (a_session ->> 'ipAddr') );
23
24       Use it like Apache::Session::Browseable::Postgres except that you don't
25       need to declare indexes
26

DESCRIPTION

28       Apache::Session::Browseable provides some class methods to manipulate
29       all sessions and add the capability to index some fields to make
30       research faster.
31
32       Apache::Session::Browseable::PgJSON implements it for PosqtgreSQL
33       databases using "json" or "jsonb" type to be able to browse sessions.
34

SEE ALSO

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

AUTHOR

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

42       Copyright (C) 2009-2017 by Xavier Guimard
43                     2013-2017 by Clement Oudot
44
45       This library is free software; you can redistribute it and/or modify it
46       under the same terms as Perl itself, either Perl version 5.10.1 or, at
47       your option, any later version of Perl 5 you may have available.
48
49
50
51perl v5.30.1                      2020-01A-p2a9che::Session::Browseable::PgJSON(3)
Impressum