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 20 C postgresql-extension Projects
-
Apache AGE
Graph database optimized for fast analysis and real-time data processing. It is provided as an extension to PostgreSQL. (by apache)
-
orioledb
OrioleDB – building a modern cloud-native storage engine (... and solving some PostgreSQL wicked problems) 🇺🇦
-
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.
-
hydra
Hydra: Column-oriented Postgres. Add scalable analytics to your project in minutes. (by hydradatabase)
-
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.
-
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.
-
tds_fdw
A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)
-
firebird_fdw
A PostgreSQL foreign data wrapper (FDW) for Firebird - latest version 1.3.1 (2022-06-22)
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
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/...
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.
For Postgres, there is an extension that provides that.
Project mention: Making PostgreSQL tick: New features in pg_cron | news.ycombinator.com | 2023-10-26I 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.
[1] https://github.com/aws/pg_tle
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.
Project mention: Postgres Extension to Calculate the Maximal Information Coefficient (Mic) | news.ycombinator.com | 2024-04-10
Project mention: Compile pg_math for YugabyteDB (wrapper on GNU Scientific Library distribution functions) | dev.to | 2023-05-31Many 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.
C 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)
- Jepsen: MySQL 8.0.34
- Hydra (YC W22) adds upsert to columnar Postgres
-
A note from our sponsor - InfluxDB
www.influxdata.com | 25 Apr 2024
Index
What are some of the best open-source postgresql-extension projects in C? This list will help you:
Project | Stars | |
---|---|---|
1 | Apache AGE | 2,671 |
2 | orioledb | 2,631 |
3 | hydra | 2,620 |
4 | pgaudit | 1,183 |
5 | pg_auto_failover | 1,035 |
6 | plpgsql_check | 605 |
7 | orafce | 470 |
8 | pg_similarity | 352 |
9 | tds_fdw | 346 |
10 | pguri | 304 |
11 | pg_tle | 294 |
12 | pg_uuidv7 | 230 |
13 | pg_show_plans | 176 |
14 | pgsentinel | 156 |
15 | supautils | 49 |
16 | firebird_fdw | 36 |
17 | vasco | 20 |
18 | pg_math | 14 |
19 | cookiecutter-postgres-extension | 7 |
20 | pg-generate-up-down-series | 0 |
Sponsored