SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 C Postgresql Projects
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-26
As 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.
Distributed PostgreSQL as an extensionProject 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
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 Database - Massively Parallel PostgreSQL for Analytics. An open-source massively parallel data platform for analytics, machine learning and AI.Project mention: Show HN: Postgres WASM | news.ycombinator.com | 2022-10-03
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) 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 ), 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.
Scriptable database and system performance benchmarkProject 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.
PostgreSQL database adapter for the Python programming languageProject mention: Uploading CSVs to a SQL table using Python | reddit.com/r/pythontips | 2023-01-15
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).
High-performance time-series aggregation for PostgreSQL
A cloud-native database based on PostgreSQL developed by Alibaba Cloud.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).
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.
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: Show HN: Ov – feature rich terminal pager | news.ycombinator.com | 2023-01-03
Run periodic jobs in PostgreSQLProject mention: Upgrading to PostgreSQL 15 on Mac OS | dev.to | 2023-01-11
I’d set up citusdata/pg_cron in 14, so I’ll need to set that up in 15 as well.
lightweight connection pooler for PostgreSQLProject mention: PostgreSQL with PGBouncer | reddit.com/r/PostgreSQL | 2023-01-24
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
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.
Reliable PostgreSQL Backup & RestoreProject mention: pgBackRest - have you used it and what was your experience? | reddit.com/r/Database | 2023-01-26
Graph database optimized for fast analysis and real-time data processing. It is provided as an extension to PostgreSQL. (by apache)Project mention: Bullshit Graph Database Performance Benchmarks | news.ycombinator.com | 2023-01-12
I find projects like apache/age  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 – building a modern cloud-native storage engine (... and solving some PostgreSQL wicked problems) 🇺🇦Project mention: Supabase-JS v2 | news.ycombinator.com | 2022-08-16
sorry to underwhelm!
if you like Neon, then I imagine you like their database branching model? On Friday we announced our 500K investment into OrioleDB, who are working on branching, 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.
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
Postgres extension and service for automated failover and high-availabilityProject mention: PG redundancy even in majority failure | reddit.com/r/PostgreSQL | 2022-12-14
There are tools that make managing such a system easier. Check out patroni, pg_auto_failover or PAF
Hypothetical Indexes for PostgreSQLProject mention: YugabyteDB hypopg: hypothetical indexes | dev.to | 2022-11-04
This is an introduction to the hypopg PostgreSQL extension for YugabyteDB 220.127.116.11. 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 18.104.22.168 is a preview version of the YugabyteDB database.
PostgreSQL Audit Extension
The open source Snowflake alternative. OLAP Postgres (by hydradatabase)Project mention: Hydra - Open source data warehouse built on Postgres | reddit.com/r/programming | 2022-12-15
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.Project mention: How to mirroring database in postgresql | reddit.com/r/PostgreSQL | 2022-11-28
You may want to look into pglogical since it replicates sequences as well. I don't think postgres' built-in logical replication replicates sequences.
A PostgreSQL client library for RubyProject mention: It's not Ruby that's slow, it's your database | news.ycombinator.com | 2022-11-08
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 access method - inverted index with additional information in posting lists (by postgrespro)Project mention: Ask HN: Books about full text search | news.ycombinator.com | 2022-11-24
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.
High-performance connection pool for PostgreSQL
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?
1 project | reddit.com/r/Database | 26 Jan 2023
Looking for advice on DE strategy/tools for our growing business
1 project | reddit.com/r/dataengineering | 26 Jan 2023
PostgreSQL with PGBouncer
2 projects | reddit.com/r/PostgreSQL | 24 Jan 2023
Choosing a Postgres Primary Key
3 projects | news.ycombinator.com | 20 Jan 2023
Uploading CSVs to a SQL table using Python
1 project | reddit.com/r/pythontips | 15 Jan 2023
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.
3 projects | reddit.com/r/dotnet | 15 Jan 2023
How would you store this?
1 project | reddit.com/r/Database | 14 Jan 2023
A note from our sponsor - #<SponsorshipServiceOld:0x00007fea5916e3b0>
www.saashub.com | 28 Jan 2023
What are some of the best open-source Postgresql projects in C? This list will help you: