# sails-postgresql-prepquery

> a postgreSQL adapter for Waterline and Sails.js

Latest version **0.12.4** (published 2017-08-16) · MIT license · 0 weekly downloads

## Install

```sh
npm install sails-postgresql-prepquery
pnpm add sails-postgresql-prepquery
yarn add sails-postgresql-prepquery
bun add sails-postgresql-prepquery
```

## Health

**Score 15/100 (F)** — status: abandoned.

Positive: no vulnerabilities.

Warnings: low downloads; no types; no esm support; pre 1.0.

Negative: abandoned; low maintenance score.

## Facts

| | |
|---|---|
| Version | 0.12.4 |
| Published | 2017-08-16 |
| First published | 2017-04-28 |
| Weekly downloads | 0 |
| License | MIT |
| TypeScript types | none |
| Module format | CommonJS |
| Dependencies | 6 |
| Known vulnerabilities | 0 (+6 in 1 direct dependencies) |
| Install scripts | no |
| GitHub stars | 1 |
| Author | Cody Stoltman |
| Maintainers | mjasnikovs |
| Keywords | postgresql, orm, waterline, sails |

## Links

- npm: https://www.npmjs.com/package/sails-postgresql-prepquery
- Repository: https://github.com/mjasnikovs/sails-postgresql-prepquery
- Homepage: https://github.com/balderdashy/sails-postgresql#readme
- Issues: https://github.com/balderdashy/sails-postgresql/issues
- npm.io page: https://npm.io/package/sails-postgresql-prepquery

## Dependencies (6)

- [pg](https://npm.io/package/pg.md) 4.5.7
- [async](https://npm.io/package/async.md) 1.5.2
- [lodash](https://npm.io/package/lodash.md) 3.10.1
- [waterline-cursor](https://npm.io/package/waterline-cursor.md) 0.0.7
- [waterline-errors](https://npm.io/package/waterline-errors.md) 0.10.1
- [waterline-sequel](https://npm.io/package/waterline-sequel.md) 0.6.4

## Alternatives

- [mobx-react](https://npm.io/package/mobx-react.md) — 2.8M weekly downloads
- [rc-tree](https://npm.io/package/rc-tree.md) — 2.6M weekly downloads
- [@react-oauth/google](https://npm.io/package/@react-oauth/google.md) — 1.3M weekly downloads
- [@wagmi/connectors](https://npm.io/package/@wagmi/connectors.md) — 877.0K weekly downloads
- [vee-validate](https://npm.io/package/vee-validate.md) — 836.4K weekly downloads

## Recent versions

- 0.12.4 (latest) — 2017-08-16
- 0.12.3 — 2017-04-28
- 0.12.2 — 2017-04-28

## README

# 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,
```javascript
      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.

```bash
$ npm install sails-postgresql-prepquery
```

## Credits

To learn more visit the project on GitHub at [sails-postgresql](https://github.com/balderdashy/sails-postgresql).

---
_Source: https://npm.io/package/sails-postgresql-prepquery · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._