Make a script to backup logs (stats table) and delete from db logs older than X days

[riderx]

The goal is to make the DB stop to be bloated.
Currently, the Device ID list and logs are making the Db slow the idea is to make a script who table a table in parameter and can delete entry older than x days.

The date of creation and updated_at should be checked to be bigger than limit
This would be run every day to keep the DB cost low.

This backup has to be store in R2.

This script has to run in GitHub Action

[ayusham001]

/attempt #367

Options

• Cancel my attempt

[riderx]

i made it myself

[riderx]

/tip 20 @ayusham001 thanks for trying, i made shell script who conect direct to pg behind supabase

[algora-pbc]

🎉🎈 @ayusham001 has been awarded $20! 🎈🎊