sails-postgresql-prepquery

PostgreSQL Sails/Waterline Adapter with PrepQuery

sails-postgresql v0.12.2 with prepQuery

prepQuery is used for performance optimization. x2 faster then raw query. millions times faster then sails adapter. Doh.... For personal usage.

example,

      User.prepQuery({
        text: `select * from users where id = $1`,
        type: ['int'],
        values: [clientSession.uid]
      },
      (err, result) => {
        if (err) {return cb(err)}
        if (!result.rowCount) {return cb(null, [])}
        return cb(null, result.rows)
      })

Install

Install is through NPM.

$ npm install sails-postgresql-prepquery

Credits

To learn more visit the project on GitHub at sails-postgresql.