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.
My questions are:
Do the browsers implement this automatically and will it be called eventually ? (can’t find any documentation about this)
Thanks for any help.
Due to the abondoned/work stopped nature of WebSQL, bugs/feature requests were not – and will not – ever be honored. This same problem exists as a Chromium bug, for instance, with no response.
It appears that the worst is true of your two questions:
2: Don’t count on it. It is not clear that it will even run when it hits the max size limit, and even if it does you’ll notice major slowdowns long before you hit the max size limit.
Future/modern applications use IndexedDB now; this question has been answered for legacy applications only.