basiszwo/awesome-postgres

A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql

Awesome Postgres

A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql

• Awesome Postgres
  • Backups
  • GUI
  • Distributions
  • CLI
  • Server
  • Monitoring
  • Extensions
  • Optimization
  • Utilities
  • Language bindings
  • Tutorials
  • Blogs
  • Newsletters
  • PaaS (Hosted Postgres)

###High-Availability

• Patroni - A template for PostgreSQL HA with ZooKeeper or etcd

Backups

• wal-e - Simple Continuous Archiving for Postgres to S3, Azure, or Swift by Heroku
• Barman - Backup and Recovery Manager for Postgres by 2ndQuadrant

GUI

• DataGrip - An IDE with advanced tool sets and good cross-platform experience (Commercial Software)
• Datazenit - Web-based PostgreSQL GUI (Commercial Software)
• pgAdmin - Postgres Administration and Management GUI
• phpPgAdmin - The Premier Web Based Administration Tool for Postgres
• pgweb - Web-based PostgreSQL database browser written in Go
• Postico - A Modern PostgreSQL Client for OS X (Commercial Software)
• PSequel - PSequel provides a clean and simple interface for you to perform common PostgreSQL tasks quickly (Commercial Software)
• SQL Tabs - A Cross Platform Desktop Client for Postgres written in JS

Distributions

• Postgres.app - The Easiest Way to Get Started with PostgreSQL on the Mac

CLI

• pgcli - Postgres CLI with autocompletion and syntax highlighting
• psql2csv - Run a query in psql and output the result as CSV

Server

• Postgres-XL - Scalable Open Source PostgreSQL-based Database Cluster

Monitoring

• Check_postgres - Nagios check_postgres plugin for checking status of PostgreSQL databases
• Pome - Pome stands for Postgres Metrics. Pome is a PostgreSQL Metrics Dashboard to keep track of the health of your database

Extensions

• PGStrom - Postgres extension to offload CPU intensive workloads to GPU
• pg_shard - PostgreSQL extension to scale out real-time reads and writes
• PostGIS - Spatial and Geographic objects for PostgreSQL
• pg_paxos - Basic implementation of Paxos and Paxos-based table replication for a cluster of PostgreSQL nodes

Optimization

• PgHero - Postgres insights made easy
• pgtune - PostgreSQL configuration wizard

Utilities

• PostgREST - PostgREST serves a fully RESTful API from any existing PostgreSQL database
• mysql-postgresql-converter - Lanyrd's MySQL to PostgreSQL conversion script
• postgresql-metrics - Tool that extracts and provides metrics on your PostgreSQL database
• pgloader - Pgloader loads data into PostgreSQL using the COPY streaming protocol, and does so with separate threads for reading and writing data
• pgbadger - a fast PostgreSQL Log Analyzer
• pg_activity - pg_activity is a top like application for PostgreSQL server activity monitoring
• pgfutter - Import CSV and JSON into PostgreSQL the easy way
• pganalyze - PostgreSQL Performance Monitoring (Commercial Software)
• yoke - Postgres high-availability cluster with auto-failover and automated cluster recovery
• pgCenter - Provides convenient interface to various statistics, management task, reloading services, viewing log files and canceling or terminating database backends
• ERAlchemy - ERAlchemy generates Entity Relation (ER) diagram from databases
• apgdiff - Compares two database dump files and creates output with DDL statements that can be used to update old database schema to new one

Language bindings

• Go: pgx
• Rust: rust-postgresql
• Perl: DBD-Pg
• Java: PostgreSQL JDBC Driver
• Node: node-postgres
• PHP: Pomm
• Common Lisp: Postmodern
• Elixir: postgrex
• Python: psycopg2

Tutorials

• tutorialspoint PostgreSQL tutorial - A very extensive collection of tutorials on PostgreSQL
• Postgres Guide - A guide designed as an aid for beginners and experienced users to find specific tips and explore tools available within Postgres
• Backup and recover a Postgres DB using wal-e - A tutorial about setting up continuous archiving in PostgreSQL using wal-e
• PostgreSQL Exercises - A site to make it easy to learn PostgreSQL by doing

Blogs

• Planet PostgreSQL - A blog aggregation service for PostgreSQL
• Craig Kerstiens Postgres Posts - A set of posts on Postgres cool features/tips/tricks

Articles

• What PostgreSQL has over other open source SQL databases: Part I

Newsletters

• Postgres Weekly - A weekly newsletter that contains articles, news, and repos relevant to Postgres

PaaS

(Postgres as a Service)

• Database Labs - Get a production-ready cloud Postgres server in minutes, from $20 a month. Backups, monitoring, patches, and 24/7 tech support all included.
• ElephantSQL - Offers databases ranging from shared servers for smaller projects and proof of concepts, up to enterprise grade multi server setups. Has free plan for up to 5 DBs, 20 MB each.