1-13 of 13 found
PLV8
elog(NOTICE, plv8.version); $$ LANGUAGE plv8; Updating PLV8 As of PLV8 version 2.3.3, you can use upgrade scripts to upgrade your installation from any version higher than 1.5.
PLV8 Built-ins
find_function("callee"); return func(a); $$ LANGUAGE plv8; With plv8.find_function(), you can look up other PLV8 functions. If they are not a PLV8 function, and error is thrown.
PLV8 - A Procedural Language in Javascript powered by V8
elog(NOTICE, "hello there!"); $$ LANGUAGE plv8; For full documentation, see https://plv8.github.io/.
Runtime Configuration
start_proc|PLV8 function to run once when PLV8 is first used|none| |plv8.icu_data|ICU data file directory (when compiled with ICU support)|none| |plv8.v8_flags|V8 engine initialization flags (e.g.
Docker
Docker While PLV8 does not currently provide docker images, we do have a Dockerfile which is currently able to build PLV8 in top of an official PostgreSQL image.
External Utilities
… input and writes SQL file(s) containing Postgres functions using PLV8. For more information see the project readme. Equinox equinox allows for database level unit testing via PLV8.
Function Calls
Function Calls PLV8 has the ability to execute multiple types of function calls inside of PostgreSQL. Scalar Function Calls In PLV8, you can write your invoked function call in Javascript, using the…
Building
com/plv8/plv8/archive/v3.0.0.tar.gz $ tar -xvzf v3.0.0.tar.gz $ cd plv8-3.0.0 $ make Building Building is simple: $ make This will download v8 and compile it as well.
PL/v8
..]) plv8.quote_literal(str) plv8.nullable(str) plv8.quote_ident(str) plv8.versionplv8.elog plv8.elog emits message to the client or the log file.
Contributed files
Copy one of the files, depending on your platform, and set the plv8.icu_data variable in postgresql.conf. icudtl.dat - Little Endian architectures (Intel) icudtb.
Building for Windows
The name will depend on the version of PLV8 and the version of Postgres. An example is plv8-2.3.1-postgresql-10-x64.zip. TODO Generate configuration files Generate control files Generate sql files
Building for Windows
The name will depend on the version of PLV8 and the version of Postgres. An example is plv8-3.0.0-postgresql-10-x64.zip. TODO Generate configuration files Generate control files Generate sql files
Changelog.rst
… in children tables (#102) Handle external languages like plv8 correctly (#97) Correct quoting of mixed case constraint names (#83) Avoid problems with certain complex index definitions (#98) Have…