PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It has native programming interfaces for most of the programming language. 

 An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance.

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It has native programming interfaces for most of the programming language.

PostgreSQL -  Powerful, Open Source Object-Relational Database System

Advanced multi-threaded PostgreSQL connection pooler and request router. Odyssey can significantly scale processing performance by specifying a number of additional worker threads. Each worker thread is responsible for authentication and proxying client-to-server and server-to-client requests. All worker threads are sharing global server connection pools. Multi-threaded design plays important role in SSL/TLS performance.

Odyssey - Scalable PostgreSQL connection pooler

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.
 
Citus is a PostgreSQL extension and not a fork. It is scalable across multiple machines through sharding and replication. It supports distributed engine for query parallelization.

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.


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

PgBouncer is  a lightweight connection pooler for PostgreSQL. It supports Session pooling, Transaction pooling, Statement pooling. It is not tied to one backend server. The destination databases can reside on different hosts. It has low memory requirements (2 kB per connection by default). This is because PgBouncer does not need to see full packets at once. 

PgBouncer - Lightweight connection pooler for PostgreSQL

pgAdmin is the most popular and feature rich administration and development platform for PostgreSQL. It is designed to answer the needs of all users, from writing simple SQL queries to developing complex databases. The graphical interface supports all PostgreSQL features and makes administration easy. The application also includes a syntax highlighting SQL editor, a server-side code editor, an SQL/batch/shell job scheduling agent, support for the Slony-I replication engine and much more.

pgAdmin - Administration and development platform for PostgreSQL

pg_cron is a simple cron-based job scheduler for PostgreSQL (10 or higher) that runs inside the database as an extension. It uses the same syntax as regular cron, but it allows you to schedule PostgreSQL commands directly from the database. pg_cron can run multiple jobs in parallel, but it runs at most one instance of a job at a time. If a second run is supposed to start before the first one finishes, then the second run is queued and started as soon as the first run completes.

pg_cron - Run periodic jobs in PostgreSQL

IvorySQL is advanced, fully featured, open source Oracle compatible PostgreSQL. IvorySQL adds a &ldquo;compatible_db&rdquo; toggle switch to switch between Oracle and PostgreSQL compatibility modes. One of the highlights of IvorySQL is PL/iSQL procedural language that supports oracle&rsquo;s PL/SQL syntax and Oracle style Packages.
IvorySQL provides the following features based on PostgreSQL:
<ul>
<li>
Oracle compatible Packages
</li>
<li>
Oracle compatible PL/iSQL procedural language
</li>
<li>
GUC to switch between Oracle and PostgreSQL modes
</li>
<li>
Oracle compatible syntax for various DDL operations
</li>
<li>
Oracle compatible date/time functions
</li>
<li>
Built-in <a href="https://github.com/orafce/orafce" target="_blank" rel="noopener">Orafce</a>
</li>
</ul>

IvorySQL is advanced, fully featured, open source Oracle compatible PostgreSQL. One of the highlights of IvorySQL is PL/iSQL procedural language that supports oracle’s PL/SQL syntax and Oracle style Packages.

IvorySQL - Oracle compatible PostgreSQL

PolarDB for PostgreSQL (PolarDB for short) is an open-source database system based on PostgreSQL. It extends PostgreSQL to become a share-nothing distributed database, which supports global data consistency and ACID across database nodes, distributed SQL processing, and data redundancy and high availability through Paxos based replication. PolarDB is designed to add values and new features to PostgreSQL in dimensions of high performance, scalability, high availability, and elasticity. At the same time, PolarDB remains SQL compatibility to standalone PostgreSQL with the best effort.
 
PolarDB will evolve and offer its functions and features in two major parts: an extension and a patch to PostgreSQL. The extension part includes components implemented outside the PostgreSQL kernel, such as distributed transaction management, global or distributed time service, distributed SQL processing, additional metadata, internal functions, and tools to manage database clusters and conduct fault tolerance or recovery. Having most of its functions in a PostgreSQL extension, PolarDB targets easy upgrading, easy migration, and fast adoption. The patch part includes the changes necessary to the kernel, such as distributed MVCC for different isolation levels. We expect functions and codes in the patch part is limited. As a result, PolarDB can be easily upgraded with newer PostgreSQL versions and maintained full compatibility with PostgreSQL.

PolarDB for PostgreSQL (PolarDB for short) is an open-source database system based on PostgreSQL. It extends PostgreSQL to become a share-nothing distributed database, which supports global data consistency and ACID across database nodes, distributed SQL processing, and data redundancy and high availability through Paxos based replication.

PolarDB - Share-nothing, Distributed database based on PostgreSQL

DBMail is a collection of programs that enables email to be stored in and retrieved from a database. It is scalable. You can run the dbmail programs on different servers talking to the same database(cluster). LDAP integration allows you to integrate with existing authentication backends, such as ActiveDirectory.

DBMail - Fast and scalable sql based email services

Discover open source projects across all platforms

Projects

PostgreSQL - Powerful, Open Source Object-Relational Database System