C Postgresql

Open-source C projects categorized as Postgresql

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: Looking for advice on DE strategy/tools for our growing business | reddit.com/r/dataengineering | 2023-01-26

    As for performance issues, I'd recommend coming up with a rough estimate of estimated data size growth over the next few year. IMO if the data is less than 1 TB postgres can handle, for advanced aggregates, etc check out Timescale DB they are a pg extension.

  • citus

    Distributed PostgreSQL as an extension

    Project mention: Any self hostable postgres clustering, replication and fail over system? | reddit.com/r/PostgreSQL | 2023-01-25

    Maybe also have a look at https://www.citusdata.com

  • SonarLint

    Clean code begins in your IDE with SonarLint. Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today.

  • Greenplum

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

    Project mention: Show HN: Postgres WASM | news.ycombinator.com | 2022-10-03

    I was wondering if anyone had thought about using this to experiment with the planner.

    The engineering and support teams at Greenplum, a fork of Postgres, have a tool (minirepro[0]) which, given a sql query, can grab a minimal set of DDLs and the associated statistics for the tables involved in the query that can then be loaded into a "local" GPDB instance. Having the DDL and the statistics meant the team was able to debug issues in the optimizer (example [1]), without having access to a full set of data. This approach, if my understanding is correct, could be enabled in the browser with this Postgres WASM capability.

    [0] https://github.com/greenplum-db/gpdb/blob/6X_STABLE/gpMgmt/b...

  • sysbench

    Scriptable database and system performance benchmark

    Project mention: Tracking down high CPU Utilization on Amazon Aurora PostgreSQL | dev.to | 2022-08-30

    QPM is available on Amazon Aurora PostgreSQL version 10.5-compatible (Aurora 2.1.0) and later and can be enabled in production (minimal overhead) and or enabled/disabled against your test working-sets with tools such as sysbench. I highly recommend turning this on under your test environments and also practice plan evolution (reviewing and approving plans) before applying QPM in production. Once applied to production a periodic review will be necessary to see if the optimizer has found better plans with a lower cost estimate that needs to be approved.

  • psycopg2

    PostgreSQL database adapter for the Python programming language

    Project mention: Uploading CSVs to a SQL table using Python | reddit.com/r/pythontips | 2023-01-15

    If you're using Postgres for your SQL, look at the "copy' method of the psycopg module (see https://www.psycopg.org/articles/2020/11/15/psycopg3-copy/) . It's much faster than INSERTs in my experience (YMMV).

  • PipelineDB

    High-performance time-series aggregation for PostgreSQL

  • PolarDB-for-PostgreSQL

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

    Project mention: How to scale storage of PostgreSQL database? | reddit.com/r/PostgreSQL | 2022-07-01

    Disaggregated storage for Postgres is still a very new technology, both with NeonDB and PolarDB (https://github.com/ApsaraDB/PolarDB-for-PostgreSQL).

  • InfluxDB

    Build time-series-based applications quickly and at scale.. InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.

  • 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: Show HN: Ov – feature rich terminal pager | news.ycombinator.com | 2023-01-03
  • pg_cron

    Run periodic jobs in PostgreSQL

    Project mention: Upgrading to PostgreSQL 15 on Mac OS | dev.to | 2023-01-11

    I’d set up citusdata/pg_cron in 14, so I’ll need to set that up in 15 as well.

  • pgbouncer

    lightweight connection pooler for PostgreSQL

    Project mention: PostgreSQL with PGBouncer | reddit.com/r/PostgreSQL | 2023-01-24

    I also have a related pgbouncer PR open. Feel free to try it out, I'm planning to get it into the next pgbouncer release: https://github.com/pgbouncer/pgbouncer/pull/666

  • 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: Pg_squeeze: An extension to fix table bloat | news.ycombinator.com | 2022-10-04

    That appears to be the case:

    https://github.com/citusdata/cstore_fdw

    >Important notice: Columnar storage is now part of Citus

  • pgBackRest

    Reliable PostgreSQL Backup & Restore

    Project mention: pgBackRest - have you used it and what was your experience? | reddit.com/r/Database | 2023-01-26
  • age

    Graph database optimized for fast analysis and real-time data processing. It is provided as an extension to PostgreSQL. (by apache)

    Project mention: Bullshit Graph Database Performance Benchmarks | news.ycombinator.com | 2023-01-12

    I find projects like apache/age [0] are very promising in this direction. But I wouldn't call graph db's a passing fade. A more appropriate description might be "too important to be left alone, yet not important enough to form a second type of mass market database engine".

    [0] https://github.com/apache/age

  • orioledb

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

    Project mention: Supabase-JS v2 | news.ycombinator.com | 2022-08-16

    sorry to underwhelm!

    if you like Neon, then I imagine you like their database branching model? On Friday we announced[0] our 500K investment into OrioleDB, who are working on branching[1], with the plan to upstream these changes into Postgres core.

    It would be possible for us to run a fork of Postgres today which supports branching, but our long-term view is that developers would prefer a non-forked version of Postgre (to mitigate any risk of lock-in). So we will work on adding branching to Postgres core in the background, which will be a benefit to the entire Postgres ecosystem.

    [0] Announcement:https://supabase.com/blog/supabase-series-b#where-were-going

    [1] https://github.com/orioledb/orioledb/wiki/Database-branching

  • 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: How to locate device illegally downloading on network | reddit.com/r/networking | 2022-05-06
  • pg_auto_failover

    Postgres extension and service for automated failover and high-availability

    Project mention: PG redundancy even in majority failure | reddit.com/r/PostgreSQL | 2022-12-14

    There are tools that make managing such a system easier. Check out patroni, pg_auto_failover or PAF

  • hypopg

    Hypothetical Indexes for PostgreSQL

    Project mention: YugabyteDB hypopg: hypothetical indexes | dev.to | 2022-11-04

    This is an introduction to the hypopg PostgreSQL extension for YugabyteDB 2.15.3.0. Hypopg allows the creation of hypothetical indexes, so indexes that do not really exist. This means this allows you to see what an index would do if it were created, without it actually being created, and therefore not influencing anything on the database. YugabyteDB 2.15.3.0 is a preview version of the YugabyteDB database.

  • pgaudit

    PostgreSQL Audit Extension

  • hydra

    The open source Snowflake alternative. OLAP Postgres (by hydradatabase)

    Project mention: Hydra - Open source data warehouse built on Postgres | reddit.com/r/programming | 2022-12-15
  • 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.

    Project mention: How to mirroring database in postgresql | reddit.com/r/PostgreSQL | 2022-11-28

    You may want to look into pglogical since it replicates sequences as well. I don't think postgres' built-in logical replication replicates sequences.

  • ruby-pg

    A PostgreSQL client library for Ruby

    Project mention: It's not Ruby that's slow, it's your database | news.ycombinator.com | 2022-11-08

    Before we proceed, are you aware that a lot of popular database drivers for Ruby (and Python? not sure) implement the performance-critical bits in good old natively compiled C?

    For example, the Ruby postgres gem: https://github.com/ged/ruby-pg/tree/master/ext

    (I wasn't sure until I checked just now, so I'm not questioning your familiarity with the tech. Just not sure if that's commonly known)

        So no, it's not the database, it's your interpreted language.

  • rum

    RUM access method - inverted index with additional information in posting lists (by postgrespro)

    Project mention: Ask HN: Books about full text search | news.ycombinator.com | 2022-11-24

    for postgres, i highly recommend the rum index over the core fts. rum is written by postgrespro, who also wrote core fts and json indexing in pg.

        https://github.com/postgrespro/rum

  • pgagroal

    High-performance connection pool for PostgreSQL

  • 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). The latest post mention was on 2023-01-26.

C Postgresql related posts

Index

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

Project Stars
1 TimescaleDB 14,397
2 citus 7,822
3 Greenplum 5,558
4 sysbench 4,953
5 psycopg2 2,851
6 PipelineDB 2,537
7 PolarDB-for-PostgreSQL 2,505
8 pspg 1,952
9 pg_cron 1,884
10 pgbouncer 1,879
11 cstore_fdw 1,696
12 pgBackRest 1,502
13 age 1,427
14 orioledb 1,331
15 pmacct 893
16 pg_auto_failover 857
17 hypopg 851
18 pgaudit 833
19 hydra 739
20 pglogical 692
21 ruby-pg 657
22 rum 600
23 pgagroal 559
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com