PostgreSQL

UI Bakery allows you to easily connect to a PostgreSQL database with no need for additional layers like APIs and 3rd-party services.

Prerequisites

If your database is hosted behind a Firewall, you need to add our IP addresses to the Firewall whitelist.

Configuration

Go to Data sources page –> Connect –> Choose PostgreSQL. Enter your credentials and click Test connection.

If the connection is successful, click Connect Data source. UI Bakery will extract the database structure and store column types. This data will be used to suggest proper table columns and form field types.

If you need to be able to override the default data source database with a custom value in an action, you can enable the setting Allow override database name in action:

Once enabled, when configuring the action, you will be able to specify the custom database:

In case a database is not specified, the default data source database will be used.

Usage

Once you have a connection between UI Bakery and PostgreSQL, you can access its data, load and send it back. Below are listed the supported action types:

• Load Table;
• Load Row;
• Create Row;
• Update Row;
• Delete Row;
• SQL Query.

Connecting Postgre via Bit.io

If you are connecting Postgre via bit.io, please take these details into consideration:

- check out the details that need to be specified when you are connecting via bit.io

- please make sure to specify your repository's name in the field Schemas name. Make sure to click ADD to save it - otherwise, it will throw an error.