Single Go binary + SQLite database all the way.
I've been doing this architecture on single tenant VMs for like 6+ years now and it has so many advantages for deployments, security and scaling.
Pretty much every new tool and agent computer I set up uses this pattern. I've blogged about it and created a template repo.
https://housecat.com/blog/the-hugs-stack-hypermedia-unix-go-... https://github.com/housecat-inc/scratch
Where's the ai-written software and blog notice?
Nice! But you made a mistake of using smallcaps-only on the repository. MacOSX file systems will complain and all sorts of weirdness can happen.
Recently I vibe coded a couple of scripts invoked by cron to do the same thing for a few services running on a single node for me. Works beautifully.
I like it but use Rust instead
Ive used pocketbase (basically the same pattern with some nice dashboard magics) for soo many tasks like this it’s insane.