spat

pig build pkg spat;		# build rpm/deb

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

pig install spat;		# install via package name, for the active PG version

pig install spat -v 17;   # install for PG 17

CREATE EXTENSION spat;

CREATE EXTENSION spat;

SELECT SPSET('key', 'value');
SELECT SPGET('key');              -- 'value'

-- With TTL
SELECT SPSET('temp', 'data', ttl => interval '5 minutes');

-- Store any type as text
SELECT SPSET('config', '{"a": 1}'::jsonb);
SELECT SPGET('config')::text::jsonb;

SELECT SADD('myset', 'elem1');
SELECT SADD('myset', 'elem2');
SELECT SISMEMBER('myset', 'elem1');  -- true
SELECT SCARD('myset');               -- 2
SELECT SREM('myset', 'elem1');       -- 1

SELECT LPUSH('mylist', 'a');
SELECT LPUSH('mylist', 'b');
SELECT LPOP('mylist');     -- 'b' (LIFO)
SELECT LLEN('mylist');     -- 1

SELECT HSET('myhash', 'field1', 'Hello');
SELECT HGET('myhash', 'field1');  -- 'Hello'

SELECT SPTYPE('key');           -- 'string', 'list', 'set', or 'hash'
SELECT DEL('key');              -- true if removed
SELECT TTL('key');              -- returns TTL interval
SELECT GETEXPIREAT('key');      -- returns expiration timestamp
SELECT SP_DB_NITEMS();          -- number of entries
SELECT SP_DB_SIZE();            -- human-friendly size

SET spat.db = 'db1';             -- switch to database 'db1'
SET spat.db = 'spat-default';   -- switch back to default