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, add the following IP addresses to the Firewall whitelist:

23.99.134.30
40.122.170.142
104.43.136.75
104.43.140.0
23.99.128.183

Configuration

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

How to connect PostgreSQL

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.

Usage

Once you have a connection between UI Bakery and PostgreSQL, you can access its data, load and send it back.

  1. Create an Action using one of the following types to access your data:

    • Load Table

    • Load Row

    • Create Row

    • Update Row

    • Delete Row

    • SQL Query

  2. Configure it. Select a proper Table, set filters, and other settings or write a SQL query.

  3. Run it. Take a look at the Results tab to make sure the data is loaded.

Loading table data