Slony-I - Replication System for PostgreSQL

•    C

---

Slony-I is a "master to multiple slaves" replication system with cascading and failover. Slony-I is a system designed for use at data centers and backup sites, where the normal mode of operation is that all nodes are available.

replication postgres-tools db-tools database-utlities

Pgpool - Middleware between PostgreSQL Client and Server

•    C

---

pgpool-II is a middleware that works between PostgreSQL servers and a PostgreSQL database client. It supports connection pooling, Using the replication function enables creating a realtime backup on 2 or more physical disks, so that the service can continue without stopping servers in case of a disk failure, Load balance the queries, It can execute queries in parallel to multiple servers.

connection-pool postgresql-tools database-library middleware backup

SQL Relay - Database Connection Pool library with API available in all programming languages

•    C++

---

SQL Relay is a persistent database connection pooling, proxying and load balancing system for Unix and Linux supporting ODBC, and all major databases. It has APIs for C, C++, ODBC, Perl, Perl-DBI, Python, Python-DB, Zope, PHP, Ruby, Ruby-DBI, Java, TCL and Erlang, drop-in replacement libraries for MySQL and PostgreSQL clients.

connection-pool database-connection-pool database-proxy mysql-proxy database-migration load-balancing query-routing replication

knex.js - A SQL query builder that is flexible, portable, and fun to use

•    Javascript

---

Knex.js is a "batteries included" SQL query builder for Postgres, MSSQL, MySQL, MariaDB, SQLite3, Oracle, and Amazon Redshift designed to be flexible, portable, and fun to use. It features both traditional node style callbacks as well as a promise interface for cleaner async flow control, a stream interface, full featured query and schema builders, transaction support (with savepoints), connection pooling and standardized responses between different query clients and dialects.

query-builder orm connection-pool database-library database-tools

DB Lens - Database explorer for Mac, Windows & Linux

•    TypeScript

---

DB Lens is an open-source database client that helps you to explore database, understand data relations more quickly with automatic ER diagrams, visualise and analyse internal DB metrics such as index utilisation sequential scans, slow running queries, storage and many more.

electron postgres database-management database-explorer database db boilerplate react typescript ts database-manager database-gui database-tools

Maatkit - Power tools for open-source databases

•    Perl

---

Maatkit is a toolkit for users, developers, and administrators of open-source databases. Most of Maatkit’s functionality is designed for MySQL. It makes MySQL easier and safer to manage. Maatkit could be used to prove replication is working correctly, fix corrupted data, automate repetitive tasks, speed up your servers, and much more.

database-utilities tools admin-tools db-tool

Citus - Scalable PostgreSQL for multi-tenant and real-time workloads

•    C

---

Citus is a distributed database that scales across commodity servers using transparent sharding and replication. Citus extends the underlying database rather than forking it, giving developers and enterprises the power and familiarity of a relational database. As an extension, Citus supports new PostgreSQL releases, and allows you to benefit from new features while maintaining compatibility with existing PostgreSQL tools.

database citus multi-tenant postgresql scale sharding sql distributed-database postgres

PostgreSQL Metrics - Tool that extracts and provides metrics on your PostgreSQL database

•    Python

---

Service to extract and provide metrics on your PostgreSQL database. This tool is a CLI (command line) tool that can be called to extract statistics and create metrics regarding your PostgreSQL database cluster. CLI is runnable in long running process mode, which will periodically send the gathered metrics forward.

metrics database-metrics postgres postgres-tools

pgcenter - Command-line admin tool for observing and troubleshooting Postgres.

•    Go

---

pgCenter is a command-line admin tool for observing and troubleshooting Postgres. Postgres provides various activity statistics that include detailed information about its behaviour: connections, statements, database operations, replication, resources usage and more. General purpose of the statistics is to help DBAs to monitor and troubleshoot Postgres. However, these statistics provided in textual form retrieved from SQL functions and views, and Postgres doesn't provide any tools for working with them. pgCenter's main goal is to help Postgres DBA manage statistics that theу have in their databases and see all the necessary data in convenient format based on builtin stats views and functions.

postgresql postgresql-statistics postgresql-admin

ssb-db - A database of unforgeable append-only feeds, optimized for efficient replication for peer to peer protocols

•    Javascript

---

A database of unforgeable append-only feeds, optimized for efficient replication for peer to peer protocols. ssb-db provides tools for dealing with unforgeable append-only message feeds. You can create a feed, post messages to that feed, verify a feed created by someone else, stream messages to and from feeds, and more (see API).

repmgr - The Most Popular Replication Manager for PostgreSQL (Postgres) - latest version 4

•    C

---

repmgr is a suite of open-source tools to manage replication and failover within a cluster of PostgreSQL servers. It enhances PostgreSQL's built-in replication capabilities with utilities to set up standby servers, monitor replication, and perform administrative tasks such as failover or switchover operations. repmgr 4 is a complete rewrite of the existing repmgr codebase, allowing the use of all of the latest features in PostgreSQL replication.

repmgr replication postgresql postgres

mosql - MongoDB to PostgreSQL Streaming Replication

•    Ruby

---

MoSQL imports the contents of your MongoDB database cluster into a PostgreSQL instance, using an oplog tailer to keep the SQL mirror live up-to-date. This lets you run production services against a MongoDB database, and then run offline analytics or reporting using the full power of SQL.

database-replication database-utilities db-tools

SQLx - The Rust SQL Toolkit

•    Rust

---

SQLx is an async, pure Rust SQL crate featuring compile-time checked queries without a DSL. It is truly Asynchronous. Built from the ground-up using async/await for maximum concurrency. It has support for PostgreSQL, MySQL, SQLite, and MSSQL.

mysql postgres sql async sqlite postgresql mariadb mssql await orm sql-builder connection-pool

Bucardo - Asynchronous PostgreSQL Replication System

•    Perl

---

Bucardo is an asynchronous PostgreSQL replication system, allowing for both multi-master and multi-slave operations.

database-replication replication db-tools

BoneCP - The JDBC Connection Pool

•    Java

---

BoneCP is a fast, Java database connection pool (JDBC Pool) library.

connection-pool database-connection-pool library statement-pooling

node-pg-migrate - Node.js database migration management for Postgresql

•    Javascript

---

Node.js database migration management built exclusively for postgres. (But can also be used for other DBs conforming to SQL standard - e.g. CockroachDB.) Started by Theo Ephraim, now maintained by Salsita Software. You can specify your database connection information using config.

database db migrate migration migrations migrator db-migrate pg postgre postgres postgresql sql extensible expandable programatic programable api

JugglingDB - Multi-database ORM in NodeJS

•    Javascript

---

JugglingDB is cross-db ORM for nodejs, providing common interface to access most popular database formats. Currently supported are: mysql, sqlite3, postgres, mongodb, redis and js-memory-storage (yep, self-written engine for test-usage only). You can add your favorite database adapter, checkout one of the existing adapters to learn how.

orm db-tools nodejs-orm database-adaptor

SQL Operations Studio - Data management tool that enables working with SQL Server, Azure SQL DB and SQL DW

•    TypeScript

---

SQL Operations Studio is a data management tool that enables you to work with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux. Its feature include SQL Server Connection Management with Connection Dialog, Server Groups, Azure Integration and Registered Servers, T-SQL Query Editor with advanced coding features such as autosuggestions, error diagnostics, tooltips, formatting and peek definition, Management Dashboard supporting customizable widgets with drill-through actionable insights and lot more.

database-management dbms database-tools

Fireworq - Lightweight, high-performance, language-independent job queue system

•    Go

---

Fireworq is a lightweight, high-performance job queue system with the following abilities. It is available from ANY programming language which can talk HTTP. It works with a single binary without external dependencies. It is built on top of RDBMS (MySQL), so that jobs won't be lost even if the job queue process dies. You can apply an ordinary replication scheme to the underlying DB for the reliability of the DB itself.

job queue job-queue worker-queue background-task

Vibur DBCP - A concurrent and dynamic JDBC connection pool.

•    Java

---

Vibur DBCP is a concurrent, fast and fully-featured JDBC connection pool based on Java dynamic proxies. It supports a fairness parameter, statement caching, SQL queries logging, and Hibernate integration, among other features.

connection-pool statement-pool pool database-library database-connection-pool