Dear data engineers

This page summarizes the projects mentioned and recommended in the original post on /r/dataengineering
Partitioning plpgsql pg-partition-manager background-worker Postgresql

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

  • pg_partman

    Partition management extension for PostgreSQL

    • Assuming these are the types of insights you're looking for, you'll probably look for a way to aggregate data points across/within geographies. postgis is an open source extension for postgres that can help you with this, but there's also quite a few python tools that can help you explore the data, such as geopandas, folium, geoplot. Depending on volume, you might want to partition the data for query performance, and there's another extension pg_partman that can help with that. Just noticed some other posts have recommended something similar.

  • 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

  • Pgpartman: Partition Management Extension for Postgres

    1 project | news.ycombinator.com | 20 Sep 2023

  • Which is the best way to automate backing up data monthly of tables in a schema and then deleting them?

    1 project | /r/PostgreSQL | 6 Oct 2022

  • Partitioning in Postgres, 2022 Edition

    1 project | news.ycombinator.com | 5 Oct 2022

  • Table partitioning by months of the year?

    1 project | /r/PostgreSQL | 23 Aug 2021

  • Replicating a dynamically partitioned table possible in Postgres 13

    1 project | /r/PostgreSQL | 8 Jan 2021