Linux/TimescaleDB

Setup

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

SELECT create_hypertable('sensor_data', 'time');

Insert data

INSERT INTO sensor_data (time, topic, value)
VALUES (
    now(),
    '',
    ''
);