postgres-operator
dbhub.io
Our great sponsors
postgres-operator | dbhub.io | |
---|---|---|
36 | 8 | |
3,947 | 355 | |
2.3% | 1.4% | |
8.6 | 9.5 | |
23 days ago | 12 days ago | |
Go | Go | |
MIT License | GNU Affero General Public License v3.0 |
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.
postgres-operator
-
Run PostgreSQL. The Kubernetes Way
yes, precisely. It's UI part that's broken, which cannot list snapshots. Issue is here, no fix since 2020, sadly: https://github.com/zalando/postgres-operator/issues/937
-
Modern SQL Databases Are Changing Web Development: Part 1
I personally like the Zalando operator better, you can add databases and users by updating the CRD, feature parity between the two on HA is pretty good
- Deploying Postgres on Kubernetes in production
-
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)
-
How to Deploy a PostgreSQL cluster on Kubernetes
git clone https://github.com/zalando/postgres-operator.git cd postgres-operator
-
[Kubernetes] Comment déployez-vous un cluster Postgres sur Kubernetes en 2022?
Zalando / Postgres-Operator
-
What are you using to run Postgres?
Somewhere between here and here i found out about that.
-
How to deploy a high availability (HA) Postgres cluster in Kubernetes?
Here's an example of using the PostgreSQL Operator to deploy a high availability PostgreSQL cluster in Kubernetes. In this example, I'll be using the PostgreSQL Operator from Zalando [https://github.com/zalando/postgres-operator] to deploy a PostgreSQL cluster with two nodes.
-
Implementing postgres on a kubernetes cluster for production. Any guides, articles, checklist, etc?
Here's the operator for a postgres cluster: https://github.com/zalando/postgres-operator
-
Databases on Kubernetes is fundamentally same as a database on a VM
And that repo you linked to has 1846 issues, 161 open. Which doesn't seem extraordinary based on my limited exposure to k8s.
Another example: https://github.com/zalando/postgres-operator/issues with 445 open issues. Why?
Maybe I'm wrong and this is all a good sign of progress, but my impression is that the entire k8s ecosystem is held together with reused duct tape.
dbhub.io
-
A SQLite extension that brings column-oriented tables to SQLite
We have a spread of different GitHub Actions based workflows that do stuff whenever a PR is proposed or merged:
https://github.com/sqlitebrowser/sqlitebrowser/tree/master/....
Most of those are oriented around building packages for various OS's (Linux, macOS, Windows) so people can try the latest code.
While there are some tests, they're more like extremely basic sanity tests and don't rely on Docker.
Those tests rely on whichever version of SQLite was downloaded and compiled into the GUI (as per above code snippet).
---
That being said, that's for the client side GUI application. There's a server side of things too (https://github.com/sqlitebrowser/dbhub.io -> dbhub.io) that does use docker for it's automated tests:
https://github.com/sqlitebrowser/dbhub.io/tree/master/.githu...
Those are integration tests though (eg "make sure we didn't bust communication with our cli", "make sure our go library still works 100% with the server"), and a reasonably decent set of End to End (E2E) tests of the web interface using Cypress.
---
Does that help? :)
-
Systemd auto-restarts of units can hide problems from you
> I now have some Go websites running for a long time with daily Systemd restarts.
Are the restarts needed because there's malicious over-size content being sent to it, trying to exhaust the server resources?
If so, then "http.MaxBytesReader" might be helpful:
https://github.com/sqlitebrowser/dbhub.io/blob/5c9e1ab1cfe0f...
-
How to Check 2 SQL Tables Are the Same
Not sure if Go code is your kind of thing, but if it is my colleague wrote a SQLite "diff" capability for our online hosting operation:
https://github.com/sqlitebrowser/dbhub.io/blob/5c9e1ab1cfe0f...
The code there can also output a "merge" object out of the differences too, in order to merge the differences from one database object into another.
-
What would be the easiest way to make a database available online?
https://dbhub.io/ ?
- DBHub: SQLite Storage “In the Cloud”
-
User friendly GUI for OSX
It's open source, free, cross platform and frequently updated. You can also use https://dbhub.io as a way to backup and share your databases.
-
Made a Python library for accessing and using SQLite databases on DBHub.io
I just finished my project 'pydbhub ' for accessing and using SQLite databases on DBHub.io.
- DBHub – SQLite Storage “In the Cloud”
What are some alternatives?
kubegres - Kubegres is a Kubernetes operator allowing to deploy one or many clusters of PostgreSql instances and manage databases replication, failover and backup.
sqlitebrowser - Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite". Website at:
postgres-operator - Production PostgreSQL for Kubernetes, from high availability Postgres clusters to full-scale database-as-a-service.
nocodb - 🔥 🔥 🔥 Open Source Airtable Alternative
cloudnative-pg - CloudNativePG is a comprehensive platform designed to seamlessly manage PostgreSQL databases within Kubernetes environments, covering the entire operational lifecycle from initial deployment to ongoing maintenance
pydbhub - A Python library for accessing and using SQLite databases on DBHub.io
helm-charts - A curated set of Helm charts brought to you by codecentric
datasette - An open source multi-tool for exploring and publishing data
bank-vaults - A Vault swiss-army knife: A CLI tool to init, unseal and configure Vault (auth methods, secret engines).
Sequel-Ace - MySQL/MariaDB database management for macOS
postgres-operator - Postgres operator creates and manages PostgreSQL clusters running in Kubernetes