Manati

REST API for PostgreSQL. Forget ORM!

Warning

This is still in heavy development and some functionality might change. Be careful when you do an update.

Usage

var manati = require('pg-manati');
var app = manati(
  process.env.DATABASE_URL // your database connection string
);

// Manati uses KoaJS, if you want to extend it to your needs you can use (see http://koajs.com/ for more info)
app.koa.use(function* (next) {
  // add whatever code you want, will be executed first
  yield next;
});

// add authentication routes to the list
app.addPlugin('authentication'));

// add authentication middleware for all routes in the data router (route starting with /data)
app.addPlugin('authorization'), 'data');

if (process.argv[2] === '--setup') {
  app.setup().then(() => {
    console.log('Installation successfull');
    process.exit(0);
  })
}

// this will execute the setup script on every start up, you can choose
app.init({
  logLevel: 'fatal'|'error'|'warn'|'info'|'debug'| // the log level used by the bunyan logger (default 'info'), see https://github.com/trentm/node-bunyan for more info
  logRequest: true|false // whether to log request, using INFO logging level
  logStreams: [] // an array of log streams, see https://github.com/trentm/node-bunyan for more information
});
app.start(3000);

Check our wiki for more information!

Example

Get some users data

GET /data/users?limit=2&name=like::J*

[{"name": "John", "age": 22}, {"name": "Jessie", "age": 30}]

Count some users data

GET /data/count/users/name?name=like::J*

{"count":"2"}

Update some users data

PATCH /data/users?name=eq::Jessie
Content-Type application/json
{
  "age": 23
}

[{"name": "John", "age": 22}, {"name": "Jessie", "age": 23}]

Create some new data

POST /data/users
Content-Type application/json
{
  "name": "Joe",
  "age": 21
}

[{"name": "Joe", "age": 21}]

Delete some users data

DELETE /data/users?name=eq::John

[{"name": "John", "age": 22}]