sastraxi

Cool! More digging to do. I used ALARM to build some rpi images, it worked really well but alas we ended up going back to the base rpi os (Debian) due to the rolling release schedule making reproducible builds more difficult. I’m still thinking through the conceptual correct solution for an appliance…

Thanks for sharing your workflow. My question is about why two databases on the same server would need two separate postgres instances.

Yeah, that's the one. My use case is largely for local development, so the active connections thing isn't a limiter for me.

Yes, that's what I'm referring to.

You're still making the assumption in this comment: why does my 2nd (cloned) database need a separate postgres instance? One postgres server can host multiple databases.

I’ve done experiments using BTRFS and ZFS for local Postgres copy-on-write. You don’t need anything but vanilla pg and a supported file system to do it anymore; just clone the database using a template and a newish version of Postgres.

Looking at Xata’s technical deep dive, the site claims that we need an additional Postgres instance per replica and proposes a network file system to work around that. But I don’t really understand why that’s needed. Can someone explain to me my misunderstanding here?

Yeah, I understand it's hard to find the balance here. I'd imagine you feel the need to ship at the same time as writing about it. For me, the post you shared in your reply as well as in the OP have been expanded to be about 3-4x as long as they need to be, and I'm going to assume you're using AI to generate them due to the writing style. My feedback is to consider writing shorter posts, but doing it by hand -- your prose style here is friendly, engaging and direct. I wish that your articles were the same.

TL;DR: I feel like my time is being wasted when I read AI-written articles, so I stop reading. Do with my anecdote what you will!

The idea is interesting, but have some more respect for your potential readers and actually write the post. There’s so much AI sales drivel here it’s hard to see what’s interesting about your product. I’m more interested in the choices behind your design decisions than being told “trust me, it’ll work”.

I find their SQL database’s latency to be absolutely unusable, though I haven’t tried in a few months. Otherwise I agree, great free tiers for what I’ve used it for.

Looks good! I might have missed it but it would be helpful to have a link to the jujutsu home page in your README.md.

Great writing style and articulation of thought! That was a fun read

DRF-spectacular is an okay choice here, you have to manage consistency with return types yourself but the docs and customization options are well done.