---
name: "Apache::Session::Browseable::PgHstore"
section: "3pm"
platform: "linux"
package: "libapache-session-browseable-perl"
version: "1.3.16-1+deb13u1"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/Apache::Session::Browseable::PgHstore"
---

# Apache::Session::Browseable::PgHstore(3pm)

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

## 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-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.