Apache::Session::Browseable::PgJSON(3pm)

Usage

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

Overview

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.

Copyright and license

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.

Releases

4 releases since Debian 10 (Buster); the text changed 3 times.

10
11
12
13