C Postgresql

Open-source C projects categorized as Postgresql

Top 23 C Postgresql Projects

  • Netdata

    Monitor your servers, containers, and applications, in high-resolution and in real-time.

    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: TimescaleDB: An open-source time-series SQL database | news.ycombinator.com | 2024-02-06
  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  • citus

    Distributed PostgreSQL as an extension

    Project mention: Citus: PostgreSQL extension that transforms Postgres into a distributed database | news.ycombinator.com | 2024-03-14
  • Greenplum

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

    Project mention: Ask HN: It's 2023, how do you choose between MySQL and Postgres? | news.ycombinator.com | 2023-05-11

    Friends don't let their friends choose Mysql :)

    A super long time ago (decades) when I was using Oracle regularly I had to make a decision on which way to go. Although Mysql then had the mindshare I thought that Postgres was more similar to Oracle, more standards compliant, and more of a real enterprise type of DB. The rumor was also that Postgres was heavier than MySQL. Too many horror stories of lost data (MyIsam), bad transactions (MyIsam lacks transaction integrity), and the number of Mysql gotchas being a really long list influenced me.

    In time I actually found out that I had underestimated one of the most important attributes of Postgres that was a huge strength over Mysql: the power of community. Because Postgres has a really superb community that can be found on Libera Chat and elsewhere, and they are very willing to help out, I think Postgres has a huge advantage over Mysql. RhodiumToad [Andrew Gierth] https://github.com/RhodiumToad & davidfetter [David Fetter] https://www.linkedin.com/in/davidfetter are incredibly helpful folks.

    I don't know that Postgres' licensing made a huge difference or not but my perception is that there are a ton of 3rd party products based on Postgres but customized to specific DB needs because of the more liberalness of the PG license which is MIT/BSD derived https://www.postgresql.org/about/licence/

    Some of the PG based 3rd party DBs:

    Enterprise DB https://www.enterprisedb.com/ - general purpose PG with some variants

    Greenplum https://greenplum.org/ - Data warehousing

    Crunchydata https://www.crunchydata.com/products/hardened-postgres - high security Postgres for regulated environments

    Citus https://www.citusdata.com - Distributed DB & Columnar

    Timescale https://www.timescale.com/

    Why Choose PG today?

    If you want better ACID: Postgres

    If you want more compliant SQL: Postgres

    If you want more customizability to a variety of use-cases: Postgres using a variant

    If you want the flexibility of using NOSQL at times: Postgres

    If you want more product knowledge reusability for other backend products: Postgres

  • sysbench

    Scriptable database and system performance benchmark

    Project mention: RDS MySQL Load Testing with Sysbench | dev.to | 2023-04-09

    Sometimes you need to do a load test on MySQL Database to test Auto-Scaling for example. I found a very useful tool called Sysbench that I will present in this article.

  • psycopg2

    PostgreSQL database adapter for the Python programming language

    Project mention: Can I learn Python while practicing writing queries for SQL simultaneously? I've recently completed learning SQL and trying to get better at it. | /r/SQL | 2023-05-10

    You can practice both by using https://www.psycopg.org from your Python code to communicate with your database. When I wanted to practice some SQL, that's what I did (we use psycopg at work, so that's what I practiced with, making a dream journal thingy for myself that was better than just noting stuff in a notepad because I could then look up e.g. what other stuff was correlated with Y, how many times I dreamed of X, etc. etc.)

  • PolarDB-for-PostgreSQL

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

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

  • PipelineDB

    High-performance time-series aggregation for PostgreSQL

    Project mention: PostgreSQL Is Enough | news.ycombinator.com | 2024-02-06
  • 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.

  • orioledb

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

    Project mention: Jepsen: MySQL 8.0.34 | news.ycombinator.com | 2023-12-19

    When I saw "cloud native" I was expecting S3-ish the way Neon does it but they say it's experimental: https://github.com/orioledb/orioledb/blob/beta4/doc/usage.md... and for them to say "beta, don't use in production" and then a separate "experimental" label must make it really bad

  • 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: PostgreSQL Extension Graph Data Processing and Analytics for RDBMS | news.ycombinator.com | 2024-03-14
  • hydra

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

    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:

    https://github.com/citusdata/cstore_fdw

    https://github.com/hydradatabase/hydra

    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.

  • pg_cron

    Run periodic jobs in PostgreSQL

    Project mention: Supabase Beta May 2023 | dev.to | 2023-06-09

    [Postgres Extensions] pg_cron 1.5.2 (new projects only) now supports sub-minute schedules. PR

  • 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

    https://github.com/okbob/pspg

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

    https://github.com/citusdata/cstore_fdw

    https://github.com/hydradatabase/hydra

    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.

  • 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

  • hypopg

    Hypothetical Indexes for PostgreSQL

  • 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

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 2024-03-15.

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 Netdata 67,502
2 TimescaleDB 16,256
3 citus 9,625
4 Greenplum 6,165
5 sysbench 5,706
6 psycopg2 3,165
7 PolarDB-for-PostgreSQL 2,739
8 PipelineDB 2,603
9 pgbouncer 2,582
10 orioledb 2,546
11 Apache AGE 2,533
12 hydra 2,486
13 pg_cron 2,467
14 pspg 2,347
15 pgBackRest 2,139
16 cstore_fdw 1,738
17 pgaudit 1,154
18 hypopg 1,089
19 pg_auto_failover 1,024
20 pmacct 995
21 pglogical 925
22 ruby-pg 747
23 IvorySQL 685
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com