Can plv8 extend JavaScript to third-party libraries?

Question

In Postgresql, I want to call third-party libraries, such as instant.js or AWS lambda JS Client, to call serverless functions from the database. I do not see any documents or examples of how to do this:   https://github.com/plv8/plv8/blob/master/README.md

Is this possible, and where can I find examples of how to “import” or “require” additional libraries?

Answer 1

The plv8 language is trusted, so there is no way to download anything from the file system. However, you can load modules from the database.

, select eval(). , :

create table js_modules (
    name text primary key,
    source text
);

insert into js_modules values
('test', 'function test() { return "this is a test"; }' );

js_modules :

create or replace function my_function()
returns text language plv8 as $$
//  load module 'test' from the table js_modules
    var res = plv8.execute("select source from js_modules where name = 'test'");
    eval(res[0].source);
//  now the function test() is defined
    return test();
$$;

select my_function();

CREATE FUNCTION
  my_function   
----------------
 this is a test
(1 row) 

require() : PL/v8. , plv8.start_proc (. ).

Answer 2

, :

• PLV8 Amazon RDS PosgreSQL. RDS - , . PostgreSQL:

  TRUSTED , , .

  PLV8 , ( ) , HTTP, , (, , RDS ).

• PLV8 - - PostgreSQL Lucio Grenzi.

  # 10:

  PLV8:

    [...]

  • .

---

PLPERLu (u ) . , use . PERL, PostgreSQL ( CREATE LANGUAGE).