spqr
Stateless Postgres Query Router. (by pg-sharding)
pgbouncer-fast-switchover
Adds query routing and rewriting extensions to pgbouncer (by awslabs)
| spqr | pgbouncer-fast-switchover | |
|---|---|---|
| 5 | 2 | |
| 685 | 386 | |
| 18.1% | 0.8% | |
| 9.7 | 8.2 | |
| 5 days ago | about 1 month ago | |
| Go | C | |
| GNU General Public License v3.0 or later | Apache License 2.0 |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
spqr
Posts with mentions or reviews of spqr.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2024-03-25.
- SPQR 1.3.0: a production-ready system for horizontal scaling of PostgreSQL
-
Scalable PostgreSQL Connection Pooler
Transaction poolers are looking on ReadyForQuery packet and it's "in trnsaction" property like this [0]. All you need - is stick server connection on new ParameterStatus[1] packet for "SET search_path" instead of ReadyForQuery.
[0] https://github.com/pg-sharding/spqr/blob/358f816cd8a964a9c9e...
pgbouncer-fast-switchover
Posts with mentions or reviews of pgbouncer-fast-switchover.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2021-11-12.
- Scalable PostgreSQL Connection Pooler
-
What’s up with these new not-open source licenses?
Case in point -- an enhancement to PostgreSQL's connection pooler that could have been released as OSS with essentially no impact on RDS Postgres and yet: https://github.com/awslabs/pgbouncer-rr-patch/issues/3
What are some alternatives?
When comparing spqr and pgbouncer-fast-switchover you can also consider the following projects:
catfs - Cache AnyThing filesystem written in Rust
pgagroal - High-performance connection pool for PostgreSQL
odyssey - Scalable PostgreSQL connection pooler
symbolicator - Native Symbolication as a Service
goofys - a high-performance, POSIX-ish Amazon S3 file system written in Go
sgr - sgr (command line client for Splitgraph) and the splitgraph Python library