skipper-postgreql adapter

[![NPM version][npm-image]][npm-url]
[![Build status][ci-image]][ci-url]
[![Dependency Status][daviddm-image]][daviddm-url]
[![Code Climate][codeclimate-image]][codeclimate-url]

Streaming Uploads/Downloads using Sails.js and PostgreSQL.

Install

``sh $ npm install skipper-postgresql --save`

`Usage`

#### config/skipper.js`js module.exports.skipper = { adapter: require('skipper-postgresql'), connection: { host: 'localhost', user: 'postgres', password: 'postgres' },

/** * OR * connection: 'postgres://postgres:postgres@localhost:5432/postgres' */

/** * table to store files in */ fileTable: 'file' }`

#### api/controllers/FileController.js`js module.exports = { upload: function (req, res) { req.file('upload').upload(sails.config.skipper, function (err, files) { if (err) return res.negotiate(err);

res.ok(files) }) }, download: function (req, res) { var SkipperAdapter = sails.config.skipper.adapter; SkipperAdapter(sails.config.skipper).read(req.param('fd'), function (err, file) { if (err) return res.negotiate(err);

res.send(new Buffer(file)) }) } }``

License

MIT

Maintained By

[npm-image]: https://img.shields.io/npm/v/skipper-postgresql.svg?style=flat-square
[npm-url]: https://npmjs.org/package/skipper-postgresql
[ci-image]: https://img.shields.io/travis/skipperjs/skipper-postgresql/master.svg?style=flat-square
[ci-url]: https://travis-ci.org/skipperjs/skipper-postgresql
[daviddm-image]: http://img.shields.io/david/skipperjs/skipper-postgresql.svg?style=flat-square
[daviddm-url]: https://david-dm.org/skipperjs/skipper-postgresql
[codeclimate-image]: https://img.shields.io/codeclimate/github/skipperjs/skipper-postgresql.svg?style=flat-square
[codeclimate-url]: https://codeclimate.com/github/skipperjs/skipper-postgresql

Usage

#### config/skipper.js

js
module.exports.skipper = {
  adapter: require('skipper-postgresql'),
  connection: {
    host: 'localhost',
    user: 'postgres',
    password: 'postgres'
  },

  /**
   * OR
   *
  connection: 'postgres://postgres:postgres@localhost:5432/postgres'
   */

   /**
    * table to store files in
    */
   fileTable: 'file'
}

#### api/controllers/FileController.js

js
module.exports = {
  upload: function (req, res) {
    req.file('upload').upload(sails.config.skipper, function (err, files) {
      if (err) return res.negotiate(err);

      res.ok(files)
    })
  },
  download: function (req, res) {
    var SkipperAdapter = sails.config.skipper.adapter;
    SkipperAdapter(sails.config.skipper).read(req.param('fd'), function (err, file) {
      if (err) return res.negotiate(err);

      res.send(new Buffer(file))
    })
  }
}

Maintained By