I have developed an app using HTML5 + WebSQL which synchronizes data from the local database to a server.
When data is deleted, the size of the sqlite database file remains the same. I know that this contains empty space and it will be filled when new data is inserted but I would like to keep the size as small as possible because of the limitations.
I know that the VACUUM command in sqlite can compress the database and remove unused space, but when I try to run it on the WebSQL database from JavaScript it fails with the error "logic error or missing database". Running the command from outside the browser works fine.
My questions are:
Can the VACUUM command be executed somehow from JavaScript ?
Do the browsers implement this automatically and will it be called eventually ? (can't find any documentation about this)
Thanks for any help.