用于管理、监控、优化及交互 PostgreSQL 数据库集群与模式的开源实用工具。
Cockroach is a distributed SQL database designed to scale horizontally across multiple nodes while maintaining strict ACID compliance and global data consistency. It functions as a relational database engine that automatically partitions data into ranges, rebalancing them across a cluster to accommodate growing storage and throughput requirements. By utilizing a distributed consensus protocol, the system ensures that all nodes agree on the order of operations, providing fault tolerance and continuous availability even in the event of hardware failures. The system distinguishes itself through
CockroachDB is a distributed SQL database that provides ACID transactions, MVCC, indexing, integrity constraints, replication, and point-in-time recovery, making it a strong relational database comparable to PostgreSQL for this search.
ToyDB is a distributed SQL database that provides a system for storing and querying data across multiple nodes. It focuses on maintaining strong consistency and fault tolerance through the implementation of a distributed consensus algorithm. The project distinguishes itself by supporting historical data versioning, enabling time-travel queries to retrieve the state of the database from a specific point in the past. It utilizes multi-version concurrency control to manage ACID transactions and ensure data integrity during concurrent operations. The system covers relational data modeling with t
ToyDB is an open-source distributed SQL database that provides ACID transactions, MVCC concurrency, time-travel queries for point-in-time recovery, and replication via distributed consensus, fitting the relational database management system category, though it is an experimental project rather than a production-grade equivalent of PostgreSQL.
PostgreSQL is an object-relational database management system designed for the persistent storage and retrieval of structured information. It functions as an ACID-compliant database server, utilizing standard query language protocols to maintain data consistency and reliability across large-scale application datasets. The system distinguishes itself through an extensible architecture that allows for the definition of custom data types, operators, and indexing methods. It employs multi-version concurrency control to enable simultaneous read and write operations without blocking, supported by a
PostgreSQL is the reference open-source relational database, providing ACID transactions, MVCC, SQL, indexing, data integrity constraints, write-ahead logging for point-in-time recovery, replication, and extensible custom types and operators—matching every required feature.
TiDB is a horizontally scalable, distributed SQL database designed to provide consistent transactional storage and high-performance analytical processing within a single unified architecture. It utilizes a decoupled compute-storage design and a distributed key-value storage layer to ensure horizontal scalability and efficient range-based queries. By employing a consensus-based replication algorithm, the system maintains high availability and automatic failover across multiple nodes and geographical regions. The platform distinguishes itself through its hybrid transactional and analytical proc
TiDB is a horizontally scalable distributed SQL database that supports SQL, ACID transactions, MVCC, indexing, and replication—covering the core RDBMS features you need—but it is MySQL-compatible rather than PostgreSQL, which may be a mismatch if you specifically require PostgreSQL compatibility.
TimescaleDB is an open-source PostgreSQL extension that adds native time-series capabilities to the database. At its core, it transforms standard PostgreSQL tables into hypertables—automatically partitioned by time intervals—so data is stored in fixed-size chunks without manual sharding. The extension includes a library of over 200 built-in SQL functions purpose-built for time-series workloads, such as time bucketing, gap filling, percentile estimation, and time-weighted averages. What distinguishes TimescaleDB from generic PostgreSQL is its set of integrated time-series features that work th
TimescaleDB is a PostgreSQL extension that inherits PostgreSQL's full SQL, ACID, MVCC, indexing, constraints, replication, and point-in-time recovery, so it functions as a relational database management system—but its core identity is a time-series specialization, making it a narrower fit than a general-purpose RDBMS.