Suggestion: Use of vacuum to truncate the database

[alfonsosiloniz]

Hi

I'm using SqliteCache for a project where the software downloads PDF files and convert them to images. The images are cached using SqliteCache.

Thus the database grows a lot with the usage. Although I can clear the cache, how sqlite works make that, not using VACUUM, the size of the database is not reduced once the cache is cleared.

https://www.sqlite.org/lang_vacuum.html

One option is to run the sqlite database with the auto_vacuum=true or, the add the possibility to execute the VACUUM sql sentence after the clear of the cache, at least as an option.

Thanks