PGCon2014 - Final Release

PGCon 2014
The PostgreSQL Conference

Chia-liang Kao
Day Talks - Day 2 - Fri May 23 - 2014-05-23
Room Morisset 256
Start time 14:00
Duration 00:45
ID 660
Event type Lecture
Track Advanced Features
Language used for presentation English


PostgreSQL, JavaScript, and REST

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