Database limitations

There are some limitations to be aware of when using the WebSQL implementation of PhoneGap (refer to the SQLite documentation for a complete overview at 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 ~/Library/Caches folder from the ~/Library/WebKit folder. Actually, this change means that the information stored is not backed up anymore and 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...