C Postgresql

Open-source C projects categorized as Postgresql

Top 23 C Postgresql Projects

  • Netdata

    The open-source observability platform everyone needs

  • Project mention: A list of SaaS, PaaS and IaaS offerings that have free tiers of interest to devops and infradev | dev.to | 2024-02-05

    netdata.cloud — Netdata is an open-source tool to collect real-time metrics. It's a growing product and can also be found on GitHub!

  • TimescaleDB

    An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.

  • Project mention: pg_timeseries: Open-source time-series extension for PostgreSQL | news.ycombinator.com | 2024-05-20

    Compression and other features use the non-Apache license:


  • 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.

    InfluxDB logo
  • citus

    Distributed PostgreSQL as an extension

  • Project mention: SPQR 1.3.0: a production-ready system for horizontal scaling of PostgreSQL | news.ycombinator.com | 2024-03-25
  • Greenplum

    Greenplum Database - Massively Parallel PostgreSQL for Analytics. An open-source massively parallel data platform for analytics, machine learning and AI.

  • sysbench

    Scriptable database and system performance benchmark

  • psycopg2

    PostgreSQL database adapter for the Python programming language

  • PolarDB-for-PostgreSQL

    A cloud-native database based on PostgreSQL developed by Alibaba Cloud.

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
  • 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: Apache AGE Graph Database – Apache AGE | news.ycombinator.com | 2024-05-20
  • orioledb

    OrioleDB – building a modern cloud-native storage engine (... and solving some PostgreSQL wicked problems)  🇺🇦

  • Project mention: Supabase Acquires OrioleDB | news.ycombinator.com | 2024-04-15

    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/

  • pgbouncer

    lightweight connection pooler for PostgreSQL

  • Project mention: MongoDB and Load Balancer Support | dev.to | 2024-03-15

    Thanks to MongoDB drivers all consistently providing connection monitoring and pooling functionality, external connection pooling solutions aren't required (ex: Pgpool, PgBouncer). This allows applications built using MongoDB drivers to be resilient and scalable out of the box, but based on what we understand regarding the number of connections applications establish to MongoDB clusters it stands to reason that at a certain point as our application deployments increase, so will our connections.

  • hydra

    Hydra: Column-oriented Postgres. Add scalable analytics to your project in minutes. (by hydradatabase)

  • Project mention: Pg_lakehouse: Query Any Data Lake from Postgres | news.ycombinator.com | 2024-05-13

    How does this compare to Hydra? https://www.hydra.so/

  • PipelineDB

    High-performance time-series aggregation for PostgreSQL

  • Project mention: PostgreSQL Is Enough | news.ycombinator.com | 2024-02-06
  • pg_cron

    Run periodic jobs in PostgreSQL

  • Project mention: Run Periodic Jobs in PostgreSQL | news.ycombinator.com | 2024-05-14
  • 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.

  • Project mention: Harlequin: SQL IDE for Your Terminal | news.ycombinator.com | 2024-01-05

    pspg is a pager intended to be used with SQL command line clients. It was originally created for Postgres (hence the name), but also works with MySQL and others


  • pgBackRest

    Reliable PostgreSQL Backup & Restore

  • Project mention: pgBackRest: PostgreSQL S3 backups | dev.to | 2023-08-10

    This tutorial explains how to backup PostgreSQL database using pgBackRest and S3.

  • 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.

  • Project mention: Moving a Billion Postgres Rows on a $100 Budget | news.ycombinator.com | 2024-02-21

    Columnar store PostgreSQL extension exists, here are two but I think I’m missing at least another one:



    You can also connect other stores using the foreign data wrappers, like parquet files stored on an object store, duckdb, clickhouse… though the joins aren’t optimised as PostgreSQL would do full scan on the external table when joining.

  • hypopg

    Hypothetical Indexes for PostgreSQL

  • Project mention: HypoPG: Hypothetical Indexes for PostgreSQL | news.ycombinator.com | 2024-05-20
  • pgaudit

    PostgreSQL Audit Extension

  • Project mention: Show HN: I built this Postgres logger for you guys to check out | news.ycombinator.com | 2023-08-24

    I 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

  • pg_auto_failover

    Postgres extension and service for automated failover and high-availability

  • Project mention: 11 Years of Hosting a SaaS | news.ycombinator.com | 2023-06-16
  • pmacct

    pmacct is a small set of multi-purpose passive network monitoring tools [NetFlow IPFIX sFlow libpcap BGP BMP RPKI IGP Streaming Telemetry].

  • Project mention: NetFlow-equivalent analysis for mirrored traffic | /r/networking | 2023-07-12

    If you want a tool that can ingest from a span port and generate netflow or IPFIX there is pmacct. This should work with your existing tooling that collects netflow data.

  • pglogical

    Logical Replication extension for PostgreSQL 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.

  • ruby-pg

    A PostgreSQL client library for Ruby

  • Project mention: Test Driving a Rails API - Part One | dev.to | 2024-03-11

    If you installed Postgres via Homebrew, you need to configure bundler so that when it installs the pg gem, it knows where to find the pg_config executable, which is installed as part of Postgres. The pg gem is the Ruby interface to Postgres and requires pg_config during installation. We can use this command to configure bundler so that it can find it and successfully install pg.

  • IvorySQL

    Open Source Oracle Compatible PostgreSQL.

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
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 related posts


What are some of the best open-source Postgresql projects in C? This list will help you:

Project Stars
1 Netdata 68,562
2 TimescaleDB 16,608
3 citus 9,932
4 Greenplum 6,221
5 sysbench 5,833
6 psycopg2 3,232
7 PolarDB-for-PostgreSQL 2,773
8 Apache AGE 2,768
9 orioledb 2,670
10 pgbouncer 2,703
11 hydra 2,662
12 PipelineDB 2,615
13 pg_cron 2,591
14 pspg 2,386
15 pgBackRest 2,252
16 cstore_fdw 1,738
17 hypopg 1,286
18 pgaudit 1,201
19 pg_auto_failover 1,040
20 pmacct 1,022
21 pglogical 945
22 ruby-pg 756
23 IvorySQL 699

SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives