MagicStack / MagicStack/asyncpg
Support for Postgres-like Clusters
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 8.1k
- Forks
- 468
- PR merge metrics
- No merged PRs in 30d
Description
I'm using [CrateDB](https://github.com/crate/crate) which provides a Postgres interface and allows you to run a cluster of nodes that can all be used for queries. It would be great to have a way to distribute queries across nodes and be able to safely recover if one nodes goes down but the rest are available.
It would be great to be able to just define multiple Postgres endpoints and have asyncpg round-robin non-transaction queries to them.
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
No files, tests, or entry points are named in the issue. Start by reviewing asyncpg's existing connection and pooling behavior, then determine how multiple PostgreSQL endpoints, round-robin routing for non-transaction queries, and recovery from a failed node should fit together; done means the behavior is specified and covered for healthy and unavailable nodes.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, python
- Domain
- backend, databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 30/100