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

Extensions and Tools

• 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.
• pgcli - Postgres CLI with autocompletion and syntax highlighting.
• Barman - Backup and recovery manager.

Utilities

Useful scripts

• Views dependency handle - Script to handle with tabe and view dependencies easy.

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