C Postgresql

Open-source C projects categorized as Postgresql | Edit details

Top 23 C Postgresql Projects

  • TimescaleDB

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

    Project mention: Recommendation for storing active historical "checkpoints" | reddit.com/r/PostgreSQL | 2022-01-13

    Would Timescale be an option for your use case? Seems like it fits right in.

  • citus

    Distributed PostgreSQL as an extension

    Project mention: The implementation of the UK Covid-19 dashboard | news.ycombinator.com | 2022-01-23

    To be accurte, it's not completely Micrsoft agnostic, it make use case for a PSQL extension citus[1], the company behind this extension has been acquired by Microsoft two years ago[2].

    [1]: https://github.com/citusdata/citus

  • OPS

    OPS - Build and Run Open Source Unikernels. Quickly and easily build and deploy open source unikernels in tens of seconds. Deploy in any language to any cloud.

  • psycopg2

    PostgreSQL database adapter for the Python programming language

    Project mention: How to deploy the Front-end(React) and Backend(Django) with Postgres at Heroku | dev.to | 2021-12-10

    psycopg2: Psycopg is a PostgreSQL adapter for the Python programming language.

  • PipelineDB

    High-performance time-series aggregation for PostgreSQL

    Project mention: Ask HN: Is there a way to subscribe to an SQL query for changes? | news.ycombinator.com | 2021-04-22

    PipelineDB might be of interest. https://github.com/pipelinedb/pipelinedb

  • 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: Pspg – Postgres Pager | news.ycombinator.com | 2021-12-23
  • 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: Creating a simple data pipeline | reddit.com/r/dataengineering | 2021-05-20

    The citus extension for postgresql. https://github.com/citusdata/cstore_fdw

  • pgbouncer

    lightweight connection pooler for PostgreSQL

    Project mention: Cascade of doom: JIT, and how a Postgres update led to 70% failure on a critical national service | dev.to | 2021-11-13

    Towards the end of the week, a few people reached out to me saying that they were encountering an increasing number of failed requests when using APIv2. They were peculiarly saying that they couldn't download new data from the API after the release. My first action in such cases is to check the API service, and our PGBouncer instances to ensure that they are healthy. Then I usually clear the storage cache for APIv2, which usually solves the problem.

  • Scout APM

    Less time debugging, more time building. Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.

  • pg_cron

    Run periodic jobs in PostgreSQL

    Project mention: Do you know of a robust library that handles persistent job scheduling and queuing using PostgreSQL | reddit.com/r/golang | 2022-01-15

    If you just want scheduling queries, you can use this https://github.com/citusdata/pg_cron

  • pgbackrest

    Reliable PostgreSQL Backup & Restore

    Project mention: pgbackrest localhost backup works fine, but a remote backup call fails | reddit.com/r/PostgreSQL | 2021-10-04
  • 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: IPv4 vs IPv6 traffic stats | reddit.com/r/mikrotik | 2022-01-04
  • pg_auto_failover

    Postgres extension and service for automated failover and high-availability

    Project mention: Simpler Postgresql replication setup (NO managed services) | reddit.com/r/PostgreSQL | 2021-12-15

    My go to for this is https://github.com/citusdata/pg_auto_failover set up with ansible https://github.com/neuroforgede/pg\_auto\_failover\_ansible

  • hypopg

    Hypothetical Indexes for PostgreSQL

    Project mention: Postgres Indexes for Newbies | news.ycombinator.com | 2022-01-19
  • pgaudit

    PostgreSQL Audit Extension

    Project mention: How Postgres Audit Tables Saved Us from Taking Down Production | news.ycombinator.com | 2021-10-26

    You can use pgaudit, it's an extension that let's you audit DDL/DML statements. It's a great auditing mechanism. I use it on all our prod postgres instances, but have only "DML" enabled, because of the potential performance overhead


  • ruby-pg

    A PostgreSQL client library for Ruby

    Project mention: Explaining Ruby Fibers | reddit.com/r/ruby | 2021-10-21
  • pgagroal

    High-performance connection pool for PostgreSQL

    Project mention: Pgagroal: High-performance connection pool for PostgreSQL | news.ycombinator.com | 2021-11-21
  • rum

    RUM access method - inverted index with additional information in posting lists

    Project mention: Postgrespro/rum: RUM access method – inverted index with additional information | news.ycombinator.com | 2021-12-17
  • plpgsql_check

    plpgsql_check is linter tool for language PL/pgSQL (native language for PostgreSQL store procedures).

    Project mention: PostGIS – Spatial and Geographic Objects for PostgreSQL | news.ycombinator.com | 2021-04-05
  • pgquarrel

    pgquarrel compares PostgreSQL database schemas (DDL)

    Project mention: Anyone using pgCodeKeeper? | reddit.com/r/PostgreSQL | 2021-01-30
  • 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.

    Project mention: Business Days | reddit.com/r/PostgreSQL | 2021-11-05

    This extension have some functions to work with business days https://github.com/orafce/orafce, search for “bizdays”

  • tds_fdw

    A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)

    Project mention: Babelfish: the Elephant in the Room? | reddit.com/r/PostgreSQL | 2021-02-17

    Or, you could use a foreign data wrapper: https://github.com/tds-fdw/tds_fdw

  • pgsodium

    Modern cryptography for PostgreSQL using libsodium.

    Project mention: Show HN: Pgsodium – A Crytographic PostgreSQL Extension | news.ycombinator.com | 2022-01-10

    Hey HN, I shared an earlier prototype version of pgsodium but I just released 2.0 and felt this could be a good opportunity to share some updates!

    [pgsodium](https://github.com/michelp/pgsodium) 2.0.0 is a postgres extension that uses the [libsodium](https://doc.libsodium.org/) library to provide high-performance, modern cryptography support for PostgreSQL 10+.

    2.0.0 includes a ton of new feature and a few bug-fixes:

    * Support for [XChaCha20-SIV](https://github.com/jedisct1/libsodium-xchacha20-siv) deterministic nonce-free encryption, this is useful for one-time workflows sacrificing a bit of speed and larger key size without worrying about nonce-handling issues.

  • pgsentinel

    postgresql extension providing Active session history

    Project mention: Any Tips for Analyzing (Concurrent) Transaction Performance? | reddit.com/r/PostgreSQL | 2021-12-01


  • postgres-word2vec

    utils to use word embedding models like word2vec vectors in a PostgreSQL database

    Project mention: Build a fuzzy search with PostgreSQL | dev.to | 2021-03-12

    The syntactic similarity is not enough for you? Word2vec could be an option to compare the semantic similarity of words. Luckily there already is a postgres-word2vec extension for this.

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). The latest post mention was on 2022-01-23.

C Postgresql related posts


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

Project Stars
1 TimescaleDB 12,368
2 citus 5,697
3 psycopg2 2,457
4 PipelineDB 2,449
5 pspg 1,772
6 cstore_fdw 1,644
7 pgbouncer 1,503
8 pg_cron 1,498
9 pgbackrest 1,015
10 pmacct 785
11 pg_auto_failover 721
12 hypopg 665
13 pgaudit 655
14 ruby-pg 521
15 pgagroal 504
16 rum 496
17 plpgsql_check 374
18 pgquarrel 328
19 orafce 320
20 tds_fdw 265
21 pgsodium 243
22 pgsentinel 110
23 postgres-word2vec 109
Find remote Postgresql jobs at our new job board 99remotejobs.com. There are 2 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.
Static code analysis for 29 languages.
Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.