pgbouncer-fast-switchover
Adds query routing and rewriting extensions to pgbouncer (by awslabs)
spqr
Stateless Postgres Query Router. (by pg-sharding)
| pgbouncer-fast-switchover | spqr | |
|---|---|---|
| 2 | 5 | |
| 386 | 692 | |
| 0.8% | 18.9% | |
| 8.2 | 9.7 | |
| about 2 months ago | 8 days ago | |
| C | Go | |
| Apache License 2.0 | GNU General Public License v3.0 or later |
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.
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
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...
What are some alternatives?
When comparing pgbouncer-fast-switchover and spqr you can also consider the following projects:
pgagroal - High-performance connection pool for PostgreSQL
catfs - Cache AnyThing filesystem written in Rust
odyssey - Scalable PostgreSQL connection pooler
symbolicator - Native Symbolication as a Service
sgr - sgr (command line client for Splitgraph) and the splitgraph Python library
goofys - a high-performance, POSIX-ish Amazon S3 file system written in Go