Top 8 plpgsql Open-Source 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.
plpgsql_check

3 605 8.4 C

plpgsql_check is a linter tool (does source code static analyze) for the PostgreSQL language plpgsql (the native language for PostgreSQL store procedures).

Project mention: Supabase Local Dev: migrations, branching, and observability | dev.to | 2023-08-08

Finally, while you wait for us to make progress on the Language Server, we’ve added support for linting through the excellent plpgsql_check extension.

vector-datasource

3 492 2.4 Python

Tilezen vector tile service - OpenStreetMap data in several formats
stacker.news

9 389 9.9 JavaScript

Internet communities that pay you Bitcoin

Project mention: What are the best alternatives that capture the feeling of old Reddit? | /r/RedditAlternatives | 2023-11-03

https://oddbean.com https://satellite.earth https://stacker.news

pgrebase

1 335 4.3 Go

Easy postgres codebase injection - aka postgres non data live reload
metagration

4 100 0.0 PLpgSQL

Metagration: PostgreSQL Migrator in PostgreSQL
WorkOS

workos.com sponsored

The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
pg_math

1 14 6.0 C

pg_math extension to support statistical distribution functions for PostgreSQL

Project mention: Compile pg_math for YugabyteDB (wrapper on GNU Scientific Library distribution functions) | dev.to | 2023-05-31

Many extensions are easy to compile on PostgreSQL and install on YugabyteDB. The most important is to compile it in the right version of PostgreSQL and identify all files and dependencies. In the first post of this series, I did it in a Dockerfile. Here I'll run similar commands on a Docker container started from the YugabyteDB 2.18 image, that is built with Alma8, to install pg_math, a wrapper for GSL (GNU Scientific Library) statistical distribution functions.

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