home ¦ Archives ¦ Atom ¦ RSS

plv8

Given I’m aware of Python as an embedded procedural language in PostgreSQL, I should have anticipated that someone would stuff JavaScript into PGSQL. Enter plv8:

plv8 is shared library that provides a PostgreSQL procedual language powered by V8 JavaScript Engine. With this program you can write in JavaScript your function that is callable from SQL.

In the context of PostgreSQL, this means you have a surprisingly useful durable document store you didn’t know you had. The previous link focuses on XML in Postgres, but with plv8 there are plenty of JSON tricks you can do inside a sophisticated relational data management system.

Don’t know how mature plv8 is, but I have a few big piles of Tweet data in JSON format that might be subject to the extension’s charms.

Hat tip to Hacker News

© 2008-2024 C. Ross Jam. Built using Pelican. Theme based upon Giulio Fidente’s original svbhack, and slightly modified by crossjam.