autobase.tech - Automated database platform for PostgreSQL®

[nelsonic]

Following the Fly.io Postgres fiasco dwyl/auth#325 (comment) we are back to the drawing board when it comes to Postgres. 🔍 💭

We took a look at Managed Postgres on DigitalOcean dwyl/learn-devops#90
and for a simple app that doesn't have many records/updates it would be fine but the moment you need
to scale to a decent size and speed, the costs get out-of-hand compared to self-managing ... dwyl/learn-devops#90 (comment)

Sooooo ... this is what I'm considering: run https://postgresql-cluster.org on Hetzner dwyl/learn-devops#97

Using 3 VMs in 3 data centres; eu-central (fsn1), us-west (hil) and ap-southeast (sin): dwyl/learn-devops#97 (comment)

[asntc]

We had a brief hiccup where we couldn't make progress ... 🧱
Opened an issue: vitabaks/autobase#811 and got a reply super quick! 🏎️
This gives us confidence that the project is maintained and we are making a good choice to use it. 🤞

[nelsonic]

Rebranded to "autobase" ... https://github.com/vitabaks/autobase 💭

[asntc]

https://postgresql-cluster.org/ (before the rebrand)

full:

annoyingly it has scroll-based rendering so some of it is missing. 🤦

anyway, this is what it looked like when we first considered using it.

[nelsonic]

Managed to deploy the cluster this morning and do a full doc & screen recording! 📝 📺

#insomnia FTW! 😪 🎉

Just have to edit down ~T2h of screen recording down to T7m and we can ship both!!
GOTO: dwyl/video#95

[nelsonic]

Currently trying to connect to the Postgres cluster on Hetzner but hitting a brick wall 🧱 🤦‍♂️
Opened issue requesting help: vitabaks/autobase#824

[nelsonic]

@MikeRund never be afraid of asking a NOOB Question. Having a Beginner's Mind is a Super Power! 🔰

[MikeRund]

This is a great use-case of not not being afraid to ask the questions, thanks @nelsonic and congrats on deployment! 🚀

[nelsonic]

As noted in vitabaks/autobase#824 (comment) this is all working now.
Most importantly, I understand how the deployment works end-to-end. 👌
So ... I'm going to DELETE it all again and re-deploy from a clean slate. 0️⃣