Postgres/TimescaleDB
Appearance
< Postgres
Setup
CREATE TABLE sensor_data (
time TIMESTAMPTZ NOT NULL,
location TEXT,
value DOUBLE PRECISION
);
SELECT create_hypertable('sensor_data', 'time');
CREATE TABLE sensor_data (
time TIMESTAMPTZ NOT NULL,
location TEXT,
value DOUBLE PRECISION
);
SELECT create_hypertable('sensor_data', 'time');