You are not logged in.
- Topics: Active | Unanswered
#1 2017-01-06 10:53:54
- twoion
- Member
- Registered: 2017-01-05
- Posts: 2
Simple SQL-based activity analytics dashboard
For my own use I've written a small dashboard application showing certain metrics on FluxBB posting activity, registrations, counts, etc. The data comes from (currently only) a MySQL database; the backend is written in Python, the front end is a bit of JS with chart.js for the charts and bootstrap for style. It's a bit rough as I'm not a front-end person but it does its job. If access control is required, that must be done through a HTTP proxy and HTTP auth and CORS (for the fetch API to work, funny how complicated this JS stuff is in practice).
Thought I'd share it here:
https://github.com/2ion/fluxbb-activity, maybe somebody finds it useful.
In the past, I've done similar things with SQL query results fed into InfluxDB and used Grafana for the dashboard, this time I wanted something more self-contained.
Offline
#3 2017-01-08 16:30:20
- eric235u
- Member
- From: free software land
- Registered: 2008-05-10
- Posts: 132
- Website
Re: Simple SQL-based activity analytics dashboard
Sounds interesting and fun. Yes screenshot please!
Offline