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: Recommendation for storing active historical "checkpoints" | reddit.com/r/PostgreSQL | 2022-01-13
Would Timescale be an option for your use case? Seems like it fits right in.
Distributed PostgreSQL as an extensionProject 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, the company behind this extension has been acquired by Microsoft two years ago.
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.
PostgreSQL database adapter for the Python programming languageProject 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.
High-performance time-series aggregation for PostgreSQL
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: Pspg – Postgres Pager | news.ycombinator.com | 2021-12-23
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.Project mention: Creating a simple data pipeline | reddit.com/r/dataengineering | 2021-05-20
The citus extension for postgresql. https://github.com/citusdata/cstore_fdw
lightweight connection pooler for PostgreSQLProject 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.
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.
Run periodic jobs in PostgreSQLProject 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
Reliable PostgreSQL Backup & RestoreProject mention: pgbackrest localhost backup works fine, but a remote backup call fails | reddit.com/r/PostgreSQL | 2021-10-04
pmacct is a small set of multi-purpose passive network monitoring tools [NetFlow IPFIX sFlow libpcap BGP BMP RPKI IGP Streaming Telemetry].Project mention: IPv4 vs IPv6 traffic stats | reddit.com/r/mikrotik | 2022-01-04
Postgres extension and service for automated failover and high-availabilityProject 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
Hypothetical Indexes for PostgreSQLProject mention: Postgres Indexes for Newbies | news.ycombinator.com | 2022-01-19
PostgreSQL Audit ExtensionProject 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
A PostgreSQL client library for RubyProject mention: Explaining Ruby Fibers | reddit.com/r/ruby | 2021-10-21
High-performance connection pool for PostgreSQLProject mention: Pgagroal: High-performance connection pool for PostgreSQL | news.ycombinator.com | 2021-11-21
RUM access method - inverted index with additional information in posting listsProject mention: Postgrespro/rum: RUM access method – inverted index with additional information | news.ycombinator.com | 2021-12-17
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
pgquarrel compares PostgreSQL database schemas (DDL)Project mention: Anyone using pgCodeKeeper? | reddit.com/r/PostgreSQL | 2021-01-30
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.Project mention: Business Days | reddit.com/r/PostgreSQL | 2021-11-05
This extension have some functions to work with business days https://github.com/orafce/orafce, search for “bizdays”
A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)Project mention: Babelfish: the Elephant in the Room? | reddit.com/r/PostgreSQL | 2021-02-17
Or, you could use a foreign data wrapper: https://github.com/tds-fdw/tds_fdw
Modern cryptography for PostgreSQL using libsodium.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.
postgresql extension providing Active session historyProject mention: Any Tips for Analyzing (Concurrent) Transaction Performance? | reddit.com/r/PostgreSQL | 2021-12-01
utils to use word embedding models like word2vec vectors in a PostgreSQL databaseProject mention: Build a fuzzy search with PostgreSQL | dev.to | 2021-03-12
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
Tips for installing Citus and Postgres packages
2 projects | reddit.com/r/SQL | 22 Jan 2022
Postgres Indexes for Newbies
1 project | news.ycombinator.com | 19 Jan 2022
Recommendation for storing active historical "checkpoints"
1 project | reddit.com/r/PostgreSQL | 13 Jan 2022
Show HN: Pgsodium – A Crytographic PostgreSQL Extension
4 projects | news.ycombinator.com | 10 Jan 2022
Pgsodium 2.0.0: Modern cryptography for PostgreSQL
3 projects | news.ycombinator.com | 9 Jan 2022
pg_cron: Run periodic jobs in PostgreSQL
1 project | reddit.com/r/luckystarr | 4 Jan 2022
1 project | news.ycombinator.com | 4 Jan 2022
What are some of the best open-source Postgresql projects in C? This list will help you:
Are you hiring? Post a new remote job listing for free.