Package Exports

sails-postgresql

This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (sails-postgresql) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.

Readme

image_squidhome@2x.png

PostgreSQL Sails/Waterline Adapter

A Waterline adapter for PostgreSQL. May be used in a Sails app or anything using Waterline for the ORM.

Install

Install is through NPM.

$ npm install sails-postgresql

Configuration

The following config options are available along with their default values:

config: {
  database: 'databaseName',
  host: 'localhost',
  user: 'root',
  password: '',
  port: 5432,
  pool: false,
  ssl: false
};

Alternatively, you can supply the connection information in URL format:

config: {
  url: 'postgres://username:password@hostname:port/database',
  pool: false,
  ssl: false
};

Testing

Test are written with mocha. Integration tests are handled by the waterline-adapter-tests project, which tests adapter methods against the latest Waterline API.

To run tests:

$ npm test

About Waterline

Waterline is a new kind of storage and retrieval engine. It provides a uniform API for accessing stuff from different kinds of databases, protocols, and 3rd party APIs. That means you write the same code to get users, whether they live in mySQL, LDAP, MongoDB, or Facebook.

To learn more visit the project on GitHub at Waterline.