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

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

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

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

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. Multi-tenant database: Most B2B applications already have the notion of a tenant / customer / account built into their data model. Citus allows you to scale out your transactional relational database to 100K+ tenants with minimal changes to your application.

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

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

Libzdb - Connection Pool Library in C

•    C

---

Libzdb is a small, fast and easy to use Database Connection Pool Library. It is thread safe and connects to database like MySQL, PostgreSQL, SQLLite and Oracle.

connection-pool statement-pool pool connection-pool-c

Proxool - Java connection pool

•    Java

---

Proxool is a Java connection pool. It transparently adds connection pooling to your existing JDBC driver. The performance of database connections could be monitored. It's easy to configure using the JDBC API, XML, or Java property files. It complies with the J2SE standards.

connection-pool database-connection-pool library

c3p0 - JDBC3 Connection and Statement Pooling

•    Java

---

c3p0 is an easy-to-use library for making traditional JDBC drivers "enterprise-ready" by augmenting them with functionality defined by the jdbc3 spec and the optional extensions to jdbc2. It provides (DriverManager-based) JDBC drivers with JNDI-bindable DataSources, including DataSources that implement Connection and Statement Pooling, as described by the jdbc3 spec and jdbc2 std extension.

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

DBPool - Java Database Connection Pooling

•    Java

---

A Java-based database connection pooling utility, supporting Time-based expiry, Statement caching, Connection validation, and easy configuration using a pool manager.

connection-pool database-connection-pool library