spqr

Stateless Postgres query router.

Visit website ↗

Console’s review

· Reviewed by David Mytton

What we like

Scale Postgres horizontally by configuring shards. Wire protocol compatible so all existing clients work - they don’t need to be shard aware. Includes connection pooler so you can replace PgBouncer et al. Can run multiple routers for HA. Live config reloading.

Tradeoffs

Doesn’t support cross-shard queries. Docs are limited - no quick start guide, but browsing the example configs gives you an idea of how to get going.

Console is a free weekly newsletter with short reviews of developer tools, covering strengths and tradeoffs. This review reflects our assessment at publication. Read our selection criteria and learn about Console.

Discover your next favorite tool

Independent devtool reviews and the latest betas, in your inbox every Thursday. Free.