SaaSHub helps you find the best software and product alternatives Learn more →
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.
-
-
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.
-
orioledb
OrioleDB – building a modern cloud-native storage engine (... and solving some PostgreSQL wicked problems) 🇺🇦
-
hydra
Hydra: Column-oriented Postgres. Add scalable analytics to your project in minutes. (by hydradatabase)
-
-
-
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.
-
-
-
-
-
pg_plan_guarantee
Postgres Query Optimizer Extension that guarantees your desired plan will not change
-
-
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
Project mention: TimescaleDB: An open-source time-series SQL database | news.ycombinator.com | 2024-02-06
Project mention: SPQR 1.3.0: a production-ready system for horizontal scaling of PostgreSQL | news.ycombinator.com | 2024-03-25
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/
Don't feel bad, lots of people get bitten by not reading all the way down to the bottom of their readme: https://github.com/hydradatabase/hydra/blob/v1.1.2/README.md... While Hydra may very well license their own code Apache 2, they ship the AGPLv3 columnar which to my very best IANAL understanding taints the whole stack and AGPLv3's everything all the way through https://github.com/hydradatabase/hydra/blob/v1.1.2/columnar/...
This tutorial explains how to backup PostgreSQL database using pgBackRest and S3.
To illustrate the above, let’s look at an example, using wal2json for convenience. An update event looks something like this:
For Postgres, there is an extension that provides that.
Project mention: Pgcopydb: Copy a Postgres database to a target Postgres server | news.ycombinator.com | 2024-04-25Have you tried this in databases with [TLE](https://github.com/aws/pg_tle)s?
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.
Project mention: Postgres Extension to Calculate the Maximal Information Coefficient (Mic) | news.ycombinator.com | 2024-04-10
Project mention: Neon Is Generally Available: Serverless Postgres | news.ycombinator.com | 2024-04-15Our fork of Postgres is located at https://github.com/neondatabase/postgres.
Project mention: postgres_web3: PostgreSQL extension implementing optimized data types for web3 applications | /r/PostgreSQL | 2023-04-27
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 related posts
- Pgcopydb: Copy a Postgres database to a target Postgres server
- Supabase Acquires OrioleDB
- Postgres Extension to Calculate the Maximal Information Coefficient (Mic)
- Building a Managed Postgres Service in Rust
- Show HN: PgJQ: Use Jq in Postgres
- Postgres is eating the database world
- pgJQ: Use Jq in Postgres
-
A note from our sponsor - SaaSHub
www.saashub.com | 26 Apr 2024
Index
What are some of the best open-source Postgre projects in C? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | TimescaleDB | 16,472 |
| 2 | citus | 9,801 |
| 3 | orioledb | 2,631 |
| 4 | hydra | 2,620 |
| 5 | pgBackRest | 2,194 |
| 6 | wal2json | 1,236 |
| 7 | pg_auto_failover | 1,035 |
| 8 | pg_similarity | 352 |
| 9 | pg_tle | 299 |
| 10 | pg_uuidv7 | 232 |
| 11 | pgJQ | 170 |
| 12 | pgspider | 170 |
| 13 | pgsentinel | 157 |
| 14 | pg_hexedit | 143 |
| 15 | pg_wait_sampling | 132 |
| 16 | pg_plan_guarantee | 83 |
| 17 | pg-ulid | 30 |
| 18 | vasco | 20 |
| 19 | postgres | 20 |
| 20 | postgres_web3 | 19 |
| 21 | cookiecutter-postgres-extension | 8 |
| 22 | parallel-qo-postgres | 4 |
| 23 | pg_handlebars | 4 |
Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com