Back to Workflows

Generate and insert data into a Postgres database

Apps in this workflow

Postgres

Share

Details

Created 3 years ago by tanay1337
eye 284 views
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);

Implement complex processes faster with n8n

red icon yellow icon red icon yellow icon