Cordova app using WebSQL hit quota limit and cannot recover
<p>I have hit a quota roadblock on iOS using standard Cordova WebSQL (with MS OpenTech polyfill plugin but I don't think it actually uses that on iOS). </p>

<p>An error is thrown from WebSQL indicating quota exceeded. When this happens I catch the error and drop my main table, then refresh it from the internet.</p>

<p>However, when it hits the quota limit it either will not allow a <code>drop table</code> statement to proceed or the drop statement doesn't free any space because the quota error still keeps coming up. Does anyone know why dropping the table wouldn't free space? I have also tried the <code>vacuum</code> statement which thinks for a while but does not appear to free any space either.</p>

<p>Note that this is an existing app in the field so I would prefer not to switch out the database platform unless we need to. (I see there is a plugin available now (<a href="https://github.com/litehelpers/cordova-sqlite-ext" rel="nofollow">https://github.com/litehelpers/cordova-sqlite-ext</a>) which says it has no quota limit - could be the best/only solution?)</p>