postgrest-request

Postgres-request

Providing a interface to query a postgrest instance.

Installation

npm install postgrest-request

Usage

postgrest-request wraps the functionality of superagent. Therefore the query syntax is identical. 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);
  });

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

License

MIT