The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning. Learn more →
Top 23 postgresql-extension Open-Source Projects
-
-
Apache AGE
Graph database optimized for fast analysis and real-time data processing. It is provided as an extension to PostgreSQL. (by apache)
-
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.
-
orioledb
OrioleDB – building a modern cloud-native storage engine (... and solving some PostgreSQL wicked problems) 🇺🇦
-
hydra
Hydra: Column-oriented Postgres. Add scalable analytics to your project in minutes. (by hydradatabase)
-
-
-
-
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).
-
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.
-
-
-
tds_fdw
A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)
-
-
age-viewer
Graph database optimized for fast analysis and real-time data processing. It is provided as an extension to PostgreSQL.
-
-
-
-
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Consider also the companies and work behind pgrx [0] and pgzx [1]:
[0] https://github.com/pgcentralfoundation/pgrx
[1] https://github.com/xataio/pgzx
Project mention: Apache AGE: PostgreSQL Extension Graph Data Processing and Analytics | news.ycombinator.com | 2024-03-28
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/
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/...
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: Show HN: I built this Postgres logger for you guys to check out | news.ycombinator.com | 2023-08-24I 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
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.
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.
Project mention: Pgcopydb: Copy a Postgres database to a target Postgres server | news.ycombinator.com | 2024-04-25Have you tried this in databases with [TLE](https://github.com/aws/pg_tle)s?
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.
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-03https://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
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).
postgresql-extension related posts
- Pgcopydb: Copy a Postgres database to a target Postgres server
- 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
-
A note from our sponsor - WorkOS
workos.com | 30 Apr 2024
Index
What are some of the best open-source postgresql-extension projects? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | pgrx | 3,235 |
| 2 | Apache AGE | 2,695 |
| 3 | orioledb | 2,631 |
| 4 | hydra | 2,620 |
| 5 | pg_partman | 1,879 |
| 6 | plv8 | 1,854 |
| 7 | pgaudit | 1,183 |
| 8 | pg_auto_failover | 1,036 |
| 9 | plpgsql_check | 605 |
| 10 | orafce | 471 |
| 11 | wrappers | 436 |
| 12 | wasmer-postgres | 397 |
| 13 | pg_similarity | 352 |
| 14 | tds_fdw | 347 |
| 15 | pguri | 304 |
| 16 | pg_tle | 299 |
| 17 | pg_uuidv7 | 232 |
| 18 | age-viewer | 201 |
| 19 | sqlite_fdw | 193 |
| 20 | pg_show_plans | 176 |
| 21 | pg_net | 170 |
| 22 | parquet_s3_fdw | 162 |
| 23 | pgsentinel | 157 |
Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com