PostgREST

NOTE: This is an sgr-specific article. To learn how to use Splitgraph with PostgREST, see the corresponding Splitgraph page.

Since a sgr engine is also a PostgreSQL database, tools that use PostgreSQL can work with Splitgraph tables without any changes.

One such tool is PostgREST that generates a REST API for a PostgreSQL schema. We also run PostgREST in Splitgraph, allowing access to any Splitgraph dataset via HTTP.

You can reproduce a similar setup locally, getting PostgREST to work against a Splitgraph image.

PostgREST example