awesome-postgresql

A curated list of awesome PostgreSQL tools, scripts, slides, and short examples. inspired by the other awesome lists.

• awesome-postgresql
  • Extensions / Tools
  • Utilities
    • [Useful Scripts] (#useful-scripts)
    • [Useful Examples] (#useful-examples)
    • Useful Slides
    • Roadmaps

Extensions and Tools

• Citus - Citus horizontally scales PostgreSQL across commodity servers using sharding and replication. Its query engine parallelizes incoming SQL queries across these servers to enable real-time responses on large datasets.
• ldap2pg - manage roles and ACL.
• PL/V8 - Content for starting and do quick consults about PL/V8.
• PGBouncer - Lightweight connection pooler for PostgreSQL.
• pgpool-II - Connection pooler, load balancer, replicator, also implementing parallel query.
• PGStrom (GPU Process) - Designed to off-load several CPU intensive workloads to GPU devices.
• PostgREST - Standalone web server that tuns your database directly into a RESTful API.
• pgloader - Load data into PostgreSQL. Any Data.
• pgbundle - Manage your PostgreSQL extensions with Pgbundle.
• pgcli - Postgres CLI with autocompletion and syntax highlighting.
• Barman - Backup and recovery manager.
• psql2csv - Run a query in psql and output the result as CSV.
• pome - A Postgres Metrics Dashboard which can be deployed as a binary.
• pg_bulkload - It's a high speed data loading utility for PostgreSQL.
• pg - Browser PostgreSQL, no server, just client and pglite (postgresql wasm)
• Bemi - Automatic data change tracking for PostgreSQL.

SQL plan visualizers

• Depesz
• Tatiyants

Utilities

Useful scripts

• Views dependency handle - Script to handle with tabe and view dependencies easy.
• pg-ldap-sync - This program helps to solve the issue by synchronizing users, groups and their memberships from LDAP to PostgreSQL
• pgldapsync - Python module that allows you to synchronize Postgres login roles with users in an LDAP directory

Useful Examples

• Listen / Notify in Node.js - Tiny how to use about listen / notify
• JSON Queries - Real examples of using lateral joins and recursive queries on JSON structures
• Using postgresql - Real examples about using postgresql with awesome examples

Useful slides

• Full text search (PT_BR) - Deep intro on full text search on postgresql
• PostgREST + Mihtril.js - Real example of postREST using

Roadmaps

• PostgreSQL Roadmap - Complete step-by-step guide to PostgreSQL

Blogs

• 2ndQuadrant
• PostgreSQL-Consulting
• Depesz

Screencasts

• PG Casts