3 ms·
It's not correct to say that relational DBMS are not suitable for time series. ClickHouse is a relational DBMS, and it works for time series better than specia
by zX41ZdbW 3y ago
It's not correct to say that relational DBMS are not suitable for time series.
ClickHouse is a relational DBMS, and it works for time series better than specialized systems (like TimescaleDB or InfluxDB). You can quickly get trillions of records for time series, but it is not a problem. For example, see https://www.youtube.com/watch?v=JlcI2Vfz_uk https://www.youtube.com/watch?v=JlcI2Vfz_uk
If you try TimescaleDB in this scenario, it will barely be crawling.
PS. I am developer of ClickHouse, and I use it for these scenarios every time.
- tpetry 3y agoI guess it was just wrong names of the parent. He shared that OLTP databases are not good for the use-case but OLAP databases designed for analytical purposes like ClickHouse or Timescale are perfect for this. However, Timescale is not a real OLAP database - they are something in-between.
- osigurdson 3y agoWhen I say "Relational DB's aren't great for time series", I mean Postgres, MySQL, Oracle and SQL server just using traditional tables.
- osigurdson 3y agoI'm gonna try ClickHouse since you posted.