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. Learn more →
Top 23 postgresql-extension Open-Source Projects
-
Consider also the companies and work behind pgrx [0] and pgzx [1]:
-
Apache AGE
Graph database optimized for fast analysis and real-time data processing. It is provided as an extension to PostgreSQL. (by apache)
Project mention: Apache AGE: PostgreSQL Extension Graph Data Processing and Analytics | news.ycombinator.com | 2024-03-28 -
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.
-
hydra
Hydra: Column-oriented Postgres. Add scalable analytics to your project in minutes. (by hydradatabase)
Don't feel bad, lots of people get bitten by not reading all the way down to the bottom of their readme: https://github.com/hydradatabase/hydra/blob/v1.1.2/README.md... While Hydra may very well license their own code Apache 2, they ship the AGPLv3 columnar which to my very best IANAL understanding taints the whole stack and AGPLv3's everything all the way through https://github.com/hydradatabase/hydra/blob/v1.1.2/columnar/...
-
orioledb
OrioleDB – building a modern cloud-native storage engine (... and solving some PostgreSQL wicked problems) 🇺🇦
hey hn, supabase ceo here
we've been fans of Oriole for a while now and have been long-time supporters
in case you're jumping straight to the comments: OrioleDB is a table storage extension for Postgres. it acts as a drop-in replacement for the default postgres storage engine using the Table Access Method APIs (pluggable storage). the storage engine changes the representation of table data on disk. its architecture is designed to take advantage of modern hardware like SSDs and NVRAM. it implements MVCC, the feature that allows allows multiple connected users to see different versions of the data depending on when their transaction started, via an UNDO log rather than tuple versioning.
one caveat: it requires several patches to the postgres core to expand on the type of features external storage engines extensions can implement. for this reason it could be a while before you see this land as a default engine on supabase. we will probably make it available as an option for customers who want to experiment - no timeline is decided yet.
finally, we have been working with the team on decoupled storage and compute [0]. this is experimental but promising, especially with some recent advances in S3 (specifically Express One Zone [1]). we have a demonstration in the blog post.
i'll message Alexander in case there are any technical questions
[0] https://github.com/orioledb/orioledb/blob/main/doc/usage.md#...
[1] https://aws.amazon.com/s3/storage-classes/express-one-zone/
-
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.
-
Project mention: PLJS – JavaScript Language Plugin for PostreSQL | news.ycombinator.com | 2023-07-23
a bit more than an experiment at this point. pljs, even in its early state, has some very good results: https://github.com/plv8/plv8/issues/531#issuecomment-1627883...
passing through v8's javascript/c++ membrane has always been painful, and appears to be getting worse.
-
Project mention: Show HN: I built this Postgres logger for you guys to check out | news.ycombinator.com | 2023-08-24
I think pgAudit it still the best and it's not a major issue. You can try my PR that fixes this issue https://github.com/pgaudit/pgaudit/pull/219 it should work and it should handle the other types of SELECT's that need update permissions but are not actually updating anything https://pglocks.org/?pglock=RowShareLock
-
WorkOS
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.
-
-
plpgsql_check
plpgsql_check is a linter tool (does source code static analyze) for the PostgreSQL language plpgsql (the native language for PostgreSQL store procedures).
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.
-
orafce
The "orafce" project implements in Postgres some of the functions from the Oracle database that are missing (or behaving differently).Those functions were verified on Oracle 10g, and the module is useful for production work.
-
I used one of their open source work in a project: https://github.com/supabase/wrappers
It’s appreciated since SaaS on AWS is a no-no in my field.
-
-
For Postgres, there is an extension that provides that.
-
tds_fdw
A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)
-
-
Project mention: Making PostgreSQL tick: New features in pg_cron | news.ycombinator.com | 2023-10-26
I dunno about other hosted Postgres providers, but not on AWS RDS no, as the Python extension is untrusted. Looks like you can use plv8 via pg_tle (Trusted Language Extensions) [1] though.
-
Unfortunately, as of PostgreSQL 16, UUIDv7 are not yet supported out of the box. For the time being, use an extension such as pg_uuidv7 or pg_idkit to generate UUIDv7 e.g. as default primary key when you CREATE new records.
-
age-viewer
Graph database optimized for fast analysis and real-time data processing. It is provided as an extension to PostgreSQL.
References: https://theundersurfers.com/age-installation/ Apache AGE GitHub: age Apache AGE Viewer GitHub: age-viewer
-
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
-
-
-
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
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).
The latest post mention was on 2024-04-15.
postgresql-extension related posts
- Supabase Acquires OrioleDB
- Postgres Extension to Calculate the Maximal Information Coefficient (Mic)
- Apache AGE: PostgreSQL Extension Graph Data Processing and Analytics
- Apache AGE: PostgreSQL Extension Graph Data Processing and Analytics for RDBMS
- Apache AGE supporting latest PostgreSQL (ver 16)
- UUIDv7 is coming in PostgreSQL 17
- SQL as API
-
A note from our sponsor - InfluxDB
www.influxdata.com | 18 Apr 2024
Index
What are some of the best open-source postgresql-extension projects? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | pgrx | 3,198 |
| 2 | Apache AGE | 2,648 |
| 3 | hydra | 2,607 |
| 4 | orioledb | 2,603 |
| 5 | pg_partman | 1,863 |
| 6 | plv8 | 1,850 |
| 7 | pgaudit | 1,183 |
| 8 | pg_auto_failover | 1,034 |
| 9 | plpgsql_check | 602 |
| 10 | orafce | 468 |
| 11 | wrappers | 428 |
| 12 | wasmer-postgres | 397 |
| 13 | pg_similarity | 352 |
| 14 | tds_fdw | 346 |
| 15 | pguri | 303 |
| 16 | pg_tle | 294 |
| 17 | pg_uuidv7 | 226 |
| 18 | age-viewer | 199 |
| 19 | sqlite_fdw | 192 |
| 20 | pg_show_plans | 175 |
| 21 | pg_net | 164 |
| 22 | parquet_s3_fdw | 157 |
| 23 | pgsentinel | 156 |
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com