cryptint

pig build pkg cryptint;		# build rpm/deb

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

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

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

CREATE EXTENSION cryptint;

SELECT skip32_encrypt(42, '\x00010203040506070809'::bytea);
-- encrypted int4

SELECT skip32_decrypt(175586429, '\x00010203040506070809'::bytea);
-- 0

SELECT i, skip32_encrypt(i, '\x00010203040506070809'::bytea) AS encrypted,
       skip32_decrypt(skip32_encrypt(i, '\x00010203040506070809'::bytea), '\x00010203040506070809'::bytea) AS decrypted
FROM generate_series(-3, 3) AS i;

SELECT xtea_encrypt(42::bigint, '\x000102030405060708090a0b0c0d0e0f'::bytea);
-- encrypted bigint

SELECT xtea_decrypt(103200416458222088::bigint, '\x000102030405060708090a0b0c0d0e0f'::bytea);
-- 1