TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

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

74 pointsby nafeyabout 2 months ago
Hi everyone! I wanted to share my analytics app with you.<p>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).<p>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.<p>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.<p>This can be a great fit for anyone who wants to have a lightweight minimal analytics for internal events.<p>I am looking forward to your comments and feedback.

7 comments

HermanMartinusabout 2 months ago
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).<p>I rolled out a similar project a few months ago using Django + SQLite.<p><a href="https:&#x2F;&#x2F;github.com&#x2F;HermanMartinus&#x2F;bearlytics" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;HermanMartinus&#x2F;bearlytics</a>
评论 #43432441 未加载
rudasnabout 2 months ago
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.<p>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.<p>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&#x27;s all gray.<p>So I can have the dashboard open on a screen and just glance at it and know if something is off. I haven&#x27;t seen anyone else providing such a dashboard, maybe you can give it a go:)
评论 #43432094 未加载
bob1029about 2 months ago
Congrats on the progress.<p>A lot of the SQLite code &amp; modeling looks similar to how I&#x27;d approach this.<p>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).
评论 #43430872 未加载
8055leeabout 2 months ago
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!
评论 #43432509 未加载
admiralrohanabout 2 months ago
You may give a more semantic name for the screenshot, instead of &quot;First metric&quot;, &quot;Second metric&quot;.
评论 #43429870 未加载
byyllabout 2 months ago
Isn&#x27;t SQLite known for being bad for write-heavy use cases?
Imustaskforhelpabout 2 months ago
Created an issue <a href="https:&#x2F;&#x2F;github.com&#x2F;nafey&#x2F;minimalytics&#x2F;issues&#x2F;4" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;nafey&#x2F;minimalytics&#x2F;issues&#x2F;4</a><p>A little sad since I wanted to try it out