winsan-zhang/plv8

V8 Engine Javascript Procedural Language add-on for PostgreSQL

PL/v8 - A Procedural Language in JavaScript powered by V8

PL/v8 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.

Documentation

The documentation covers the following implemented features:

• Requirements
• Installing PL/v8
• Install the PL/v8 Extensions on a Database
• Scalar function calls
• Set returing function calls
• Trigger function calls
• Inline statement calls
• Auto mapping between JS and database built-in types
• Database access via SPI including prepared statements and cursors
• Subtransaction
• Utility functions
• Window function API
• Typed array
• ES6 Language Features
• Remote debugger
• Runtime environment separation across users in the same session
• Start-up procedure
• Update procedure
• Dialects

Notes:

PL/v8 is hosted on github at: https://github.com/plv8/plv8

PL/v8 is distributed by PGXN. For more detail, see: http://pgxn.org/dist/plv8/doc/plv8.html