Struggles in keeping the database to a reasonable size (AKA deleting submissions, deleting/clearing submissions attachments)

[manghig]

@ktuite

I think it should be possible in your case to reduce your database size by clearing submission attachments but not deleting the entire submission

@ktuite yes! with the command you provided here ODK Central - How to delete a submission - #40 by ktuite I can now use a relatively simple workflow that allows to clear attachments, purge them and then recover disk space.

@ktuite

Edited to add: Do your submissions have multiple versions / have they been edited? We just realized that if that is the case, clearing the submission attachments will only work on the latest version of the submission, in which case the underlying blob wont be truly unlinked in the database and wont be cleaned up by the purge script. I've put this in an issue. Maybe we need a more powerful attachment delete.

Thanks for the heads-up. Fortunately in my case edited submissions are only a few. But good to know you have identified this issue.

Thanks!