Top 7 PLpgSQL postgresql-extension 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.

sqlite_fdw

6 193 5.7 PLpgSQL

SQLite Foreign Data Wrapper for PostgreSQL

Project mention: Things that surprised me while running SQLite in production | news.ycombinator.com | 2023-07-03

https://github.com/pgspider/sqlite_fdw
Postgres has foreign data wrappers which can kinda achieve this(see also: https://github.com/pgspider/sqlite_fdw ), but ive been surprised by how well sqlite is already supported by many tools : sometimes it comes for free as its used in testing - hooking up stuff like litestream can work really wel l too

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

4 170 7.2 PLpgSQL

A PostgreSQL extension that enables asynchronous (non-blocking) HTTP/HTTPS requests with SQL

Project mention: PostgreSQL Is Enough | news.ycombinator.com | 2024-02-06

parquet_s3_fdw

1 159 2.3 PLpgSQL

ParquetS3 Foreign Data Wrapper for PostgresSQL
postgres-aws-s3

1 135 0.0 PLpgSQL

aws_s3 postgres extension to import/export data from/to s3 (compatible with aws_s3 extension on AWS RDS)
pgddl

2 123 8.5 PLpgSQL

DDL eXtractor functions for PostgreSQL (ddlx)

Project mention: Ask HN: It's 2023, how do you choose between MySQL and Postgres? | news.ycombinator.com | 2023-05-11

boolif-postgresql

1 0 0.0 PLpgSQL

A PostgreSQL function that returns a custom value if two booleans match.
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.

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