SaaSHub helps you find the best software and product alternatives Learn more →
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-26As 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.
-
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.
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...
-
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.
-
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).
-
-
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.
-
I’d set up citusdata/pg_cron in 14, so I’ll need to set that up in 15 as well.
-
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.
That appears to be the case:
https://github.com/citusdata/cstore_fdw
>Important notice: Columnar storage is now part of Citus
-
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)
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".
-
orioledb
OrioleDB – building a modern cloud-native storage engine (... and solving some PostgreSQL wicked problems) 🇺🇦
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 -
There are tools that make managing such a system easier. Check out patroni, pg_auto_failover or PAF
-
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.
-
-
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.
You may want to look into pglogical since it replicates sequences as well. I don't think postgres' built-in logical replication replicates sequences.
-
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)
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
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
C Postgresql related posts
- pgBackRest - have you used it and what was your experience?
- Looking for advice on DE strategy/tools for our growing business
- PostgreSQL with PGBouncer
- Choosing a Postgres Primary Key
- Uploading CSVs to a SQL table using Python
- I would like to know your advice, I am creating an inventory control software, and I would like to use the PostgreSQL database instead of SQL Server, Could you give me your opinions of the advantages and disadvantages of using one or the other, Thank you.
- How would you store this?
-
A note from our sponsor - #<SponsorshipServiceOld:0x00007fea5916e3b0>
www.saashub.com | 28 Jan 2023
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 |