loopback-component-storage-postgres v1.1.3

loopback-component-storage-postgres

LoopBack storage postgres component provides Node.js and REST APIs to manage binary contents using Postgres Large Object

Installation

Install the storage component as usual for a Node package:

  npm install --save loopback-component-storage-postgres

Using it

Create a table to store file descriptions

  CREATE TABLE "my-tabe-to-store-files" (
    id SERIAL PRIMARY KEY,
    container TEXT NOT NULL,
    filename TEXT NOT NULL,
    mimetype TEXT,
    objectid INTEGER UNIQUE NOT NULL
  );

Edit you datasources.json and add the following part

"pg_file": {
  "name": "pg_file",
  "connector": "loopback-component-storage-postgres",
  "host": "localhost",
  "port": 5432,
  "database": "test",
  "table": "my-table-to-store-files",
  "username": "test-user",
  "password": "test-password"
}

And the you can use it as a datasource of your model.

API