Expired data purge implementation

[Chethan-rao]

Objective

Develop and implement a vacuuming script to automatically delete expired card data from the database, enhancing our data security measures.

Requirements

Create a script that runs as a cron job at regular intervals (specify interval: e.g., every 24 hours). The script should:

• Identify expired cards in the database. (use the ttl field)
• Delete expired entries directly from the database
• Initiate a database vacuuming job after deletion to reclaim disk space.

Technical Considerations

• Ensure the script operates securely without exposing any sensitive data during the process.
• Optimize the script for performance to handle large datasets efficiently, without blocking or hindering the performance of the locker.
• Implement proper error handling and logging mechanisms.