Ask HN: Tips on hosting your own Postgres instance

• charts

  88 8,391 10.0 Smarty

  Bitnami Helm Charts (by bitnami)

  

• k3s

  291 26,405 9.6 Go

  Lightweight Kubernetes

  

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• litestream

  165 9,964 7.5 Go

  Streaming replication for SQLite.

You might want to have a look at Litestream then: https://litestream.io/

“Continuously stream SQLite changes to AWS S3, Azure Blob Storage, Google Cloud Storage, SFTP, or NFS. Quickly recover to the point of failure if your server goes down.”

It can also stream to a self-hosted Minio instance: https://litestream.io/getting-started/#setting-up-minio

• embedded-postgres

  4 744 5.2 Go

  Run a real Postgres database locally on Linux, OSX or Windows as part of another Go application or test

depending on the language you have chosen for your side project you might also be able to run postgresql in embedded mode here is the one for golang https://github.com/fergusstrange/embedded-postgres . There is similar solution for java as well.

• postgresql_cluster

  9 1,268 9.0 Jinja

  PostgreSQL High-Availability Cluster (based on "Patroni" and DCS "etcd" or "consul"). Automating with Ansible.

If not Kubernetes, check out this: https://github.com/vitabaks/postgresql_cluster – Postgres + patroni + pgBouncer + WAL-G or pgBackRest + Netdata + more, managed by Ansible.

If you do want to use Kubernetes, then check out StackGres.io and https://github.com/zalando/postgres-operator

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

Suggest a related project