JavaScript in PostgreSQL pl/v8 – tutorial 4 – trigger functions

To write a trigger function in plv8 is much more convenient than in PL/pgSQL. Mainly because objects OLD and NEW are real objects containing also column names. And therefore you do not need to care about actual table structure. To send them to other variable you...

Javascript in PostgreSQL pl/v8 – tutorial 1 – overview

Extension pl/v8 contains 3 different flavors of JavaScript: PL/CoffeeScript (v8) trusted procedural language: enable in pq: CREATE EXTENSION plcoffee; PL/LiveScript (v8) trusted procedural language: CREATE EXTENSION plls; PL/JavaScript (v8) trusted procedural...

Install javascript pl/v8 extension on PostgreSQL on Ubuntu

Installation on Debian 9 + PostgreSQL 10 (5/2018): sudo apt-get install libv8-dev postgresql-10-plv8 in psql: create extension plv8   Installation on Ubuntu 14.04 (standard installation with “apt-get dist-upgrade”). There are several ways how to do...