Add granular analytics for server utilization (player joins, ping, maps, rcon usage) #219
Description
Feature Request
Implement a new analytics system to gain more granular insights into server utilization. The analytics should include:
- Tracking which players join each server
- Recording their PING (latency)
- Logging which maps are played
- Identifying which RCON commands are used the most
Implementation Suggestions:
- We already listen to all events from servers using the
UDPCommandLister. This bot can be extended to generate the analytics. - Consider the data storage approach: storing all this data in the current SQLITE database may be too heavy and inefficient for large-scale analytics.
- Explore options for exporting or sending this data to external analytics platforms (e.g., Databricks, or another cloud-based analytics platform with a free tier) to better handle and visualize high-volume analytics data.
Questions/Notes:
- Should we keep basic stats locally (SQLITE) and ship granular event data to an external analytics service?
- What platform is best for easy integration and low/no cost for small-scale analytics?