I'm building a real-time monitoring system for metrics of servers in Rust !

• TimescaleDB

  82 16,472 9.8 C

  An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.

  

I could have used a time series oriented database, but I preferred to use Postgres for its stability. Postgres can be very fast, even for time series data. I automatically partition the tables by date using Partman, which allows for faster reading and very little overhead when inserting. But if performance starts to be a problem because of Postgres, there is always https://www.timescale.com. A standard Postgres instance can be turned into a timescaleDB and the Speculare server will need very few changes.

• ClickHouse

  208 34,269 10.0 C++

  ClickHouse® is a free analytics DBMS for big data

  

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

Suggest a related project