Maavey / lancache-stats

LanCache Dashboard
GNU General Public License v3.0
6 stars 3 forks source link

Automatic refresh #4

Open Vanimo opened 4 months ago

Vanimo commented 4 months ago

Feature request for automatic refresh of the dashboard. I had some progress moving the JS code around and introducing some AJAX, but got stuck at updating the page. Can't get the elements to refresh and also getting exceptions on the charts not being cleared first. I think I formatted the data wrong still.

Also considering just going to asp.net for this, but not sure if this is considered small scale and easy to setup/adjust enough for this project/repo?

Maavey commented 4 months ago

we can look into it and check why charts are not resetting and try to find a solution. But I can't help much in asp.net

Vanimo commented 4 months ago

If you're interested to have a look, I pushed my changes to the sql branch. It's been over 10 years and I've never been good at AJAX/JS/PHP, so take it as you want. I may have some time this weekend to continue on this project.

Maavey commented 4 months ago

Thank you Vanimo for your contributions, I really appreciate it. I'll check your branch during the day. What is your use case for lancache? I'm a small ISP in my area and lancache is really a blessing in caching windows updates, epic (fortnite) and steam (cs2)

Vanimo commented 4 months ago

I'm a volunteer at some small LAN-parties I attend with 10-50 people, often using domestic networks for upstream connections. Hopefully LanCache improves the user experience by getting fast downloads and reduced load on the public connection. I'm interested to know how well the cache is being used and detect if someone is not clogging the connection. I'm still getting used to Linux and Docker, so setting up the ELK stack just didn't work out for me yet. I’m mostly a dotnet developer but wanted to try out a ready-made solution before creating my own from scratch. These LAN-parties are also the reason I would like to add a time filter, so we can display the stats for the few days of the event. Having a graph to represent how much was downloaded when would also be fun.

Vanimo commented 3 months ago

Actually got quite some success with Grafana, took some effort to get the queries right, but I can see the same info and apply time filters, while Grafana will update the view at some specified interval. I may stick with this option myself. I could share the queries though, if that helps?

Maavey commented 3 months ago

I'll try to involve a friend experienced in AJAX. Feel free to share the queries, we'll use them if needed.

Vanimo commented 3 months ago

See #5, I did make changes to the database, so be careful how you apply this to your existing setup.