23 May 2012 11:53 AM #91
It probably does. I just wish I could figure out what causes the white screen of death when the phonegap js file is included. Doesn't make sense to me.
23 May 2012 11:56 AM #92
23 May 2012 12:09 PM #93
23 May 2012 12:11 PM #94
Ok cool, I'll have a go in a couple of weeks and post how far I get here.
23 May 2012 12:18 PM #95
Yeah I just would be curious to see how it goes for you. I'm not in any rush since it works fine at the moment for my needs. Just want to figure out what I'm doing wrong.
21 Jun 2012 1:44 AM #96
Thanks for this great piece of work.
Have two questions;
When I set the dB size, lets say to 50mb I get prompted to increase db size by Safari (on a mac) but not by Phonegap, isnt it a bit weird? How can I be sure the limit is increased?
This proxy is obviously WebSQL but it's cached by Phonegap into the Library folder so it can be permanently stored in the device. It's said that it can be turned into a true native SQLite DB using the Phonegap plugin, which plugin is that? and is there a sample code for both the proxy and plugin combined to have native SQLite behaviour?
22 Jun 2012 6:59 AM #97
On phonegap, the limit is not increased unless you're more phonegap-proficient than me and have managed to successfully install this plugin:
In which case let me know how it's done because the readme is rubbish!
That same plugin will get you the native behaviour on iOS. Otherwise only deploy this as a webapp or keep the db size under 5mb.
22 Jun 2012 7:09 AM #98
have a look at this https://github.com/chbrody/Cordova-SQLitePlugin
it should theorically work after a couple of fixes on your script.
Had to jump to another stuff but will get back to it soon and hopefully get them both working.
2 Jul 2012 8:17 AM #99
Thanks for the work on this. Just trying to convert my app to use this rather than localstorage. I have noticed that the clear() function of the proxy is not implemented. Is there any particular reason for that?
2 Jul 2012 11:58 PM #100
I can't see a clear method in the docs - please do correct me if I'm wrong or it's listed elsewhere!
To remove all records I just use: