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: Recommendation for storing active historical "checkpoints" | reddit.com/r/PostgreSQL | 2022-01-13Would Timescale be an option for your use case? Seems like it fits right in.
-
Project mention: The implementation of the UK Covid-19 dashboard | news.ycombinator.com | 2022-01-23
To be accurte, it's not completely Micrsoft agnostic, it make use case for a PSQL extension citus[1], the company behind this extension has been acquired by Microsoft two years ago[2].
-
OPS
OPS - Build and Run Open Source Unikernels. Quickly and easily build and deploy open source unikernels in tens of seconds. Deploy in any language to any cloud.
-
Project mention: How to deploy the Front-end(React) and Backend(Django) with Postgres at Heroku | dev.to | 2021-12-10
psycopg2: Psycopg is a PostgreSQL adapter for the Python programming language.
-
Project mention: Ask HN: Is there a way to subscribe to an SQL query for changes? | news.ycombinator.com | 2021-04-22
PipelineDB might be of interest. https://github.com/pipelinedb/pipelinedb
-
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.
-
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.
The citus extension for postgresql. https://github.com/citusdata/cstore_fdw
-
Project mention: Cascade of doom: JIT, and how a Postgres update led to 70% failure on a critical national service | dev.to | 2021-11-13
Towards the end of the week, a few people reached out to me saying that they were encountering an increasing number of failed requests when using APIv2. They were peculiarly saying that they couldn't download new data from the API after the release. My first action in such cases is to check the API service, and our PGBouncer instances to ensure that they are healthy. Then I usually clear the storage cache for APIv2, which usually solves the problem.
-
Scout APM
Less time debugging, more time building. Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.
-
Project mention: Do you know of a robust library that handles persistent job scheduling and queuing using PostgreSQL | reddit.com/r/golang | 2022-01-15
If you just want scheduling queries, you can use this https://github.com/citusdata/pg_cron
-
Project mention: pgbackrest localhost backup works fine, but a remote backup call fails | reddit.com/r/PostgreSQL | 2021-10-04
-
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: Simpler Postgresql replication setup (NO managed services) | reddit.com/r/PostgreSQL | 2021-12-15
My go to for this is https://github.com/citusdata/pg_auto_failover set up with ansible https://github.com/neuroforgede/pg\_auto\_failover\_ansible
-
-
Project mention: How Postgres Audit Tables Saved Us from Taking Down Production | news.ycombinator.com | 2021-10-26
You can use pgaudit, it's an extension that let's you audit DDL/DML statements. It's a great auditing mechanism. I use it on all our prod postgres instances, but have only "DML" enabled, because of the potential performance overhead
-
-
Project mention: Pgagroal: High-performance connection pool for PostgreSQL | news.ycombinator.com | 2021-11-21
-
Project mention: Postgrespro/rum: RUM access method – inverted index with additional information | news.ycombinator.com | 2021-12-17
-
plpgsql_check
plpgsql_check is linter tool for language PL/pgSQL (native language for PostgreSQL store procedures).
Project mention: PostGIS – Spatial and Geographic Objects for PostgreSQL | news.ycombinator.com | 2021-04-05 -
-
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.
This extension have some functions to work with business days https://github.com/orafce/orafce, search for “bizdays”
-
tds_fdw
A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)
Or, you could use a foreign data wrapper: https://github.com/tds-fdw/tds_fdw
-
Project mention: Show HN: Pgsodium – A Crytographic PostgreSQL Extension | news.ycombinator.com | 2022-01-10
Hey HN, I shared an earlier prototype version of pgsodium but I just released 2.0 and felt this could be a good opportunity to share some updates!
[pgsodium](https://github.com/michelp/pgsodium) 2.0.0 is a postgres extension that uses the [libsodium](https://doc.libsodium.org/) library to provide high-performance, modern cryptography support for PostgreSQL 10+.
2.0.0 includes a ton of new feature and a few bug-fixes:
* Support for [XChaCha20-SIV](https://github.com/jedisct1/libsodium-xchacha20-siv) deterministic nonce-free encryption, this is useful for one-time workflows sacrificing a bit of speed and larger key size without worrying about nonce-handling issues.
-
Project mention: Any Tips for Analyzing (Concurrent) Transaction Performance? | reddit.com/r/PostgreSQL | 2021-12-01
pgsentinel
-
The syntactic similarity is not enough for you? Word2vec could be an option to compare the semantic similarity of words. Luckily there already is a postgres-word2vec extension for this.
C Postgresql related posts
Index
What are some of the best open-source Postgresql projects in C? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | TimescaleDB | 12,368 |
| 2 | citus | 5,697 |
| 3 | psycopg2 | 2,457 |
| 4 | PipelineDB | 2,449 |
| 5 | pspg | 1,772 |
| 6 | cstore_fdw | 1,644 |
| 7 | pgbouncer | 1,503 |
| 8 | pg_cron | 1,498 |
| 9 | pgbackrest | 1,015 |
| 10 | pmacct | 785 |
| 11 | pg_auto_failover | 721 |
| 12 | hypopg | 665 |
| 13 | pgaudit | 655 |
| 14 | ruby-pg | 521 |
| 15 | pgagroal | 504 |
| 16 | rum | 496 |
| 17 | plpgsql_check | 374 |
| 18 | pgquarrel | 328 |
| 19 | orafce | 320 |
| 20 | tds_fdw | 265 |
| 21 | pgsodium | 243 |
| 22 | pgsentinel | 110 |
| 23 | postgres-word2vec | 109 |
Are you hiring? Post a new remote job listing for free.
