PostgreSQL Waterline 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]

A Waterline adapter for PostgreSQL, with PostGIS support.

This package was last updated in 2015. For the most up-to-date information and tools related to PostgreSQL and Waterline adapters in Sails, visit the official Sails website or ask for help.

Features

- 100% re-write of the original sails-postgresql adapter in ES6. And way faster.
- Uses knex.js for query building and connection pooling
- PostGIS 2.1+ Support

Compatibility

- Waterline v0.11 and later
- PostgreSQL 9.4 and later

Install

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

Configuration

#### config/connections.js

`js
module.exports.connections = {
// ...
postgresdb: {
/**
* This 'connection' object could also be a connection string
* e.g. 'postgresql://user:password@localhost:5432/databaseName?ssl=false'
*/
connection: {
database: 'databaseName',
host: 'localhost',
user: 'user',
password: 'password',
port: 5432,
ssl: false
},
/**
* Pool configuration
*/
pool: {
min: 2,
max: 20
}
}
}
``

License

MIT

Maintained By

[waterline-version-image]: https://goo.gl/goisO1
[waterline-url]: http://sailsjs.org
[npm-image]: https://img.shields.io/npm/v/waterline-postgresql.svg?style=flat
[npm-url]: https://npmjs.org/package/waterline-postgresql
[ci-image]: https://img.shields.io/travis/waterlinejs/postgresql-adapter/master.svg?style=flat
[ci-url]: https://travis-ci.org/waterlinejs/postgresql-adapter
[daviddm-image]: http://img.shields.io/david/waterlinejs/postgresql-adapter.svg?style=flat
[daviddm-url]: https://david-dm.org/waterlinejs/postgresql-adapter
[codeclimate-image]: https://img.shields.io/codeclimate/github/waterlinejs/postgresql-adapter.svg?style=flat
[codeclimate-url]: https://codeclimate.com/github/waterlinejs/postgresql-adapter