plv8

pig build get plv8; # get plv8 source code
pig build dep plv8; # install build dependencies
pig build pkg plv8; # build extension rpm or deb
pig build ext plv8; # build extension rpms

pig repo add pgsql -u   # add PGDG + Pigsty repo and update cache (leave existing repos)

pig ext install plv8; # install by extension name, for the current active PG version
pig ext install plv8; # install via package alias, for the active PG version
pig ext install plv8 -v 18;   # install for PG 18
pig ext install plv8 -v 17;   # install for PG 17
pig ext install plv8 -v 16;   # install for PG 16
pig ext install plv8 -v 15;   # install for PG 15
pig ext install plv8 -v 14;   # install for PG 14
pig ext install plv8 -v 13;   # install for PG 13

CREATE EXTENSION plv8 CASCADE SCHEMA pg_catalog;

CREATE EXTENSION plv8;

SELECT plv8_version();
SELECT plv8_info();

DO $$ plv8.elog(NOTICE, plv8.version); $$ LANGUAGE plv8;

CREATE FUNCTION plv8_test(keys TEXT[], vals TEXT[]) RETURNS JSON AS $$
    var o = {};
    for(var i=0; i<keys.length; i++){
        o[keys[i]] = vals[i];
    }
    return o;
$$ LANGUAGE plv8 IMMUTABLE STRICT;


SELECT plv8_test(ARRAY['name', 'age'], ARRAY['Tom', '29']);