Databases & System Design•Part 5: Real-Time Architecture, Replication & Scale (51 - 60)
Time-Series Databases (TimescaleDB, InfluxDB):
In Simple Words: Organize data into time-partitioned chunks ("hypertables"), optimizing high-volume sequential writes and compressing historical metrics.
sql
-- TimescaleDB Hypertable creation:
CREATE TABLE sensor_data (
time TIMESTAMPTZ NOT NULL,
sensor_id INT,
temperature DOUBLE PRECISION
);
SELECT create_hypertable('sensor_data', 'time');