Implement daily data pruning

Automatically prune old log metadata to keep the database lightweight while retaining essential records.