Linux/TimescaleDB: Difference between revisions

From Wiki
mNo edit summary
mNo edit summary
Line 12: Line 12:
</pre>
</pre>


== Insert data vis Node-RED ==
== Insert data via Node-RED ==
<pre>
<pre>
INSERT INTO sensor_data (time, topic, value)
INSERT INTO sensor_data (time, topic, value)

Revision as of 15:08, 28 September 2024

Setup

CREATE TABLE sensor_data (
        time TIMESTAMPTZ NOT NULL,
        topic TEXT,
        value DOUBLE PRECISION
);
SELECT create_hypertable('sensor_data', 'time');

Insert data via Node-RED

INSERT INTO sensor_data (time, topic, value)
VALUES (
    now(),
    '{{{ msg.topic }}}',
    '{{{ msg.payload }}}'
);