I have a web app that is using a Web SQL database (via AppML). The webapp runs fine in Chrome on a PC and Android device, and runs fine on Safari on a Mac and iOS device. However when I build the web app via Phonegap into an app, only the Android one works correctly. The iOS version doesn't update records with any consistency. Sometimes it'll update or create a record, and sometimes it won't. I'm not sure what the problem could be, anyone else run into anything like this?
I've not heard of this being a problem with Web SQL, but I've not used AppML. You might want to interact directly with the Web SQL API instead to see if the problem might not be AppML instead.