C Postgres

Open-source C projects categorized as Postgres

Top 23 C Postgre Projects

  • TimescaleDB

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

    Project mention: List of 45 databases in the world | dev.to | 2024-07-09

    Timescale — Open-source time-series SQL database optimized for fast ingest and complex queries.

  • 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: Show HN: Serverless Postgres | news.ycombinator.com | 2024-05-29
  • 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/

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

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

  • wal2json

    JSON output plugin for changeset extraction

  • pg_auto_failover

    Postgres extension and service for automated failover and high-availability

  • SaaSHub

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

    SaaSHub logo
  • pg_similarity

    set of functions and operators for executing similarity queries

  • pg_tle

    Framework for building trusted language extensions for PostgreSQL

    Project mention: Pgcopydb: Copy a Postgres database to a target Postgres server | news.ycombinator.com | 2024-04-25

    Have you tried this in databases with [TLE](https://github.com/aws/pg_tle)s?

  • pg_uuidv7

    A tiny Postgres extension to create version 7 UUIDs

    Project mention: Shrink UUIDs with PostgreSQL or Ruby | dev.to | 2024-02-23

    Unfortunately, as of PostgreSQL 16, UUIDv7 are not yet supported out of the box. For the time being, use an extension such as pg_uuidv7 or pg_idkit to generate UUIDv7 e.g. as default primary key when you CREATE new records.

  • pgJQ

    jq extension for Postgres

    Project mention: Ask HN: People that use jq extensively, I'd like to talk to you | news.ycombinator.com | 2024-05-06

    For example, I've made a jq extension for SQLite (https://github.com/Florents-Tselai/liteJQ) and another for Postgres (https://github.com/Florents-Tselai/pgJQ).

    I'm now working on something a bit more ambitious and AI-related but it's not ready for public beta yet.

  • pgspider

    High-Performance SQL Cluster Engine for Scalable Data Virtualization

  • pgsentinel

    postgresql extension providing Active session history

  • pg_hexedit

    Open PostgreSQL relation files in a hex editor with tags and annotations

  • pg_wait_sampling

    Sampling based statistics of wait events

  • pg_plan_guarantee

    Postgres Query Optimizer Extension that guarantees your desired plan will not change

  • pg-ulid

    PostgreSQL extension for ULID (by andrielfn)

    Project mention: PostgreSQL Extension for ULID | news.ycombinator.com | 2023-08-18
  • vasco

    vasco: Discover hidden patterns in your Postgres data

    Project mention: Exploring Stock Correlations in Postgres | news.ycombinator.com | 2024-05-19
  • postgres

    PostgreSQL in Neon (by neondatabase)

    Project mention: Neon Is Generally Available: Serverless Postgres | news.ycombinator.com | 2024-04-15

    Our fork of Postgres is located at https://github.com/neondatabase/postgres.

  • postgres_web3

    PostgreSQL extension implementing optimized data types for web3 applications

  • cookiecutter-postgres-extension

    cookiecutter template for a Postgres extension

    Project mention: Hacking on PostgreSQL Is Hard | news.ycombinator.com | 2024-05-05

    Developing a pg extension is all about compiling some C code into a .so object and dynamically using a templated Makefile to load it into the running Postgres process.

    If you want some boilerplate to get you started I've been using this cookie-cutter template to bootstrap lots of extensions https://github.com/Florents-Tselai/cookiecutter-postgres-ext...

    Demo walkthrough: https://www.youtube.com/watch?v=zVxY3ZmE5bU

    Contributing to core Postgres, it's an entirely different story.

  • pg_handlebars

  • parallel-qo-postgres

    (not) Parellel Query Optimizer for Postgres. In this fork of Postgres, we replace the original query optimizer with a parallelized query optimizer based on the work of Trummer et al.

  • 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 Postgres discussion

Log in or Post with

C Postgres related posts

Index

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

Project Stars
1 TimescaleDB 16,904
2 citus 10,134
3 orioledb 2,750
4 hydra 2,729
5 pgBackRest 2,344
6 wal2json 1,272
7 pg_auto_failover 1,067
8 pg_similarity 358
9 pg_tle 319
10 pg_uuidv7 273
11 pgJQ 176
12 pgspider 172
13 pgsentinel 160
14 pg_hexedit 145
15 pg_wait_sampling 136
16 pg_plan_guarantee 89
17 pg-ulid 44
18 vasco 26
19 postgres 21
20 postgres_web3 19
21 cookiecutter-postgres-extension 12
22 pg_handlebars 4
23 parallel-qo-postgres 4

Sponsored
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.
www.influxdata.com