Skip to content

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

License

Notifications You must be signed in to change notification settings

mtuncer/awesome-postgres

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 

Repository files navigation

Awesome Postgres

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

###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)
  • DBeaver - Universal Database Manager with excellent support for Postgres
  • pgAdmin - Postgres Administration and Management GUI
  • pgModeler - pgModeler is an open-source PostgreSQL Database Modeler
  • pgweb - Web-based PostgreSQL database browser written in Go
  • phpPgAdmin - The Premier Web Based Administration Tool for Postgres
  • 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
  • SQLPro for Postgres - A simple, powerful Postgres manager for Mac OS X (Commercial Software)
  • Warp - OS X desktop tool for by-example querying and data transfer from/to PostgreSQL

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
  • libzbxpgsql - A comprehensive PostgreSQL monitoring module for Zabbix
  • Pome - Pome stands for Postgres Metrics. Pome is a PostgreSQL Metrics Dashboard to keep track of the health of your database
  • pg_view - An open-source command-line tool that shows global system stats, per-partition information, memory stats and other information

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
  • zomboDB - Postgres extension that enables efficient full-text searching via the use of indexes backed by Elasticsearch
  • cstore_fdw - Columnar store for analytics with PostgreSQL

Optimization

  • PgHero - Postgres insights made easy
  • pgtune - PostgreSQL configuration wizard
  • pgtune - Online version of 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
  • PgBouncer - Lightweight connection pooler for PostgreSQL

Language bindings

Tutorials

Blogs

Articles

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.
  • Heroku Postgres - Plans from free to huge, operated by Postgres experts. Does not require running your app on Heroku. Free plan includes 10,000 rows, 20 connections, up to two backups, and has PostGIS support.

About

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

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published