Linux/TimescaleDB

Setup

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

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