I would like to request that this be put in the ideas category.
Like a number of other people who have started using attachments, I am concerned about the disk space usage of attachments causing the Manager database to balloon.
Yes, the sqlite database in theory could support a massive database size but I believe that the current attachments database storage design is fundamentally flawed for the following reasons:
If you are using desktop manager, and you wish to email your account the database to do end of year returns, this will become a problem if you are emailing all the attachments as well. Sending a 50mb email is not practical. This point alone renders the Attachments functionality useless.
If you are using the cloud storage version of Manager, this will cause quite significant space usage costs for the service provider compared to the size of the Manager database without attachments if there is no ability to delete obsolete or inactive attachments.
With the advent of GDPR, it has encouraged people to think about how long we want to keep information for. I can foresee that it might be desirable to delete attachments older than say 10 years on the basis that it is extremely unlikely that you will ever want to view an attachment older than that. The invoice etc will still remain obviously. This would help to optimise the database in terms of size, usefulness of information etc. I think that there needs to be some kind of database management tool kind of like you see in WSUS where you can remove obsolete attachments (older than x years) or remove pictures from inactive inventory or any inactive entry.
Would it be possible to redesign the attachments storage with the following in mind. Enable a backup without attachments thus allowing users to send accounting files to accountants. In addition, to include database storage management functionality to delete obsolete and inactive attachments as described above.