patroni
nhost
Our great sponsors
patroni | nhost | |
---|---|---|
19 | 88 | |
6,195 | 7,499 | |
1.9% | 1.5% | |
9.2 | 9.8 | |
10 days ago | 7 days ago | |
Python | TypeScript | |
MIT License | MIT License |
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.
patroni
-
Citus is not ACID but Eventually Consistent
Citus doesn't provide fault tolerance. Each shard is a monolithic PostgreSQL. To reduce downtime on failures, you can protect each shard with a standby database. As this is a complex configuration, Patroni can help. For this lab I'll use the Citus+Patroni docker-compose-citus.yml from https://github.com/zalando/patroni.git:
-
How to create postgres cluster in docker swarm?
We have been using stolon + consul for years without issue in our swarm environments. It may also be possible with patroni.
-
Why PostgreSQL High Availability Matters and How to Achieve It
one of the solutions which made it pretty simple for us to run postgresql in a ha environment (mostly in k8s, but works standalone as well) is zalandos patroni: https://github.com/zalando/patroni it's really solid and worked for us for a few years already.
or for k8s their operator: https://github.com/zalando/postgres-operator (docker image: https://github.com/zalando/spilo) we've also tried other operators which were easier to get started, but they failed miserably (crunchyrolls operator is basically based on the zalando one)
-
Docker: Patroni + HAProxy + Etcd + PgBouncer
Hello. I am currently using this docker-compose model from Zalando repository. It does not include PgBouncer in its architecture by default. I've been trying to find a containerized implementation involving Patroni, HAProxy, Etcd and PgBouncer. I didn't find anything solid so far.
-
Can someone share experience configuring Highly Available PgSQL?
General purpose: Patroni - Set up your own etcd + HAProxy + Patroni + Postgres components and it'll generally manage itself after that.
- Patroni Version 3.0.0 Released
- Any self hostable postgres clustering, replication and fail over system?
-
Postgresql HA using repmgr and Keepalived
I don't have a great answer for you except that it sounds like you are trying to create your own version of patroni. Is there a good reason to not just use patroni?
-
Testing Patroni strict synchronous mode 👉🏻 you must handle invisible commit and read split brain
git clone https://github.com/zalando/patroni.git cd patroni docker build -t patroni . docker-compose up -d
-
Any recommandation Postgres Operator ?
I actually used Patroni on Openshift in my company. To be update with the latest version we created our helm chart.
nhost
-
Database Review: Top Five Missing Features from Database APIs
Hasura ❌ (technically yes with Nhost)
-
the code written during those sudden spurts of inspiration are the backbone of most software development
Only caveat I say is make sure there's something in it for you; if it's 2 AM it better be mostly for self-benefit. I'm busy constructing a monorepo with the latest technology with NX and pnpm and a half dozen other technologies (I recommend checking out http://nhost.io/); at the end I will build whatever I want and maybe make money. It's not done for the good of someone else exclusively that's for sure
-
Does an open source 'backend platform' exist for dotnet?
Yeah, I knew of those, I think that's discussed often enough on the dotnet subs. Ory and Zitadel I knew too, but those provide just one thing, and are not native to dotnet. Altough I'll admit, stuff like nhost seem native to typescript but uses go projects under the covers as well.
-
You're starting development today, which libraries are you going with?
I'm really digging nhost and apollo-client.
-
Is there smth like firebase on-prem?
You can use Nhost (100% open source): https://github.com/nhost/nhost/tree/main/examples/docker-compose
- I created Atomic: Self Hosted Open Source Alternative to Reclaim, Clockwise & Motion
-
When are we going to become millionaires?
Backend Frontend Database pick two or even one. Maybe something like this
-
nhost.io error , ge.create is not a function
I am trying to use basic authentication of nhost.io .
-
Help on designing 'backend' stack to go with NextJs project
If your backend needs aren't super crazy, i would check out https://nhost.io/
- Open Source Firebase Alternative with GraphQL
What are some alternatives?
pg_auto_failover - Postgres extension and service for automated failover and high-availability
supabase - The open source Firebase alternative.
stolon - PostgreSQL cloud native High Availability and more.
Appwrite - Build like a team of hundreds_
Grafana - The open and composable observability and data visualization platform. Visualize metrics, logs, and traces from multiple sources like Prometheus, Loki, Elasticsearch, InfluxDB, Postgres and many more.
Hasura - Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.
postgresql_cluster - PostgreSQL High-Availability Cluster (based on "Patroni" and DCS "etcd" or "consul"). Automating with Ansible.
hasura-backend-plus - 🔑Auth and 📦Storage for Hasura. The quickest way to get Auth and Storage working for your next app based on Hasura.
stolon-chart - Kubernetes Helm chart to deploy HA Postgresql cluster based on Stolon
apollo-server - 🌍 Spec-compliant and production ready JavaScript GraphQL server that lets you develop in a schema-first way. Built for Express, Connect, Hapi, Koa, and more.
crunchy-proxy - PostgreSQL Connection Proxy by Crunchy Data (beta)
Prisma - Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB