On Mon, Feb 13, 2017 at 9:13 PM, Richard Hipp <d...@sqlite.org> wrote: > [...] > This makes me want to ask: Is anybody still using auto_vacuum? And > if they are, should they be?
I am thinking to change the commonly-used Cordova/PhoneGap sqlite plugin [1] to enable auto-vacuum by default for the following reasons: * Potential issues with running a full VACUUM on a mobile app, just described by Jens Alfke; * A number of users are beginning programmers who may not read enough background documentation to understand the importance of periodic vacuuming. The sqlite plugin provides an API very similar to the DRAFT Web SQL API [2]. While this is now deprecated it does provide the flexibility needed by many users. Considering that [2] does not mention any need for the web programmer to do periodic vacuuming, I suspect a good Web SQL implementation should have auto-vacuum enabled by default. Or am I mistaken somehow? I would personally vote for this improvement to be included but perhaps with a compile-time option to leave it out? [1] https://github.com/litehelpers/Cordova-sqlite-storage [2] https://www.w3.org/TR/webdatabase/ _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
