News for hackers. Stuff that matters.
Re:Lightweight Alternatives to Google Analytics by ilovefood on Thursday June 18, 2020 @06:20AM (#23561673)
I've recently whipped up my own self-hosted analytics solution [0] based on SQLite, Bash and Metabase. It's all self hosted, easy to install and very flexible with regards to the queries you can write and display. Metabase comes with a lot of cool features for display, live reload and other cool stuff. :)

[0]: https://funnybretzel.com/self-hosted-analytics-using-sqlite-...

Re:Lightweight Alternatives to Google Analytics by zubspace on Thursday June 18, 2020 @08:14AM (#23562319)
Thanks for the tutorial. Looks interesting.

I'm a fan of GoAccess. Unfortunately the queries are pre-made and there are nearly no options whatsoever. You can't (yet) filter by date for example.

One thing I realized is, that on small sites, like my blog, an overwhelming amount of traffic comes from search engines or bots which are looking for vulnerabilities. Filtering them out takes a lot of time in any self-hosted or self-made solution.

Re:Lightweight Alternatives to Google Analytics by leephillips on Thursday June 18, 2020 @10:39AM (#23563495)
I use GoAccess too. If I want to filter by date (for example) I just run the log file through sed before feeding it to GoAccess.
Re:Lightweight Alternatives to Google Analytics by wolfhumble on Thursday June 18, 2020 @07:03AM (#23561909)
Looks like a nice combo that can be used for other projects as well; thanks for the writeup! :-)
Re:Lightweight Alternatives to Google Analytics by dimovich on Thursday June 18, 2020 @07:12AM (#23561946)
Thank you for the writeup. Always nice to see new applications of Metabase. Will try it out.