Apparently Tailscale for a long time just used a JSON file as their data storage, and moved from that to SQLite with a hot-swappable backup with Litestream [0], and hey they've done fine with that.
[0]: https://securitycryptographywhatever.buzzsprout.com/1822302/...