Overview of PostgreSQL

PostgreSQL, commonly referred to as Postgres, is a free and open-source relational database management system known for its extensibility and SQL compliance. Integrating PostgreSQL with Naologic allows your application to interact with a powerful, reliable database for managing structured data, supporting SQL queries, and performing transactions.

With the PostgreSQL integration, you can:

• Store and Manage Data: Use PostgreSQL’s relational database capabilities for efficient data storage and retrieval.

• Run SQL Queries: Execute SQL commands to interact with and manage your data directly.

• Support Data-Driven Applications: Integrate structured data management and storage within your application.

Installing the PostgreSQL API in Naologic’s Builder

To set up the PostgreSQL API for your project, follow these steps:

1. Install the PostgreSQL API:

   • Go to your app's canvas.

   • Click on the plus sign on the left to open the element selection menu.

   • Navigate to the APIs section.

   • Search for "PostgreSQL" and press Install to add it to your project.

Connecting Naologic to Your PostgreSQL Database

To link Naologic with your PostgreSQL database, follow these steps:

1. Access Integration Settings:

   • Navigate to the top right of the Workspace and click on the cog icon (Settings).

   • Select Integrations from the settings menu.

2. Connect to PostgreSQL:

   • In the Integrations menu, find PostgreSQL and click Connect.

   • Enter the following information from your PostgreSQL database:

     • Host: The host address for your PostgreSQL database server.

     • Username: Your PostgreSQL username.

     • Password: Your PostgreSQL password.

     • Port: The port number (default is 5432).

     • Database: The name of the specific PostgreSQL database you wish to connect to.

   • Once all required fields are filled, click Connect to establish the connection between Naologic and your PostgreSQL database.

Using PostgreSQL within Your Application

Since PostgreSQL does not have a dedicated action within Naologic, it can be used as a backend database for various custom functions or embedded into existing workflows.
For specific setups or complex configurations, such as integrating PostgreSQL with data visualizations or analytics, you might consider reaching out to our support team for additional guidance.