PLV8 is a shared library that provides a PostgreSQL procedural language powered by V8 Javascript Engine. With this program you can write in Javascript your function that is callable from SQL.
Note that as PLV8 3.1, there are new build requirements.
The following packages must be installed to build on Ubuntu:
libtinfo5
build-essential
ninja-build
python3
pkg-config
The following packages must be install to build on MacOS:
XCode
- and the command line toolsbrew
llvm
- version 12 or higherninja
python3
=# CREATE EXTENSION plv8;
This will install PLV8 into your database if it exists as an extension.
To test, you can execute:
=# DO $$ plv8.elog(NOTICE, "hello there!"); $$ LANGUAGE plv8;
For full documentation, see https://plv8.github.io/.