The Database Zoo: Inside Time-Series Engines (InfluxDB, Prometheus, Timescale)

Time-Series Databases (TSDBs) are purpose-built for continuous, high-volume, time-ordered data. They optimize writes with append-only layouts and time partitioning, speed queries via time-first indexing and compression-aware scans, and control storage with retention and downsampling. Engines like InfluxDB, TimescaleDB, Prometheus, and VictoriaMetrics embody these design choices differently. Use a TSDB when you need massive ingest, time-range analytics, and efficient storage—especially for monitoring, IoT, telemetry, and financial ticks—rather than stretching general-purpose SQL/NoSQL beyond their comfort zone.