pgdog

Built in Rust with Tokio, PgDog is optimized to handle thousands of connections on commodity hardware, leveraging modern async runtime for high-throughput workloads as highlighted in the performance documentation.

Uses PostgreSQL protocol-aware routing to automatically send writes to the primary and reads to replicas, supporting strategies like round robin, random, and least active connections, which maximizes database availability.

Supports partition-based and schema-based sharding with in-memory assembly for cross-shard queries, unique ID generation, and re-sharding capabilities via logical replication, enabling horizontal scaling without major app changes.

Offers RDS IAM authentication, allowing clients to use password-based auth while PgDog uses IAM tokens for backend connections, simplifying security in AWS environments.