Forums

Unfortunately no one can be told what FluxBB is - you have to see it for yourself.

You are not logged in.

#1 2017-01-06 10:53:54

twoion
New 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

#2 2017-01-07 21:25:26

Franz
Lead developer
From: Germany
Registered: 2008-05-13
Posts: 6,475
Website

Re: Simple SQL-based activity analytics dashboard

Interesting, can you post a screenshot? smile


fluxbb.de | develoPHP

"As code is more often read than written it's really important to write clean code."

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

Board footer

Powered by FluxBB