Remove from database clear the data, but doesn't update the disk storage stats

[julienkermarec]

Is your feature request related to a problem? Please describe. When i use this.store.remove({ key }); on my Angular/Capacitor mobile app, the data is removed, but the disk space doesn't change.

Describe the solution you'd like I see on SQLite documentation that auto_vacuum need to be set (0 | NONE | 1 | FULL | 2 | INCREMENTAL) https://sqlite.org/pragma.html#pragma_auto_vacuum

Is it possible to add an option to update the property auto_vacuum ?

Describe alternatives you've considered The only way to reduce the size on disk is to use deleteStore() but the method remove the databse or a specific table.

Additional context Ionic CLI : 7.1.1 NodeJS : v20.2.0 npm : 9.6.6 @capacitor/android": "5.0.5 "capacitor-data-storage-sqlite": "5.0.1"