redis_fdw

pig build pkg redis_fdw;		# build rpm/deb

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

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

pig install redis_fdw -v 18;   # install for PG 18
pig install redis_fdw -v 17;   # install for PG 17
pig install redis_fdw -v 16;   # install for PG 16
pig install redis_fdw -v 15;   # install for PG 15
pig install redis_fdw -v 14;   # install for PG 14

CREATE EXTENSION redis_fdw;

CREATE EXTENSION redis_fdw;

CREATE SERVER redis_server FOREIGN DATA WRAPPER redis_fdw
  OPTIONS (address '127.0.0.1', port '6379');

CREATE USER MAPPING FOR pguser SERVER redis_server
  OPTIONS (password 'secret');

CREATE FOREIGN TABLE redis_db0 (
  key text,
  val text
)
SERVER redis_server
OPTIONS (database '0');

SELECT * FROM redis_db0;

CREATE FOREIGN TABLE redis_hash (
  key text,
  val text[]
)
SERVER redis_server
OPTIONS (database '0', tabletype 'hash', tablekeyprefix 'mytable:');

INSERT INTO redis_hash VALUES ('mytable:r1', '{prop1,val1,prop2,val2}');
UPDATE redis_hash SET val = '{prop3,val3}' WHERE key = 'mytable:r1';
DELETE FROM redis_hash WHERE key = 'mytable:r1';
SELECT * FROM redis_hash;

CREATE FOREIGN TABLE redis_singleton (
  key text,
  val text
)
SERVER redis_server
OPTIONS (database '0', tabletype 'hash', singleton_key 'myhash');

INSERT INTO redis_singleton VALUES ('field1', 'value1');
UPDATE redis_singleton SET val = 'newvalue' WHERE key = 'field1';
DELETE FROM redis_singleton WHERE key = 'field1';