Help with timeseries data

This page summarizes the projects mentioned and recommended in the original post on /r/Database
time-series-database Postgresql time-series SQL Postgres

InfluxDB - 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.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured

  • TimescaleDB

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

    • TimescaleDB is Postgres with extensions to automatically partition tables for fast processing of time series data.

  • ticktock

    TickTockDB is an OpenTSDB-like time series database, with much better performance.

    • TickTockDB is a new open-src TSDB. Although it is not rich in features, its write throughput can reach 3.2M data points/sec v.s. InfluxDB 74K in a 2c4g x86 (detail report here). It is enough for your case (79M data point/day = 914/sec). You may also have to consider max cardinality (i.e., number of time series supported) of TSDB. TickTockDB's max cardinality is 2M v.s. InfluxDB 150k in RaspberryPI4 (detail report here)).

  • InfluxDB

    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.

    InfluxDB logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • TimescaleDB: An open-source time-series SQL database

    1 project | news.ycombinator.com | 6 Feb 2024

  • How to setup Postgres master-master cluster.

    1 project | /r/sysadmin | 5 Sep 2023

  • Why does the presence of a large write-only table in a PostgreSQL database cause severe performance degradation?

    1 project | /r/PostgreSQL | 2 Jul 2023

  • I have to do about a million inserts on a table every day that is also under very frequent reads. How should I do that?

    1 project | /r/PostgreSQL | 20 May 2023

  • Postgres for time-series data

    1 project | news.ycombinator.com | 2 May 2023