There are some limitations to be aware of when using the WebSQL
implementation of PhoneGap (refer to the SQLite documentation for a complete overview: http://www.sqlite.org/limits.html). These limitations are not related to the framework itself but are due to the web view implementation of each target platform.
The limit you can easily hit when working on an app is the size limit of the database file. For example, on WebKit it varies depending on the operating system from 5 MB to 25 MB. Another limitation you can find is that, since iOS 5.1, both localStorage
and Web SQL
databases have been moved to the folder ~/Library/Caches
from ~/Library/WebKit
. Actually this change means that the information stored is not backed up anymore and that it can be arbitrarily deleted by the operating system when more space is needed (for more information about iOS data management, refer to the Apple Developer guide at https://developer.apple.com/technologies/ios/data-management.html).
In...