Top 3 PLpgSQL plpgsql Projects

pg_partman

7 1,873 7.3 PLpgSQL

Partition management extension for PostgreSQL

Project mention: Dear data engineers | /r/dataengineering | 2023-12-06

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.

aquameta

8 1,092 8.0 PLpgSQL

Web development platform built entirely in PostgreSQL

Project mention: Versioning data in Postgres? Testing a Git like approach | news.ycombinator.com | 2023-10-20

Aquameta has an interesting extension that something like this in a different way: https://github.com/aquametalabs/aquameta/tree/master/extensi....

InfluxDB

www.influxdata.com sponsored

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.
metagration

4 100 0.0 PLpgSQL

Metagration: PostgreSQL Migrator in PostgreSQL

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020).