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"

[riderx]

Hello do you still have the issue?