π¨ Integrations
PostgreSQL in Illa is a database integration that allows you to connect and interact with a PostgreSQL database. PostgreSQL is a popular open-source relational database management system that is known for its stability, reliability, and powerful features.
With the PostgreSQL integration in Illa, you can query, insert, update, and delete data from a PostgreSQL database using SQL commands. You can also create custom SQL queries and run them within Illa action. This makes it easy to build data-driven applications and dashboards that display real-time data from a PostgreSQL database.
There are two ways to create a resource in Illa after signing into your Illa account.
Sign into your Illa account, select **Resources**
on the top of the page, and click **Create New**
button.
Select PostgreSQL
from the database list.
Connect to the database with required parameters described in Connection Settings
below.
Click **Test Connection**
to see if we can successfully connect to the database. If yes, click Save Resources
, else, double check the hostname, port, username, and password is correct.
After creating a resource, the ready PostgreSQL will display as shown.
Sign into your Illa account, create a project in Illa Builder in the **App**
page, and navigate to the Action List
at the bottom of the page. Click **new**
, then select PostgreSQL
from the database list. Then, connect to the database with required parameters described in Connection Settings
below.
Click **Test Connection**
to see if we can successfully connect to the database. If yes, click Save Resources
, else, double check the hostname, port, username, and password is correct.
Here we need to provide information for connecting to PostgreSQL database.
Properties | Required | Description |
---|---|---|
Name | required | The name for resource when creating actions in the ILLA. |
Hostname | required | The URL or IP address for your database |
Port | required | The server hostβs port number that you should use to connect. If you donβt specify a port, default port is β5432β. |
Database | required | The name of the database |
Username | required | the username you wish to use when logging in to the PostgreSQL server. |
Password | required | Use this password for authentication. |
SSL options | optional | decides how high a secure SSL TCP/IP connection is prioritized while negotiating with the server. |
We have created a PostgreSQL resource, we can add the action by selecting PostgreSQL from action list and choosing the Create action
button.
Now we have added the PostgreSQL server as an action to our building page.
Properties | Description |
---|---|
SQL query | sql commands to fetch (select), insert, update, delete data from database |
Transformer | transforming data into the style you like using JavaScript |
Example usage:
SELECT * FROM users ORDER BY lastname;
INSERT INTO users
(firstname, lastname, email)
VALUES
(
{{ NewUser.data.firstNameInput }},
{{ NewUser.data.lastNameInput }},
{{ NewUser.data.emailInput }}
);
UPDATE users
SET firstname = '{{form1.updatedProfile.first}}'
WHERE id = {{ form1.updatedProfile.uid}};
DELETE FROM users WHERE id = {{ form1.updatedProfile.uid }};