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) 🇺🇦
-
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)
-
-
-
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.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
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 (2023-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/
Project mention: Pg_lakehouse: Query Any Data Lake from Postgres | news.ycombinator.com | 2024-05-13How does this compare to Hydra? https://www.hydra.so/
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: 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.
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.
Developing a pg extension is all about compiling some C code into a .so object and dynamically using a templated Makefile to load it into the running Postgres process.
If you want some boilerplate to get you started I've been using this cookie-cutter template to bootstrap lots of extensions https://github.com/Florents-Tselai/cookiecutter-postgres-ext...
Demo walkthrough: https://www.youtube.com/watch?v=zVxY3ZmE5bU
Contributing to core Postgres, it's an entirely different story.
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).
C postgresql-extension related posts
-
Hacking on PostgreSQL Is Hard
-
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)
-
A note from our sponsor - InfluxDB
www.influxdata.com | 17 May 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,733 |
| 2 | orioledb | 2,663 |
| 3 | hydra | 2,651 |
| 4 | pgaudit | 1,192 |
| 5 | pg_auto_failover | 1,038 |
| 6 | plpgsql_check | 608 |
| 7 | orafce | 472 |
| 8 | pg_similarity | 352 |
| 9 | tds_fdw | 353 |
| 10 | pguri | 303 |
| 11 | pg_tle | 302 |
| 12 | pg_uuidv7 | 237 |
| 13 | pg_show_plans | 176 |
| 14 | pgsentinel | 160 |
| 15 | supautils | 50 |
| 16 | firebird_fdw | 36 |
| 17 | vasco | 21 |
| 18 | pg_math | 14 |
| 19 | cookiecutter-postgres-extension | 11 |
| 20 | pg-generate-up-down-series | 0 |
Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com