Data insertion and update in TimescaleDB

• Automate data entry for environmental monitoring systems.
• Update location data for IoT devices in real-time.
• Perform batch updates and cleanups in TimescaleDB databases.

Starts the workflow with a trigger node. Generates random temperature data and current timestamp. Inserts generated data into the TimescaleDB 'conditions' table. Executes a query to retrieve data based on the timestamp. Updates the location of the retrieved data. Deletes all entries from the 'conditions' table for cleanup.

1. 1
   Import the workflow template into your n8n instance.
2. 2
   Configure TimescaleDB credentials in the workflow settings.
3. 3
   Run the workflow to initiate data insertion and updates.