Show HN: Minimalytics – a standalone minimal analytics app built on SQLite • Hacker News Board

Show HN: Minimalytics – a standalone minimal analytics app built on SQLite

#1

Post by nafey » Thu, Mar 20, 2025, 7:33 PM UTC

Hi everyone! I wanted to share my analytics app with you.

This project came from requirements to track certain very frequent events. I found that the cost to do it on a regular analytics product was much more than i was willing to pay. Secondly, I also wanted to use as few resources as possible. So I thought it may be a good idea to create something that may be useful for myself (and hopefully others).

I have been able to track a great number of events with this using ~20 MB of storage and memory which is incredible. I have been really impressed by golang as a language and as an ecosystem and would love to work more in this language going forward.

Some Highlights: 1. No dependencies 2. CLI based management 3. Web based UI (and the server to serve it) included in the program. 4. 20 MB install size. 5. 20 MB memory use while running. 6. Minimal storage requirements because it aggregates events.

This can be a great fit for anyone who wants to have a lightweight minimal analytics for internal events.

I am looking forward to your comments and feedback.

Show HN: Minimalytics – a standalone minimal analytics app built on SQLite
github.com

Re: Show HN: Minimalytics – a standalone minimal analytics app built on SQLite

#2

Post by admiralrohan » Thu, Mar 20, 2025, 9:55 PM UTC

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

Re: Show HN: Minimalytics – a standalone minimal analytics app built on SQLite

#3

Post by nafey » Thu, Mar 20, 2025, 10:40 PM UTC

admiralrohan wrote: post #2

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

Thank you that's a good suggestion. I'll do that.

Re: Show HN: Minimalytics – a standalone minimal analytics app built on SQLite

#4

Post by bob1029 » Fri, Mar 21, 2025, 1:03 AM UTC

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).

Re: Show HN: Minimalytics – a standalone minimal analytics app built on SQLite

#5

Post by nafey » Fri, Mar 21, 2025, 1:09 AM UTC

bob1029 wrote: post #4

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).

Thank you! I already had experience working in React so I decided to use it for the first release.

I am thinking about switching to HTMX to further reduce size, simplify and improve performance.

Re: Show HN: Minimalytics – a standalone minimal analytics app built on SQLite

#6

Post by rudasn » Fri, Mar 21, 2025, 5:11 AM UTC

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:)

Re: Show HN: Minimalytics – a standalone minimal analytics app built on SQLite

#7

Post by nafey » Fri, Mar 21, 2025, 5:30 AM UTC

rudasn wrote: post #6

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, a…

This is an interesting use case. I can definitely see how a colored cell in a grid can serve as a visual indicator to monitor health of infrastructure. Thanks for sharing this.

Re: Show HN: Minimalytics – a standalone minimal analytics app built on SQLite

#8

Post by HermanMartinus » Fri, Mar 21, 2025, 5:51 AM UTC

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

Re: Show HN: Minimalytics – a standalone minimal analytics app built on SQLite

#9

Post by nafey » Fri, Mar 21, 2025, 6:36 AM UTC

HermanMartinus wrote: post #8

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

Wow. It looks like the two of us were responding to the same underlying needs. Great to see your project.

Re: Show HN: Minimalytics – a standalone minimal analytics app built on SQLite

#10

Post by 8055lee » Fri, Mar 21, 2025, 6:40 AM UTC

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!