C postgresql-extension

Open-source C projects categorized as postgresql-extension
Edit details
Topics: Postgresql Postgres C Database Extension
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
featured

Top 20 C postgresql-extension Projects

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

  • 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

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

  • 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

  • plpgsql_check

    plpgsql_check is a linter tool (does source code static analyze) for the PostgreSQL language plpgsql (the native language for PostgreSQL store procedures).

    • Project mention: Supabase Local Dev: migrations, branching, and observability | dev.to | 2023-08-08

    Finally, while you wait for us to make progress on the Language Server, we’ve added support for linting through the excellent plpgsql_check extension.

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

  • 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

    • Project mention: Data Cleaning in SQL | /r/SQL | 2023-06-15

    For Postgres, there is an extension that provides that.

  • tds_fdw

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

  • pguri

    uri type for PostgreSQL

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

  • pg_show_plans

    Show query plans of all currently running SQL statements

  • pgsentinel

    postgresql extension providing Active session history

  • supautils

    PostgreSQL extension that secures a cluster on a cloud environment

  • firebird_fdw

    A PostgreSQL foreign data wrapper (FDW) for Firebird - latest version 1.4.0 (2024-05-11)

  • vasco

    vasco: Discover hidden patterns in your Postgres data

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

  • pg_math

    pg_math extension to support statistical distribution functions for PostgreSQL

  • 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-generate-up-down-series

    My attempt at the benchmark!

  • 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-extension related posts

Index

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

Project Stars
1 Apache AGE 2,768
2 orioledb 2,685
3 hydra 2,668
4 pgaudit 1,203
5 pg_auto_failover 1,042
6 plpgsql_check 609
7 orafce 474
8 pg_similarity 355
9 tds_fdw 356
10 pguri 304
11 pg_tle 307
12 pg_uuidv7 250
13 pg_show_plans 180
14 pgsentinel 161
15 supautils 50
16 firebird_fdw 36
17 vasco 23
18 pg_math 14
19 cookiecutter-postgres-extension 11
20 pg-generate-up-down-series 0

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com