#POSTGRESQL RANK ARCHIVE#

Metabase - Simple dashboards, charts and query tool for PostgreSQL.

JackDB - Web-based SQL query interface (Commercial Software).

Holistics - Online cross platform database management tool and SQL query reporting GUI with strong PostgreSQL support (Commercial Software).

dbglass - Cross-platform desktop client for PostgreSQL, built with Electron.

DBeaver - Universal Database Manager with excellent support for PostgreSQL.

Datazenit - Web-based PostgreSQL GUI (Commercial Software).

DataGrip - IDE with advanced tool sets and good cross-platform experience (Commercial Software).

OmniDB - Open Source Collaborative Environment.

Adminer - Full-featured database management tool written in PHP.

pitrery - pitrery is a set of Bash scripts to manage Point In Time Recovery (PITR) backups for PostgreSQL.

wal-e ★2574 - Simple Continuous Archiving for PostgreSQL to S3, Azure, or Swift by Heroku.

pghoard - Backup and restore tool for cloud object stores (AWS S3, Azure, Google Cloud, OpenStack Swift).

pg_back ★47 - pg_back is a simple backup script.pgBackRest - Reliable PostgreSQL Backup & Restore.

#POSTGRESQL RANK ARCHIVE#

pg_probackup ★94 – A fork of pg_arman, improved by supports incremental backups, backups from replica, multithreaded backup and restore, and anonymous backup without archive command.OmniPITR ★147 - Advanced WAL File Management Tools for PostgreSQL.Barman - Backup and Recovery Manager for PostgreSQL by 2ndQuadrant.SkyTools ★244 ⏳1Y - Replication tools, including PgQ, a queuing system, and Londiste, a replication system a bit simpler to manage than Slony.PAF ★1 - PostgreSQL Automatic Failover: High-Availibility for Postgres, based on Pacemaker and Corosync.Slony-I - “Master to multiple slaves” replication system with cascading and failover.repmgr ★936 - Open-source tool suite to manage replication and failover in a cluster of PostgreSQL servers.pglookout - Replication monitoring and failover daemon.Stolon ★1432 - PostgreSQL HA based on Consul or etcd, with Kubernetes integration.Patroni ★1698 - Template for PostgreSQL HA with ZooKeeper or etcd.BDR ★266 - BiDirectional Replication - a multimaster replication system for PostgreSQL.Please take a look at the contribution guidelines. Add links through pull requests or create an issue to start a discussion. (see more: wikipedia:PostgreSQL, )Ĭontributions welcome. PostgreSQL is ACID-compliant and transactional. PostgreSQL, often simply Postgres, is an object-relational database (ORDBMS). The next position is 21st, 22nd, which continued counting as normal.This list is a copy of dhamaniasad/awesome-postgres with ranksĪ curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql If we want her to be in 21st place, we can use DENSE_RANK. That could be how we want to do it if we want to base this solely on the number of competitors. Then when we take a look at the next person, Liz comes in 22nd place instead of 21st place. We wouldn't want to use ROW_NUMBER here because then, the first person who is arbitrarily ordered gets 20th place and then the next gets 21st place.

The person who came in second place had the next fastest, etc. The person who came in first place had the fastest pace. Again, we have them partition by the division, but we don't have them ordered in any specific way. We'll just take a look at what this looks like so far. We will create a partition for each division. Let's rank them, actually, by their division. Here, I've got a list of runners in a race.

Postgresql rank