Speaker Deck

PgREST @ PGCON: PostgreSQL, JavaScript, and REST

by Chia-liang Kao

Published May 23, 2014 in Technology


PgREST turns PostgreSQL into a RESTful JSON document store, allows running JavaScript and npm modules as stored procedures for queries and triggers from within the database. It also provides Firebase-compatible API for developing real-time applications.

PgREST is...

a JSON document store
running inside PostgreSQL
working with existing relational data
capable of loading Node.js modules
compatible with MongoLab's REST API
and Firebase's real-time API
This talk will cover:

the building blocks of PgREST: PostgreSQL, plv8js, plv8x
examples for turning existing relational data into REST endpoints
building real-time applications with PgREST