InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now. Learn more →
Top 23 C Postgre Projects
-
TimescaleDB
A time-series database for high-performance real-time analytics packaged as a Postgres extension
In fact, even in the absence of these commercial databases, users can effortlessly install PostgreSQL and leverage its built-in pgvector functionality for vector search. PostgreSQL stands as the benchmark in the realm of open-source databases, offering comprehensive support across various domains of database management. It excels in transaction processing (e.g., CockroachDB), online analytics (e.g., DuckDB), stream processing (e.g., RisingWave), time series analysis (e.g., Timescale), spatial analysis (e.g., PostGIS), and more. For non-professional users seeking to explore vector databases, they can readily download the open-source PostgreSQL or utilize managed services like Supabase and Neon to establish their own basic AI applications. Other than PostgreSQL, several open-source databases, including OpenSearch, ClickHouse, and Cassandra, have implemented their own vector search functionality. You do not need to adopt a new vector database if you have already used these systems.
-
InfluxDB
InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
-
Project mention: Why uber ditched postgres for mysql: What every developer can learn from it | dev.to | 2025-05-03
Citus PostgreSQL extension for horizontal scaling. If you still want to try Postgres at scale, this is your sword.
-
orioledb
OrioleDB – building a modern cloud-native storage engine (... and solving some PostgreSQL wicked problems)
# Install dependencies apt update apt install python3 python3-dev python3-pip python3-setuptools python3-testresources libzstd1 libzstd-dev libssl-dev libcurl4-openssl-dev git clone https://github.com/orioledb/orioledb cd orioledb git reset --hard 0c484c4 # optional make USE_PGXS=1 ORIOLEDB_PATCHSET_VERSION=5 echo "shared_preload_libraries = 'orioledb.so'" >> /usr/local/pgsql/data/postgresql.conf
-
That works but for a more robust solution you could look at https://pgbackrest.org
-
Just wonder what is the advantage of Redshift vs using something such as https://github.com/hydradatabase/columnar, if we are already using postgres?
-
Project mention: PostgreSQL Is the Database Management System of the Year 2024 | news.ycombinator.com | 2025-01-14
I work on BDR but I'm pretty sure we actively support open-source options for HA:
https://github.com/EnterpriseDB/repmgr
-
Project mention: Pg_flo – Stream, transform, and route PostgreSQL data in real-time | news.ycombinator.com | 2024-11-03
https://github.com/eulerto/wal2json has existed for this purpose for many years, just transform the incoming records into JSON and parse with literally any standard tool that reads the format.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
Project mention: Pg_auto_failover: PostgreSQL extension and service for automated failover and hi | news.ycombinator.com | 2025-03-04
-
-
Project mention: Ask HN: What are you working on (September 2024)? | news.ycombinator.com | 2024-09-29
I'm extending Postgres with the GraphBLAS/SparseBLAS APIs for sparse and dense linear algebra operations directly in SQL with OneSparse. Like JSON/JSONB did for unstructured data, OneSparse does for matrices, vectors and linear algebra optimized with the SuiteSparse JIT compiler to target dense and sparse kernels for CPUs and GPUs.
https://github.com/OneSparse/OneSparse
-
-
Exemplos de extensões utilizando o SQL
-
Third, there are some reports of pg_net failing to make requests after your database transaction volume surpasses a certain threshold.
-
Project mention: Postgres as a Graph Database: (Ab)Using PgRouting | news.ycombinator.com | 2025-02-27
-
-
-
-
-
-
This will transfer the data from the server to psql, so it will include network time, which makes the benchmark more realistic.
[1] https://github.com/andrielfn/pg-ulid
-
pg_plan_guarantee
Postgres Query Optimizer Extension that guarantees your desired plan will not change
-
-
Project mention: Show HN: Maximal Information Coefficient (Mic) Extension for Postgres | news.ycombinator.com | 2024-12-27
-
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).
C Postgres discussion
C Postgres related posts
-
⚙️ SQL Patterns for Optimizing IoT Queries in TimescaleDB
-
Implementing & Monitoring Replicas in PostgreSQL
-
Ask HN: Alternatives to Vector DB?
-
Modern Web Development Sucks? How PostgreSQL Can Replace Your Tech Stack
-
Pg_auto_failover: PostgreSQL extension and service for automated failover and hi
-
Making Postgres better with OrioleDB
-
Reliably Replicating Data Between PostgreSQL and ClickHouse
-
A note from our sponsor - InfluxDB
www.influxdata.com | 14 May 2025
Index
What are some of the best open-source Postgre projects in C? This list will help you:
| # | Project | Stars |
|---|---|---|
| 1 | TimescaleDB | 19,063 |
| 2 | citus | 11,353 |
| 3 | orioledb | 3,365 |
| 4 | pgBackRest | 2,981 |
| 5 | columnar | 2,941 |
| 6 | repmgr | 1,625 |
| 7 | wal2json | 1,383 |
| 8 | pg_auto_failover | 1,203 |
| 9 | pg_uuidv7 | 376 |
| 10 | OneSparse | 375 |
| 11 | pg_similarity | 373 |
| 12 | pg_tle | 362 |
| 13 | pg_net | 294 |
| 14 | pg_roaringbitmap | 235 |
| 15 | pgJQ | 195 |
| 16 | pgsentinel | 178 |
| 17 | pgspider | 178 |
| 18 | pg_hexedit | 161 |
| 19 | pg_wait_sampling | 156 |
| 20 | pg-ulid | 96 |
| 21 | pg_plan_guarantee | 95 |
| 22 | plmustache | 50 |
| 23 | vasco | 33 |
Sponsored
InfluxDB – Built for High-Performance Time Series Workloads
InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
www.influxdata.com