Awesome GitHub RepositoriesQuery Routing

This project is a comprehensive reference collection of practical implementation examples and patterns for building applications with Spring Boot. It serves as a Java web application template and a showcase for developing functional web services featuring REST endpoints, template engines, and global exception handling. The repository distinguishes itself by providing detailed demonstrations of enterprise-grade features, including distributed locking, task scheduling, and asynchronous message exchange using brokers like RabbitMQ. It also includes reference implementations for automated API doc

graphql-engine is an automated GraphQL API engine that transforms database tables and relationships into a queryable GraphQL schema. It functions as a federation gateway and mapper, instantly generating APIs with built-in filtering, pagination, and mutations from existing databases and remote schemas. The project distinguishes itself through a fine-grained access control layer that enforces row-level and field-level permissions. It further provides a real-time data subscription server that converts standard queries into live streams and a system for triggering event-driven webhooks and notifi

OceanBase is a distributed SQL database designed for high availability and strong consistency across multiple nodes and regions. It functions as a hybrid transactional and analytical processing engine, allowing real-time analytics and transactions to execute on a single data copy. The system also serves as a vector database engine for indexing and querying vector data to power semantic search and recommendation systems. The platform features native compatibility layers for MySQL and Oracle, enabling the migration of legacy workloads without rewriting SQL code. It utilizes a Paxos-based distri

Kingshard is a MySQL database proxy and sharding middleware that routes SQL traffic between clients and multiple database nodes. It functions as a load balancer, read-write splitter, and SQL query firewall to manage how data is accessed and distributed across a database infrastructure. The system implements data sharding using hash, range, or date strategies to split tables across multiple nodes. It enables read-write splitting by directing data modification requests to a master node while distributing read-only queries across a pool of slave replicas. The proxy provides traffic management t

Pinot is a distributed, columnar analytical database designed for high-concurrency, low-latency query processing. It functions as a real-time OLAP datastore, enabling interactive, user-facing analytics by ingesting and querying massive datasets from both streaming and batch sources. The system architecture relies on a centralized controller for cluster coordination and a distributed segment-based storage model to ensure horizontal scalability. The platform distinguishes itself through a hybrid ingestion pipeline that unifies real-time event streams and historical batch data into a single quer

AliSQL is a fork of MySQL by Alibaba that extends the relational database management system with enhancements for high performance, scalability, and enterprise-grade availability. It retains the core MySQL identity as a SQL-based database for storing, organizing, and retrieving structured data, while adding optimizations for large-scale transactional and analytical workloads. The project differentiates itself through a set of Alibaba-specific improvements, including a columnar engine for accelerating analytical queries directly on MySQL tables, and a distributed, shared-nothing NDB Cluster en

Pgcat 是一个 PostgreSQL 中间件解决方案，提供连接池、分片、负载均衡和故障转移管理。它作为一个代理，通过管理数据库会话并将查询分发到多个实例来优化资源使用和可扩展性。 该系统通过流量镜像脱颖而出，它将实时生产查询复制到测试数据库以进行验证。它还实现了分片代理，根据分片键将数据和查询分发到多个数据库实例。 该项目通过自动故障转移和服务器健康监控涵盖了高可用性。它包括用于分离读写操作的流量路由、用于加密通信的传输层安全 (TLS)，以及用于系统管理和性能指标导出的虚拟管理数据库。 该服务打包为 Docker 容器，以确保在不同环境中的一致部署。

pgdog is a PostgreSQL sharding proxy, distributed SQL router, and connection pooler. It is designed to enable horizontal data distribution by splitting tables and indices across multiple independent servers to scale storage and processing capacity. The project distinguishes itself through online resharding capabilities, using logical replication to move data between shards without application downtime. It supports multiple routing strategies, including hash, list, and range-based query routing, and manages distributed atomic transactions using a two-phase commit process to ensure consistency

该项目是一个数据库扩展，支持跨多个 PostgreSQL 节点的水平扩展和分布式数据分区。它作为一个中间件解决方案，将大型数据库表分布在集群中，以增加总存储容量并提高不断增长的数据集的写入性能。 该系统采用基于哈希的分区将表记录分布在物理节点上，并使用中央元数据目录来跟踪分片位置。它提供透明的查询路由，将标准 SQL 命令从协调节点引导至适当的工作节点，而无需修改现有的应用逻辑。 该框架包含通过分片复制和自动一致性修复过程来维护数据冗余和集群完整性的工具。它还支持高吞吐量数据摄入，利用并发处理将海量数据集导入分布式表中。