21 January 2023

PostgreSQL cheatsheet (advance)

cstore_fdw - Columnar store for analytics with PostgreSQL.

cyanaudit - Cyan Audit provides in-database logging of all DML activity on a column-by-column basis.

pg_cron - Run periodic jobs in PostgreSQL.

pglogical - Extension that provides logical streaming replication.

pg_partman - Partition management extension for PostgreSQL.

pg_paxos - Basic implementation of Paxos and Paxos-based table replication for a cluster of PostgreSQL nodes.

pg_shard - Extension to scale out real-time reads and writes.

PGStrom - Extension to offload CPU-intensive workloads to GPU.

pgxn PostgreSQL Extension Network - central distribution point for many open-source PostgreSQL extensions

PipelineDB - A PostgreSQL extension that runs SQL queries continuously on streams, incrementally storing results in tables.

plpgsql_check - Extension that allows to check plpgsql source code.

PostGIS - Spatial and Geographic objects for PostgreSQL.

PG_Themis - Postgres binding as an extension for crypto library Themis, providing various security services on PgSQL's side.

zomboDB - Extension that enables efficient full-text searching via the use of indexes backed by Elasticsearch.

pgMemento - Provides an audit trail for your data inside a PostgreSQL database using triggers and server-side functions written in PL/pgSQL.

timescaleDB - Open-source time-series database fully compatible with Postgres, distributed as an extension

pgTAP - Database testing framework for Postgres


No comments:

Post a Comment