4 ms·
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 w
by ilovefood 6y ago
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-and-metabase/ https://funnybretzel.com/self-hosted-analytics-using-sqlite-...
- wolfhumble 6y agoLooks like a nice combo that can be used for other projects as well; thanks for the writeup! :-)
- dimovich 6y agoThank you for the writeup. Always nice to see new applications of Metabase. Will try it out.
- zubspace 6y agoThanks 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.
- leephillips 6y agoI 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.