March SF Meeting: Serving a RESTful API from PostgreSQL

Serving a RESTful API from PostgreSQL

https://github.com/begriffs/postgrest

Web frameworks commonly treat the database as a dumb store, using only the minimal features common to several databases. What would it be like to design a RESTful API server that takes full advantage of Postgres in particular? Joe Nelson will demonstrate PostgREST, a server which does just that and turns any PostgreSQL database into an API.

Learn how database features support web server functionality:

• Data embedding data through foreign keys

• Versioning through the schema search path

• Authorization through roles and row security

• Direct payload encoding with JSON functions

• External actions with NOTIFY

• Self-documentation through system catalogs

• Accessing web request details via SQL run-time parameters