spqr

Stateless Postgres query router.

Visit website ↗

Profile updated

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.

Is spqr a fit?

Based on Console’s review published on 2024-04-04. Summary updated .

Who it’s for

Developers using Postgres can consider this tool for horizontal scaling

Why consider it

It allows for horizontal scaling of Postgres by configuring shards

Keep in mind

It does not support cross-shard queries

Console is a free weekly newsletter with short reviews of developer tools, covering strengths and tradeoffs. This review reflects Console’s assessment at publication on 2024-04-04. Features and limitations may have changed since the review date. 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.