Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR. Learn more →
Top 23 C Postgresql Projects
-
Project mention: Netdata: 20% discount on all annual plans Promo code BF20241Y | news.ycombinator.com | 2024-12-04
-
CodeRabbit
CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
-
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.
-
Project mention: Reliably Replicating Data Between PostgreSQL and ClickHouse | news.ycombinator.com | 2025-02-22
for one thing, depending on your licensing contraints:
- Citus is AGPLv3 https://github.com/citusdata/citus/blob/v13.0.1/LICENSE
- Hydra is Apache 2 https://github.com/hydradatabase/columnar/blob/v1.1.2/LICENS...
- Timescale is mostly Apache 2 https://github.com/timescale/timescaledb/blob/2.18.2/LICENSE
-
Project mention: Database Stress Testing: Why It Matters and How to Get Started | dev.to | 2025-01-09
Sysbench: Ideal for benchmarking and stress testing MySQL and PostgreSQL databases.
-
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: Postgres as a Graph Database: (Ab)Using PgRouting | news.ycombinator.com | 2025-02-27Any comments on "Apache AGE"?
Apache AGE™ is a PostgreSQL that provides graph database functionality.
https://age.apache.org
-
# Palindrome project Project used to explain my view on a django project architecture, explained on my [series of posts](https://dev.to/pcampos119104/django-project-setup-part-1-2e7a) ## Tools, libs, etc. Some time related files. Versions on Poetry. - [Python](https://www.python.org/) Programming languange - [django-environ](https://django-environ.readthedocs.io) Manage .envs in Django - [Poetry](https://python-poetry.org/) Python packaging and dependency management - poetry.lock - pyproject.toml - [Django](https://www.djangoproject.com/) Web framework written in Python - [Docker](https://www.docker.com/) Manage containers for dev environment - compose.yaml - compose/dev/Dockerfile - compose/dev/start - .env - [Just](https://just.systems/) encapsulate commands for easier use - justfile - [psycopg](https://www.psycopg.org/) Python adapter for Postgres # <-- new line ## Dev environment setup 1. Install Just, Docker and Poetry(opcional). 2. Copie .env.example to .env, no need for edtion. 3. `$ just build` ## Run the server for development 1. Certified that docker is up and running 2. `$ just runserver` You can access on http://0.0.0.0:8000/
-
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
-
InfluxDB
InfluxDB high-performance time series database. Collect, organize, and act on massive volumes of high-resolution data to power real-time intelligent systems.
-
Connection pooling is usually the first and most effective fix to increase connection capacity. PgBouncer addresses two key scalability constraints in Postgres: per-connection memory overhead and context switching costs. Instead of Postgres maintaining separate processes and memory allocations, PgBouncer manages a small pool of actual Postgres connections that serve a larger number of client connections by assigning requests to available connections from the pool. This eliminates the overhead of repeatedly setting up and closing connections.
-
Time to live - postgres pg_cron extension that we can use to schedule row delition. But before that, we need to configure rds
-
-
Just wonder what is the advantage of Redshift vs using something such as https://github.com/hydradatabase/columnar, if we are already using postgres?
-
That works but for a more robust solution you could look at https://pgbackrest.org
-
-
pspg
Unix pager (with very rich functionality) designed for work with tables. Designed for PostgreSQL, but MySQL is supported too. Works well with pgcli too. Can be used as CSV or TSV viewer too. It supports searching, selecting rows, columns, or block and export selected area to clipboard.
-
cstore_fdw
Columnar storage extension for Postgres built as a foreign data wrapper. Check out https://github.com/citusdata/citus for a modernized columnar storage implementation built as a table access method.
cstore_fdw
-
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
-
To test various indexes, we don’t need to create them. We can use HypoPG extension that can analyze the index without creating it in the database.
-
-
Project mention: Pg_auto_failover: PostgreSQL extension and service for automated failover and hi | news.ycombinator.com | 2025-03-04
-
pmacct
pmacct is a small set of multi-purpose passive network monitoring tools [NetFlow IPFIX sFlow libpcap BGP BMP RPKI IGP Streaming Telemetry].
-
pglogical
Logical Replication extension for PostgreSQL 17, 16, 15, 14, 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slony, Bucardo or Londiste, as well as cross-version upgrades.
Partitioning has been supported for quite a while
https://www.postgresql.org/docs/current/ddl-partitioning.htm...
Logical replication...
https://www.postgresql.org/docs/current/logical-replication....
https://github.com/2ndQuadrant/pglogical?tab=readme-ov-file#...
https://docs.aws.amazon.com/dms/latest/sbs/chap-manageddatab...
In 'recent years' (in database support terms), PostgreSQL has gained autovacuum support.
https://www.enterprisedb.com/blog/postgresql-vacuum-and-anal...
This stack overflow question was insightful, in that most of the slowness many experience may be related to foreign key check lookups on unindexed columns that point to external keys. https://dba.stackexchange.com/questions/328884/why-is-the-de... Partitioned data and batches to spread out updates also appear to be current best practices https://www.dragonflydb.io/faq/postgres-delete-performance
-
cloudberry
One advanced and mature open-source MPP (Massively Parallel Processing) database. Open source alternative to Greenplum Database.
Project mention: Show HN: Apache Cloudberry – Advanced and mature open-source MPP database | news.ycombinator.com | 2024-12-19Thanks for asking. I’m from Apache Cloudberry community.
I think there is a plan on integration with iceberg, you can take this for reference: https://github.com/apache/cloudberry/discussions/369. We are also discussing the new roadmap, FYI.
-
-
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 Postgresql discussion
C Postgresql related posts
-
PostgreSQL vs MySQL vs Redis: Choose Your Fighter
-
⚙️ SQL Patterns for Optimizing IoT Queries in TimescaleDB
-
Weekly Indie Log #9
-
Implementing & Monitoring Replicas in PostgreSQL
-
We don't need DynamoDB when we have Aurora Postgres
-
Ask HN: What do you use for analytics for a statically generated website?
-
Modern Web Development Sucks? How PostgreSQL Can Replace Your Tech Stack
-
A note from our sponsor - CodeRabbit
coderabbit.ai | 25 Apr 2025
Index
What are some of the best open-source Postgresql projects in C? This list will help you:
| # | Project | Stars |
|---|---|---|
| 1 | Netdata | 74,292 |
| 2 | TimescaleDB | 18,899 |
| 3 | citus | 11,292 |
| 4 | sysbench | 6,331 |
| 5 | Apache AGE | 3,488 |
| 6 | psycopg2 | 3,455 |
| 7 | orioledb | 3,336 |
| 8 | pgbouncer | 3,237 |
| 9 | pg_cron | 3,243 |
| 10 | PolarDB-for-PostgreSQL | 2,973 |
| 11 | columnar | 2,936 |
| 12 | pgBackRest | 2,909 |
| 13 | PipelineDB | 2,639 |
| 14 | pspg | 2,581 |
| 15 | cstore_fdw | 1,766 |
| 16 | repmgr | 1,614 |
| 17 | hypopg | 1,470 |
| 18 | pgaudit | 1,424 |
| 19 | pg_auto_failover | 1,196 |
| 20 | pmacct | 1,105 |
| 21 | pglogical | 1,098 |
| 22 | cloudberry | 943 |
| 23 | IvorySQL | 908 |
Sponsored
CodeRabbit: AI Code Reviews for Developers
Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
coderabbit.ai