postgres-request

Providing a node interface to query a postgrest instance.

Installation

npm install postgrest-request

Usage

postgrest-request wraps the functionality of superagent and provides the same chaining syntax. Full documentation for building queries is available from superagent.

The following code segment queries https://postgrest.herokuapp.com/festival

var config = {
  host: 'postgrest.herokuapp.com',
  method: 'https',
  post: 443
};
var postgrest = require('postgrest-request')(config);

postgrest.get('/festival')
  .end(function (err, data ) {
    console.log(err, data.body);
  });

The following features from postgrest have been implemented:

• filtering
• versioning

Filtering

The request can be filtered using the .where() option. The following code snippet gets all festivals with a rating greater than 7.

postgrest.get('/festival')
  .where({
    gt: {
      rating: 7
    }
  })
  .end(function (err, data ) {
    console.log(err, data.body);
  });

See https://github.com/begriffs/postgrest/wiki/Routing#filtering for filtering options

Versioning

A particular version of the API can be requested by chaining a call to version(versionNumber) where version number is a positive number. This will set the accept header of the request to the required version as an integer and by default version 1 of the API is requested. Calls to the superagent function accept will be ignored as postgrest always returns JSON and ignores the requested application type. Examples for implementing schemas with versioning is available here

License

MIT