PgDog is a Rust-based PostgreSQL proxy that handles connection pooling, load balancing, and database sharding on commodity hardware - managing thousands of connections where pgbouncer falls short.

If you’ve ever hit connection limits with PostgreSQL in production, you know the pain. PgDog tackles the triple challenge of connection pooling, load balancing, and database sharding in one well-engineered package. Written in Rust, it’s designed to handle thousands of concurrent connections without breaking a sweat - something that becomes critical as your application scales beyond what traditional poolers like pgbouncer can manage.

What sets PgDog apart is its comprehensive approach. Instead of cobbling together separate tools for pooling, load balancing, and sharding, you get all three with consistent configuration and monitoring. The setup is refreshingly straightforward - just two TOML files for hosts/sharding config and user management. It includes ready-made deployment options for Kubernetes (Helm chart), AWS ECS (Terraform module), and Docker Compose for local testing. The Docker demo even comes pre-configured with 3 shards and sample tables so you can see sharding in action immediately.

This is particularly valuable for teams running high-traffic PostgreSQL workloads who need more than basic connection pooling. With 4000+ stars and active development, PgDog represents a mature alternative to building your own scaling infrastructure or managing multiple disparate tools. The Rust foundation means predictable performance characteristics and memory safety - crucial when you’re the critical path between applications and databases.

⭐ Stars: 4060
💻 Language: Rust
🔗 Repository: pgdogdev/pgdog