postgresNode
Jump to:
About
This app or node is designed to facilitate interaction with a PostgreSQL database by enabling data syncing and retrieval processes. It works within the Lamatic.ai platform, allowing users to fetch all or new rows from specified tables at regular intervals. Although it doesn't support triggering actions like creating or reading rows, it offers configuration options for sync mode and schedule. This setup is particularly beneficial for users looking to integrate PostgreSQL data into their workflows seamlessly, enhancing data accessibility and management.
What can you make?
- Automate data synchronization from a PostgreSQL database to ensure real-time updates in your applications.
- Integrate PostgreSQL data into business intelligence tools for enhanced reporting and analytics.
- Enable seamless data transfer and management in workflow automation platforms.
- Build a data pipeline that regularly fetches and processes new database entries for machine learning models.
Available Functionality
Sync
✅ Fetch all rows regular interval
✅ Fetch new rows regular interval
Trigger
❌ When a new row is created
❌ When a row is updated
❌ When a new table/view is created
❌ When a new row is created
❌ When a row is deleted
Actions
❌ Create rows in a table
❌ Create a new table
❌ Read a table
❌ Read a row
Install Steps
- Drag node to the workflow
- Click on Add new Credentials
- Follow the Install Steps
- Once added choose the new credentials
Configuration
- Name - Display Name for the Node
- Credentials - Postgres Credentials to be used for this setup
- Schemas - Select Schema that you want to Sync
- Tables/Views - Which Tables you want to Sync
- Additional Properties -
- Sync Mode - Choose between incremental or full refresh
- Sync Schedule - Setup Interval for fetch
LowCode Config
# Explanation of Trigger Section
triggerNode:
nodeId: "Unique identifier for the Postgres node, here it's 'postgresNode_2'."
nodeType: "Type of the node, which is a Postgres node used for interacting with a PostgreSQL database."
nodeName: "Name of the node for identification, here it's labeled as 'Postgres'."
values:
tables: "The specific table in the PostgreSQL database to be accessed or synced, in this case 'materialized_passagesintroduction'."
schemas: "The schema within the PostgreSQL database where the table is located, here it's 'public'."
syncMode: "Specifies how the data will sync, in this case 'incremental_append', meaning new data will be appended without overwriting existing data."
credentials: "The credentials used to access the PostgreSQL database, labeled as '84000 Production'."
cronExpression: "A cron expression defining the schedule for the sync operation, here '0 0 0/1 1/1 * ? * UTC', which means the sync runs every hour in UTC time."Example Workflow Setup
Output
// Sync Trigger
{
"title": "your_title",
"work_xmlid": "your_work_xmlid",
"restriction": false,
"publication_date": "your_publication_date",
"work_type": ["your_work_type"],
"toh": "your_toh",
"passage_xmlid": "your_passage_xmlid",
"passage_content": "your_passage_content",
"passage_type": "your_passage_type",
"passage_label": "your_passage_label",
"passage_parent": "your_passage_parent",
"sort": "your_sort_value"
}