PostgreSQL Connector

The PostgreSQL data connector is a plugin for API Builder that can connect to your PostgreSQL database instance and interrogate your schema that will automatically provision Models into to your project, and optionally, automatically generate a rich CRUD API to the underlying tables. The Models can be used programmatically, or can be used within the flow editor to interact with your database.

Minimum requirements

Supported versions

• PostgreSQL 9.6
• Other versions might be supported as well, please create an issue if encounter any.

Memory

• ~7 MB

Disk space

• ~10 MB

Supported features

• Automatic generation of Models from SQL tables
• Automatic generation of API for Models
• Full CRUD operations on tables via Models
• Connection pooling

Installation

npm install --no-optional @axway-api-builder-ext/api-builder-plugin-dc-postgres

A configuration file is generated for you and placed into the conf directory of your API Builder project. The configuration for your PostgreSQL is expected to be in environment variables or in the conf/.env file during development.

Configuration

Once the plugin is installed, the configuration file is located <project>/conf/postgres.default.js.

| Option name | Type | Description | | ----------- | ---- | ----------- | | connector | string | Must be: @axway-api-builder-ext/api-builder-plugin-dc-postgres | | connectionPooling | boolean | boolean Enables connection pooling for better performance and scalability. | | connectionLimit | number | Number of simultaneous connections when connectionPooling is enabled. | | host | string | The database host. | | port | number | The database post. | | database | string | The database instance name. | | scheme | string | The schema within your database to use | | user | string | The user with which to connect to the database. | | password | string | The user's password with which to connect to the database. | | generateModelsFromSchema | boolean | If enabled, API Builder will automatically interrogate the database and auto-generate Models from SQL tables. | | modelAutogen | boolean | If enabled, API Builder will automatically generate a full and rich CRUD API from the generated Models. |

Usage

After you configure the connector, you can start up your API Builder project and visit the console (normally found under http://localhost:8080/console). Your connector will be listed under the Connectors section of the console.

Your database tables will be listed under the Models section of the console. You can now click on the gear icon to the right of the table names and generate flow based APIs.

You can also reference the connector in a custom model.

const Account = APIBuilder.Model.extend('Account', {
  fields: {
    Name: { type: String, required: true }
  },
  connector: 'postgres'
});

If you want to map a specific model to a specific table, use metadata. For example, to map the account model to the table named accounts, set it such as:

const Account = APIBuilder.Model.extend('account', {
  fields: {
    Name: { type: String, required: false, validator: /[a-zA-Z]{3,}/ }
  },
  connector: 'postgres',
  metadata: {
    'mysql': {
      table: 'accounts'
    }
  }
});

Known issues and limitations

1. Only supports SQL tables.
2. Does not support views.
3. Does not support stored procedures.

Contributing

Please read Contributing.md for details on our code of conduct, and the process for submitting pull requests to us.

Team

Axway Team