This is great. I really like the simplicity of it.<p>How does sqlite handle the streaming load/frequent writes per second? What hardware does it run on?<p>I recently did something similar for server monitoring, after spending days/weeks trying out different stacks and services (datadog, netdata, and the like).<p>Like you, I don't have huge scale issues (<100 servers) and I don't need to monitor every single aspect. A few bash scripts, a couple of systemd services, a node/express server at the receiving end, in-memory data storage and sms/email alerts when the most recent metrics look a bit off.<p>Much cheaper, less resource intensive, and easier to maintain by far.
This is very cool. I'd be interested in a docker-compose script that wrapped this all into a single deployment, as it seems you have created a very nice self-hosted with analytics solution.<p>I do wonder if Metabase is too resource intensive for this purpose, and perhaps a more lightweight data analytics resource might not be better suited? I say this because I usually run metabase on its own server. Perhaps not an issue, more a question.