Extensions
biscuit

biscuit

pg_biscuit : IAM-LIKE pattern matching with bitmap indexing

Overview

ID Extension Package Version Category License Language
2170
biscuit
pg_biscuit
 2.0.1
FTS
MIT
C
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--s-d--
No
Yes
No
Yes
no
no
Relationships
Requires
plpgsql
See Also
hll
rum
pg_textsearch

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
PIGSTY
 2.0.1
18
17
16
15
14
13
 pg_biscuit -
RPM
PIGSTY
 2.0.1
18
17
16
15
14
13
 pg_biscuit_$v* -
DEB
PIGSTY
 2.0.1
18
17
16
15
14
13
 postgresql-$v-biscuit -
Linux / PG PG18 PG17 PG16 PG15 PG14 PG13
el8.x86_64
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
MISS
MISS
MISS
el8.aarch64
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
MISS
MISS
MISS
el9.x86_64
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
MISS
MISS
MISS
el9.aarch64
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
MISS
MISS
MISS
el10.x86_64
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
MISS
MISS
MISS
el10.aarch64
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
MISS
MISS
MISS
d12.x86_64
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
MISS
MISS
MISS
d12.aarch64
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
MISS
MISS
MISS
d13.x86_64
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
MISS
MISS
MISS
d13.aarch64
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
MISS
MISS
MISS
u22.x86_64
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
MISS
MISS
MISS
u22.aarch64
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
MISS
MISS
MISS
u24.x86_64
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
MISS
MISS
MISS
u24.aarch64
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
MISS
MISS
MISS
Package Version OS ORG SIZE File URL
pg_biscuit_18 2.0.1 el8.x86_64 pigsty 48.6 KiB pg_biscuit_18-2.0.1-1PIGSTY.el8.x86_64.rpm
pg_biscuit_18 2.0.1 el8.aarch64 pigsty 46.0 KiB pg_biscuit_18-2.0.1-1PIGSTY.el8.aarch64.rpm
pg_biscuit_18 2.0.1 el9.x86_64 pigsty 47.3 KiB pg_biscuit_18-2.0.1-1PIGSTY.el9.x86_64.rpm
pg_biscuit_18 2.0.1 el9.aarch64 pigsty 46.6 KiB pg_biscuit_18-2.0.1-1PIGSTY.el9.aarch64.rpm
pg_biscuit_18 2.0.1 el10.x86_64 pigsty 49.5 KiB pg_biscuit_18-2.0.1-1PIGSTY.el10.x86_64.rpm
pg_biscuit_18 2.0.1 el10.aarch64 pigsty 47.8 KiB pg_biscuit_18-2.0.1-1PIGSTY.el10.aarch64.rpm
postgresql-18-biscuit 2.0.1 d12.x86_64 pigsty 40.8 KiB postgresql-18-biscuit_2.0.1-1PIGSTY~bookworm_amd64.deb
postgresql-18-biscuit 2.0.1 d12.aarch64 pigsty 37.7 KiB postgresql-18-biscuit_2.0.1-1PIGSTY~bookworm_arm64.deb
postgresql-18-biscuit 2.0.1 d13.x86_64 pigsty 41.2 KiB postgresql-18-biscuit_2.0.1-1PIGSTY~trixie_amd64.deb
postgresql-18-biscuit 2.0.1 d13.aarch64 pigsty 37.9 KiB postgresql-18-biscuit_2.0.1-1PIGSTY~trixie_arm64.deb
postgresql-18-biscuit 2.0.1 u22.x86_64 pigsty 40.1 KiB postgresql-18-biscuit_2.0.1-1PIGSTY~jammy_amd64.deb
postgresql-18-biscuit 2.0.1 u22.aarch64 pigsty 38.7 KiB postgresql-18-biscuit_2.0.1-1PIGSTY~jammy_arm64.deb
postgresql-18-biscuit 2.0.1 u24.x86_64 pigsty 40.7 KiB postgresql-18-biscuit_2.0.1-1PIGSTY~noble_amd64.deb
postgresql-18-biscuit 2.0.1 u24.aarch64 pigsty 38.9 KiB postgresql-18-biscuit_2.0.1-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_biscuit_17 2.0.1 el8.x86_64 pigsty 48.5 KiB pg_biscuit_17-2.0.1-1PIGSTY.el8.x86_64.rpm
pg_biscuit_17 2.0.1 el8.aarch64 pigsty 46.0 KiB pg_biscuit_17-2.0.1-1PIGSTY.el8.aarch64.rpm
pg_biscuit_17 2.0.1 el9.x86_64 pigsty 47.2 KiB pg_biscuit_17-2.0.1-1PIGSTY.el9.x86_64.rpm
pg_biscuit_17 2.0.1 el9.aarch64 pigsty 46.6 KiB pg_biscuit_17-2.0.1-1PIGSTY.el9.aarch64.rpm
pg_biscuit_17 2.0.1 el10.x86_64 pigsty 49.5 KiB pg_biscuit_17-2.0.1-1PIGSTY.el10.x86_64.rpm
pg_biscuit_17 2.0.1 el10.aarch64 pigsty 47.8 KiB pg_biscuit_17-2.0.1-1PIGSTY.el10.aarch64.rpm
postgresql-17-biscuit 2.0.1 d12.x86_64 pigsty 40.7 KiB postgresql-17-biscuit_2.0.1-1PIGSTY~bookworm_amd64.deb
postgresql-17-biscuit 2.0.1 d12.aarch64 pigsty 37.7 KiB postgresql-17-biscuit_2.0.1-1PIGSTY~bookworm_arm64.deb
postgresql-17-biscuit 2.0.1 d13.x86_64 pigsty 41.2 KiB postgresql-17-biscuit_2.0.1-1PIGSTY~trixie_amd64.deb
postgresql-17-biscuit 2.0.1 d13.aarch64 pigsty 37.9 KiB postgresql-17-biscuit_2.0.1-1PIGSTY~trixie_arm64.deb
postgresql-17-biscuit 2.0.1 u22.x86_64 pigsty 40.1 KiB postgresql-17-biscuit_2.0.1-1PIGSTY~jammy_amd64.deb
postgresql-17-biscuit 2.0.1 u22.aarch64 pigsty 38.7 KiB postgresql-17-biscuit_2.0.1-1PIGSTY~jammy_arm64.deb
postgresql-17-biscuit 2.0.1 u24.x86_64 pigsty 40.7 KiB postgresql-17-biscuit_2.0.1-1PIGSTY~noble_amd64.deb
postgresql-17-biscuit 2.0.1 u24.aarch64 pigsty 38.9 KiB postgresql-17-biscuit_2.0.1-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_biscuit_16 2.0.1 el8.x86_64 pigsty 48.6 KiB pg_biscuit_16-2.0.1-1PIGSTY.el8.x86_64.rpm
pg_biscuit_16 2.0.1 el8.aarch64 pigsty 46.0 KiB pg_biscuit_16-2.0.1-1PIGSTY.el8.aarch64.rpm
pg_biscuit_16 2.0.1 el9.x86_64 pigsty 47.2 KiB pg_biscuit_16-2.0.1-1PIGSTY.el9.x86_64.rpm
pg_biscuit_16 2.0.1 el9.aarch64 pigsty 46.6 KiB pg_biscuit_16-2.0.1-1PIGSTY.el9.aarch64.rpm
pg_biscuit_16 2.0.1 el10.x86_64 pigsty 49.6 KiB pg_biscuit_16-2.0.1-1PIGSTY.el10.x86_64.rpm
pg_biscuit_16 2.0.1 el10.aarch64 pigsty 47.9 KiB pg_biscuit_16-2.0.1-1PIGSTY.el10.aarch64.rpm
postgresql-16-biscuit 2.0.1 d12.x86_64 pigsty 40.7 KiB postgresql-16-biscuit_2.0.1-1PIGSTY~bookworm_amd64.deb
postgresql-16-biscuit 2.0.1 d12.aarch64 pigsty 37.7 KiB postgresql-16-biscuit_2.0.1-1PIGSTY~bookworm_arm64.deb
postgresql-16-biscuit 2.0.1 d13.x86_64 pigsty 41.2 KiB postgresql-16-biscuit_2.0.1-1PIGSTY~trixie_amd64.deb
postgresql-16-biscuit 2.0.1 d13.aarch64 pigsty 37.9 KiB postgresql-16-biscuit_2.0.1-1PIGSTY~trixie_arm64.deb
postgresql-16-biscuit 2.0.1 u22.x86_64 pigsty 40.1 KiB postgresql-16-biscuit_2.0.1-1PIGSTY~jammy_amd64.deb
postgresql-16-biscuit 2.0.1 u22.aarch64 pigsty 38.7 KiB postgresql-16-biscuit_2.0.1-1PIGSTY~jammy_arm64.deb
postgresql-16-biscuit 2.0.1 u24.x86_64 pigsty 40.8 KiB postgresql-16-biscuit_2.0.1-1PIGSTY~noble_amd64.deb
postgresql-16-biscuit 2.0.1 u24.aarch64 pigsty 38.9 KiB postgresql-16-biscuit_2.0.1-1PIGSTY~noble_arm64.deb

Source

Repository
github.com/CrystallineCore/pg_biscuit
 Source Tarball
Biscuit-2.0.1.tar.gz
 
pig build pkg pg_biscuit;		# build rpm / deb with pig

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgsql -u   # add both repo and update cache

Install this extension with pig:

pig install pg_biscuit;		# install via package name, for the active PG version
pig install biscuit;		# install by extension name, for the current active PG version

pig install biscuit -v 18;   # install for PG 18
pig install biscuit -v 17;   # install for PG 17
pig install biscuit -v 16;   # install for PG 16

Create this extension with:

CREATE EXTENSION biscuit CASCADE; -- requires plpgsql
Last updated on
pg_tokenizerpg_textsearch