Delete website Data for a Specified Period

[LahlouMohamed]

Objective
Add the ability to delete data for a specified period for Umami users.

Context
This feature aims to improve performance management by allowing the deletion of data within specific date ranges. This helps to maintain a lighter and more performant database. Additionally, an import/export feature will be ideal for archiving complete periods before deletion.

Implementation Details

1. Database
   Addition of cascading delete functionality to ensure that all data related to a specific period is correctly removed.
   Update of database schemas and necessary migration scripts.
2. API
   Create a new API endpoint that takes two parameters: startDate and endDate.
   Implement the logic for deleting data (event_data) within this date range.
3. Frontend
   Add a user interface to select a date range and initiate the deletion of the corresponding data.
   Display appropriate confirmations and alerts to prevent accidental deletions.
4. Screenshot

[aleksandereiken]

This would be extremely useful to get implemented. I'm a big fan!

[tschannik]

Indeed, i'd love a feature like that. It would also be nice if the implemented feature would do the useful database optimization like updating its indices and would run optimize table, right?