pg_timeseries: Open-source time-series extension for PostgreSQL

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

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.

    What do you mean by "for anything serious it isn't open source"? I didn't see any red flags in the apache variant of timescale, just constant pleading to try their hosted option.

    https://github.com/timescale/timescaledb/blob/main/LICENSE-A...

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
  • pg_ivm

    IVM (Incremental View Maintenance) implementation as a PostgreSQL extension

    Looking at their roadmap, the killer feature for me would be incremental materialised views

    > Incremental view maintenance — define views which stay up-to-date with incoming data without the performance hit of a REFRESH

    I wonder if they plan to incorporate something like https://github.com/sraoss/pg_ivm or write their own implementation.

    (Although I'm hopeful that one day we see ivm land in postgres core)

  • tsbs

    Time Series Benchmark Suite, a tool for comparing and evaluating databases for time series data

    AFAIK https://github.com/timescale/tsbs is based on artificial data and I would recommend running benchmarks and comparisons on real data from node_exporter, like https://github.com/VictoriaMetrics/prometheus-benchmark.

  • prometheus-benchmark

    Benchmark for Prometheus-compatible systems

    AFAIK https://github.com/timescale/tsbs is based on artificial data and I would recommend running benchmarks and comparisons on real data from node_exporter, like https://github.com/VictoriaMetrics/prometheus-benchmark.

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

  • Show HN: QuestDB with Python, Pandas and SQL in a Jupyter notebook – no install

    3 projects | news.ycombinator.com | 21 Feb 2023
  • How we achieved write speeds of 1.4 million rows per second

    3 projects | dev.to | 21 May 2021
  • How we achieved write speeds of 1.4 million rows per second

    3 projects | /r/programming | 12 May 2021
  • Building a new vector based storage model

    2 projects | news.ycombinator.com | 11 May 2021
  • TimescaleDB Raises $40M

    7 projects | news.ycombinator.com | 5 May 2021