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

PostgreSQL ORM for Golang with focus on PostgreSQL features and performance. It supports Basic types, Multidimensional Arrays, Transactions, Prepared statements, Queries retries on network errors, Automatic connection pooling with circuit breaker support, Bulk/batch inserts and updates, Pagination and URL filters helpers, Migrations, Sharding and lot more.

pg - PostgreSQL ORM for Golang with focus on PostgreSQL features and performance

Objection.js is an ORM for Node.js that aims to stay out of your way and make it as easy as possible to use the full power of SQL and the underlying database engine while keeping magic to a minimum.Objection.js is built on an SQL query builder called knex. All databases supported by knex are supported by objection.js. SQLite3, Postgres and MySQL are thoroughly tested.

Objection.js - An SQL-friendly ORM for Node.js

TimescaleDB is an open-source database designed to make SQL scalable for time-series data. It is engineered up from PostgreSQL, providing automatic partitioning across time and space (partitioning key), as well as full SQL support. TimescaleDB is packaged as a PostgreSQL extension and released under the Apache 2 open-source license. 
 
TimescaleDB automatically scales and spreads data written to a hypertable into many dynamically-created chunks. Hypertables present the abstraction of a single table, yet transparently partitioned by time and space, they enable high insert rates even at billions of rows.

 TimescaleDB is an open-source database designed to make SQL scalable for time-series data. It is engineered up from PostgreSQL, providing automatic partitioning across time and space (partitioning key), as well as full SQL support. TimescaleDB is packaged as a PostgreSQL extension and released under the Apache 2 open-source license. 

Timescaledb - An open-source time-series database optimized for fast ingest and complex queries

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

QuestDB is a high-performance, open-source SQL database for applications in financial services, IoT, machine learning, DevOps and observability. It includes endpoints for PostgreSQL wire protocol, high-throughput schema-agnostic ingestion using InfluxDB Line Protocol, and a REST API for queries, bulk imports, and exports.
 
QuestDB implements ANSI SQL with native extensions for time-oriented language features. These extensions make it simple to correlate data from multiple sources using relational and time series joins. QuestDB achieves high performance from a column-oriented storage model, massively-parallelized vector execution, SIMD instructions, and various low-latency techniques. The entire codebase was built from the ground up in Java and C++, with no dependencies, and is 100% free from garbage collection.

QuestDB is a high-performance, open-source SQL database for applications in financial services, IoT, machine learning, DevOps and observability. It includes endpoints for PostgreSQL wire protocol, high-throughput schema-agnostic ingestion using InfluxDB Line Protocol, and a REST API for queries, bulk imports, and exports.

QuestDB - Fast relational time-series database

The smoothest, best looking, and easiest to use SQL client for MySQL, Postgres, SQLite, SQL Server, Red shift, MariaDB, CockroachDB and more.

Beekeeper Studio - Open Source SQL Editor and Database Manager

Bytebase is a web-based, zero-config, dependency-free database schema change and version control management tool for developers and DBAs. It is for developers to collaborate on database schemas changes. It helps to construct a single pipeline to propagate the schema change across multiple environments. It can also store the schemas in VCS and trigger a new pipeline upon commit push. 
 
Developers first submit their SQL statement for DBA to review. After review is approved, the SQL statement will then be applied to the corresponding database. "Version controlled schema" aka "Database-as-code" is a practice to store the database schema in a version control system (VCS) just like how application code is stored. The database schema consists of a bunch of database migration scripts.

Bytebase is a web-based, zero-config, dependency-free database schema change and version control management tool for developers and DBAs. It is for developers to collaborate on database schemas changes. It helps to construct a single pipeline to propagate the schema change across multiple environments. It can also store the schemas in VCS and trigger a new pipeline upon commit push. 

ByteBase - Web-based, zero-config, dependency-free database schema change and version control tool for teams

DbGate is cross-platform database manager. It's designed to be simple to use and effective, when working with more databases simultaneously. But there are also many advanced features like schema compare, visual query designer, chart visualisation or batch export and import. It supports MySQL, PostgreSQL ,SQL Server, MongoDB, Redis, SQLite, Amazon Redshift, CockroachDB, and MariaDB.
 
Its features include: 
<ul>
<li>Table data editing, with SQL change script preview</li>
<li>Edit table schema, indexes, primary and foreign keys</li>
<li>Compare and synchronize database structure</li>
<li>ER diagram</li>
<li>Light and dark theme</li>
<li>Master/detail views, foreign key lookups</li>
<li>Query designer</li>
<li>Form view for comfortable work with tables with many columns</li>
<li>JSON view on MongoDB collections</li>
<li>Explore tables, views, procedures, functions, MongoDB collections</li>
<li>SQL editor
<ul dir="auto">
<li>execute SQL script</li>
<li>SQL code formatter</li>
<li>SQL code completion</li>
<li>Add SQL LEFT/INNER/RIGHT join utility</li>
</ul>
</li>
<li>Mongo JavaScript editor, execute Mongo script (with NodeJs syntax)</li>
<li>Redis tree view, generate script from keys, run Redis script</li>
<li>Runs as application for Windows, Linux and Mac. Or in Docker container on server and in web Browser on client.</li>
<li>Import, export from/to CSV, Excel, JSON, XML</li>
<li>Free table editor - quick table data editing (cleanup data after import/before export, prototype tables etc.)</li>
<li>Archives - backup your data in JSON files on local filesystem (or on DbGate server, when using web application)</li>
<li>Charts, export chart to HTML page</li>
<li>For detailed info, how to run DbGate in docker container, visit <a href="https://hub.docker.com/r/dbgate/dbgate" rel="nofollow">docker hub</a></li>
<li>Extensible plugin architecture</li>
<li>Perspectives - nested table view over complex relational data</li>
</ul>

DbGate is cross-platform database manager. It's designed to be simple to use and effective, when working with more databases simultaneously. But there are also many advanced features like schema compare, visual query designer, chart visualisation or batch export and import. It supports MySQL, PostgreSQL ,SQL Server, MongoDB, Redis, SQLite, Amazon Redshift, CockroachDB, and  MariaDB.

DbGate- Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others

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. 
 
SQLx supports compile-time checked queries. It does not, however, do this by providing a Rust API or DSL (domain-specific language) for building queries. Instead, it provides macros that take regular SQL as an input and ensure that it is valid for your database. The way this works is that SQLx connects to your development DB at compile time to have the database itself verify (and return some info on) your SQL queries.

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. 

SQLx - The Rust SQL Toolkit

usql is a universal command-line interface for PostgreSQL, MySQL, Oracle, SQLite3, Microsoft SQL Server, and other databases.The below is a demonstration using usql with xo's booktest simple test database, showcasing the release version v0.5.0. In the demonstration, usql connects to a PostgreSQL database, executes some queries, with variable interpolation, connects to a SQLite3 database file, and does some more queries, before then connecting to a Microsoft SQL database and ending the session.

usql - universal command-line interface for SQL databases

Npgsql is a .NET data provider for PostgreSQL. It allows you to connect and interact with PostgreSQL server using .NET.For any additional information, please visit the Npgsql website at http://www.npgsql.org.

Npgsql -.NET data provider for PostgreSQL.

Apache ShardingSphere is an open-source ecosystem consisted of a set of distributed database solutions, including 3 independent products, JDBC, Proxy & Sidecar (Planning). They all provide functions of data scale-out, distributed transaction and distributed governance, applicable in a variety of situations such as Java isomorphism, heterogeneous language and cloud-native.
 
Features: 
<ul>
<li>Database sharding &amp; Table sharding</li>
<li>Replica query</li>
<li>Sharding strategy customization</li>
<li>Centre-less Distributed primary key</li>
<li>Distributed Governance</li>
<li>Data migration &amp; Scale-out</li>
<li>Observability(Tracing/Metrics) Supported</li>
<li>Data Encryption&amp;Decryption</li>
<li>Shadow Table for Performance Testing</li>
<li>Unified Transaction API</li>
</ul>

Apache ShardingSphere is an open-source ecosystem consisted of a set of distributed database solutions, including 3 independent products, JDBC, Proxy & Sidecar (Planning). They all provide functions of data scale-out, distributed transaction and distributed governance, applicable in a variety of situations such as Java isomorphism, heterogeneous language and cloud-native.

Apache ShardingSphere - Distributed Database Ecosphere 

The Database Lab Engine is an open-source experimentation platform for PostgreSQL databases. Instantly create full-size clones of your production database and use them to test your database migrations, optimize SQL, or deploy full-size staging apps.
 
Thin cloning is possible due to <a href="https://en.wikipedia.org/wiki/Copy-on-write" target="_blank" rel="noopener noreferrer">copy-on-write</a>&nbsp;capabilities provided by either&nbsp;<a href="https://en.wikipedia.org/wiki/ZFS" target="_blank" rel="noopener noreferrer">ZFS filesystem</a>&nbsp;or&nbsp;<a href="https://en.wikipedia.org/wiki/Logical_Volume_Manager_(Linux)" target="_blank" rel="noopener noreferrer">LVM2</a>. As an example, cloning of 10 TiB PostgreSQL database takes less than 2 seconds when a single user is using the Database Lab Engine instance, and up to 30 seconds when 15 users are working with it at the same time.

The Database Lab Engine is an open-source experimentation platform for PostgreSQL databases. Instantly create full-size clones of your production database and use them to test your database migrations, optimize SQL, or deploy full-size staging apps.

Database Lab Engine - Thin database clones for faster development

pg_timetable is an advanced job scheduler for PostgreSQL, offering many advantages over traditional schedulers such as cron and others. It is completely database driven and provides a couple of advanced concepts.
 
<ul>
<li>Tasks can be arranged in chains</li>
<li>A chain can consist of built-int commands, SQL and executables</li>
<li>Parameters can be passed to chains</li>
<li>Missed tasks (possibly due to downtime) can be retried automatically</li>
<li>Support for configurable repetitions</li>
<li>Built-in tasks such as sending emails, etc.</li>
<li>Fully database driven configuration</li>
<li>Full support for database driven logging</li>
<li>Cron-style scheduling at the PostgreSQL server time zone</li>
<li>Optional concurrency protection</li>
<li>Task and chain can have execution timeout settings</li>
</ul>

pg_timetable is an advanced job scheduler for PostgreSQL, offering many advantages over traditional schedulers such as cron and others. It is completely database driven and provides a couple of advanced concepts.

pg_timetable - Advanced scheduling for PostgreSQL

Discover open source projects across all platforms

Projects

PostgreSQL - Powerful, Open Source Object-Relational Database System