Handling cleanup of assets when deleting STAC Items

[drnextgis]

The delete_item function in pgstac allows for deleting STAC items. However, in most cases, it's not enough to simply remove the records from the database; the underlying assets referenced by the deleted items also need to be cleaned up.

It might be beneficial to introduce an internal table to track deleted items. This would make it easier to integrate with an external cron job that can handle the deletion of assets and the cleanup of the tracking table.

Has anyone encountered and resolved this issue before?

[bitner]

I think this is squarely outside the purview of pgstac. I think that you could create a script outside of pgstac that looked up an item, scanned for those assets, delete those assets first, then delete the item.