Time-Series Database
ELI5 — The Vibe Check
A time-series database is laser-focused on data that happens over time. Temperature readings, stock prices, server CPU usage, your heart rate, whatever. It's insanely fast at answering 'what happened between Tuesday and Thursday' and can compress mountains of timestamps into tiny files.
Real Talk
A time-series database (TSDB) is optimized for ingesting, storing, and querying timestamped data points. Key features include high write throughput, efficient time-range queries, automatic downsampling, retention policies, and specialized compression algorithms. Data is typically append-only and immutable once written.
When You'll Hear This
"We need a time-series database for our IoT sensor data." / "Postgres can do time-series but a dedicated TSDB handles the scale better."
Related Terms
Columnar Storage
Columnar storage saves data column by column instead of row by row. All the ages together, all the names together, all the emails together.
Data Warehouse
A data warehouse is where all your company's data goes to be analyzed.
InfluxDB
InfluxDB is obsessed with time. It's built specifically for data that comes with a timestamp, like server metrics, sensor readings, or how many times you r...
OLAP
OLAP is all about analyzing huge amounts of data to answer business questions. 'What were total sales by region last quarter?' That's an OLAP query.