⚒️ Generate and insert data into a Postgres database
⚡ 6,902 views · ⚒️ Engineering
Description
This is Workflow 1 in the blog tutorial Database activity monitoring and alerting.
Prerequisites
- A Postgres database set up and credentials.
- Basic knowledge of JavaScript and SQL.
Nodes
- Cron node starts the workflow every minute.
- Function node generates sensor data (sensor id (preset), a randomly generated value, timestamp, and notification (preset as false) )
- Postgres node inserts the data into a Postgres database. You can create the database for this workflow with the following SQL statement:
CREATE TABLE n8n (id SERIAL, sensor_id VARCHAR, value INT, time_stamp TIMESTAMP, notification BOOLEAN);🔗 Nodes Used
Cron, Function, Postgres
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File