Show HN: Minimalytics – a standalone minimal analytics app built on SQLite (opens in new tab)

Neat project! I’ve seen a few analytics tools starting to use SQLite over Clickhouse. It’s great for small to medium sized projects, and can potentially scale (but I haven’t tested it over 200k hits per month).

I rolled out a similar project a few months ago using Django + SQLite.

https://github.com/HermanMartinus/bearlytics

I had a similar need, and after going through the docs for a few existing solutions (grafana, elastic, prometheus, etc) I decided to roll my own.

No db on the receiver and log-based storage on the senders (using standard log rotation to manage size). A systemd service to write to logs, another to read the last value and push to remote if it has changed. Bash all around.

Other than absolutely 0 maintenance required, and just a $5 droplet, the thing I like the most is the dashboard. It just looks like a spreadsheet. A row for each server, a column for each metric. Click on a cell to view charts for that metric. If metrics are failing health checks cell goes orange, or red if critical. Otherwise it's all gray.

So I can have the dashboard open on a screen and just glance at it and know if something is off. I haven't seen anyone else providing such a dashboard, maybe you can give it a go:)

Congrats on the progress.

A lot of the SQLite code & modeling looks similar to how I'd approach this.

I was wondering about the need for React in this arrangement. I feel like you could do this with even fewer vendors and less memory (on the client).

I read your documentation and this is one of the best projects I came across. No unnecessary complexities, gets the job done with simple REST calls. Hope there is a way to export analytics!

You may give a more semantic name for the screenshot, instead of "First metric", "Second metric".

Isn't SQLite known for being bad for write-heavy use cases?

Created an issue https://github.com/nafey/minimalytics/issues/4

A little sad since I wanted to try it out