search

LMS-Community / lms-stats-service

A service to collect analytics data for the Lyrion Music Server Community
https://lyrion.org
1 stars 0 forks source link

Implement retention period #2

Open terual opened 5 months ago

terual commented 5 months ago

I think it would be good to delete the raw data after a certain retention period (Home Assistant uses 60 days). If a system does not send an update within 60 days we can conclude the install is not active anymore, so it can be deleted to not skew the totals.

michaelherger commented 5 months ago

Yep, we should do that. I'll add a line to the update tasks. Should be a simple DELETE request.

michaelherger commented 5 months ago 
DELETE FROM <table> WHERE UNIXEPOCH(DATETIME()) - UNIXEPOCH(lastseen) > 86400*60