Been experimenting with Phonegap, but I’ve run into some major struggles with WebSQL and specifically the craziness of clear tutorials/documentation on it. I spent over an hour not knowing why AUTO_INCREMENT wasn’t working before learning that the WebSQL version of that function is AUTOINCREMENT (one word). FYI, there’s several versions of SQL, so search for your specific use case if stuck on syntax errors. Props to twoHard blog for solving that one.
I also want to point out 2 books that have helped tremendously as I learn Javascript and PhoneGap:
- Javascript Patterns by Stoyan Stefanov
- Beginning Phonegap by Thomas Myer