PostgreSQL相关的软件,库,资源等的集合:awesome-postgres

jopen 9年前

PostgreSQL相关的软件,库,工具,资源等的集合。

备份

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

GUI

  • pgAdmin - Postgres Adminisitration and Management GUI
  • phpPgAdmin - The Premier Web Based Administration Tool for Postgres
  • pgweb - Web-based PostgreSQL database browser written in Go

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

Extensions

  • PGStorm - 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

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

Tutorials

Blogs

Newsletters

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

项目主页:http://www.open-open.com/lib/view/home/1447990579244