1 Repo
Routing of database queries to specific shards based on whether a column value falls within a predefined bounding range.
Distinct from Range Query Structures: None of the candidates represent database sharding routing; they cover algorithmic structures or UI ranges.
Explore 1 awesome GitHub repository matching data & databases · Range-Based Query Routing. Refine with filters or upvote what's useful.
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
Provides a routing strategy that directs queries to shards based on column value ranges.