@clearroad/api-storage-postgresql NPM

ClearRoad API Storage PostgreSQL

Note: 5 databases will be created to store the data, all prefixed with the database value (see below). Make sure you use credentials that have the rights to create databases.

Install

npm install @clearroad/api-storage-postgresql

Usage

Import the library:
Using with es6 / TypeScript

import { ClearRoad } from '@clearroad/api';
import storage from '@clearroad/api-storage-postgresql';

Using with require

const ClearRoad = require('@clearroad/api').ClearRoad;
const storage = require('@clearroad/api-storage-postgresql').default;

Create a ClearRoad instance:

const options = {
  localStorage: {
    type: storage,
    host: 'host.com',
    user: 'user',
    password: 'passowrd',
    database: 'MyDatabase'
  }
};
const cr = new ClearRoad('url', 'accessToken', options);

Options

Property	Type	Description	Required
localStorage.type	`string`	Connector type. Use `postgresql`	Yes
localStorage.host	`string`	Database host	Yes
localStorage.user	`string`	Database user	Yes
localStorage.password	`string`	Database password	Yes
localStorage.database	`string`	Database name	Yes
localStorage.documentsTableName	`string`	Database table name to storage all documents. Default is `documents`	No
localStorage.attachmentsTableName	`string`	Database table name to storage all attachments. Default is `attachments`	No
localStorage.timestamps	`boolean`	Add `createdAt` and `updateAt` fields on each row. Default is `true`	No