So what's the answer then? That's the question I wanted answered after reading this article. With no experience with git or package management, would using a local client sqlite database and something similar on the server do?
Homebrew uses OCI as its backend now, and I think every package manager should. It has the right primitives you expect from a registry to scale.