Re: [Android] The state of WebSQL on Android 4.x

2013-10-02 Thread Andrew Grieve
Finally following up on this. Create JIRA: https://issues.apache.org/jira/browse/CB-4986 And checked in a plugin called org.apache.cordova.websql to cordova-labs/plugins. https://git-wip-us.apache.org/repos/asf?p=cordova-labs.git;h=3d26e5d Pushed it to the registry. On Fri, Sep 20, 2013 at

Re: [Android] The state of WebSQL on Android 4.x

2013-09-20 Thread Michal Mocny
Thats a super cool solution! I agree that updating what's inside cordova-labs and leaving it there is a good option for written by us, but not quite core. -Michal On Thu, Sep 19, 2013 at 7:23 PM, Andrew Grieve agri...@chromium.org wrote: Managed to get a simpler version of my email coding to

Re: [Android] The state of WebSQL on Android 4.x

2013-09-19 Thread Braden Shepherdson
The troubling part here is that WebSQL is broken (iOS7 introduced new bugs, too!) on iOS and Android, not supported on non-Webkit browsers, and crap. But... IndexedDB is arguably more crap, though less buggy, but it isn't supported on /anything/ mobile to my knowledge. This has been a crippling

Re: [Android] The state of WebSQL on Android 4.x

2013-09-19 Thread Andrew Grieve
Although WebSQL is deprecated, it's what's currently available in mobile browsers, so having it enables people to write apps that work on the web as well as within a Cordova shell. Let me paste my email code into actual Cordova and see if it works. Having a plugin that provides a DB that works

Re: [Android] The state of WebSQL on Android 4.x

2013-09-19 Thread Joe Bowser
OK, here's a crazy concept that I'm going to throw out there. How about we audit and recommend a third-party plugin and not do any more work on this issue. I know that Android has a SQLite plugin that works like WebSQL, but has a slightly different namespace. I haven't recommended it because I

Re: [Android] The state of WebSQL on Android 4.x

2013-09-19 Thread Michal Mocny
+1 to not reinventing the wheel and sanctioning external contributions if they are available, Joe. Having said that, personally I'd prefer to see an IndexedDB-like-thing instead of a WebSQL-like-thing since thats the direction all desktop browsers have gone, and maps better to web developer

Re: [Android] The state of WebSQL on Android 4.x

2013-09-19 Thread Brian LeRoux
Thats fine by me. We should not care if the w3c and browsers are moving in a different direction anyhow. On Thu, Sep 19, 2013 at 4:38 PM, Joe Bowser bows...@gmail.com wrote: OK, here's a crazy concept that I'm going to throw out there. How about we audit and recommend a third-party plugin

Re: [Android] The state of WebSQL on Android 4.x

2013-09-19 Thread Joe Bowser
OK, how about we do this: 1. We indicate that we no longer support WebSQL on the docs and we list out why we don't support it as it currently exists 2. I'll look at the Android plugin that does do SQLite and see if it's appropriate for Android (if someone could do the same for iOS, that'd be

Re: [Android] The state of WebSQL on Android 4.x

2013-09-19 Thread purplecabbage
wp8 and windows8 support indexed db. Bb10 has partial support. Sent from my iPhone On Sep 19, 2013, at 7:30 AM, Braden Shepherdson bra...@chromium.org wrote: The troubling part here is that WebSQL is broken (iOS7 introduced new bugs, too!) on iOS and Android, not supported on non-Webkit

RE: [Android] The state of WebSQL on Android 4.x

2013-09-19 Thread Parashuram Narasimhan (MS OPEN TECH)
I wrote a IndexedDB Shim that works on WebSQL and I am aware that there are some bugs I need to fix. I am also in the process of converting the IndexedDB shim into a Cordova plugin. However, with iOS7, the size of IndexedDB is still smaller (5MB). Any help with fixing the plugin bugs would be

Re: [Android] The state of WebSQL on Android 4.x

2013-09-19 Thread Brian LeRoux
yup. On Thu, Sep 19, 2013 at 5:42 PM, Joe Bowser bows...@gmail.com wrote: OK, how about we do this: 1. We indicate that we no longer support WebSQL on the docs and we list out why we don't support it as it currently exists 2. I'll look at the Android plugin that does do SQLite and see if

Re: [Android] The state of WebSQL on Android 4.x

2013-09-19 Thread Ian Clelland
On Thu, Sep 19, 2013 at 10:38 AM, Joe Bowser bows...@gmail.com wrote: OK, here's a crazy concept that I'm going to throw out there. How about we audit and recommend a third-party plugin and not do any more work on this issue. +1 I don't think there's enough consensus about whether WebSQL

Re: [Android] The state of WebSQL on Android 4.x

2013-09-19 Thread Andrew Grieve
Tried out my email code, and despite my confidence, it doesn't work :P. So... Joe - like your plan. On Thu, Sep 19, 2013 at 12:32 PM, Brian LeRoux b...@brian.io wrote: yup. On Thu, Sep 19, 2013 at 5:42 PM, Joe Bowser bows...@gmail.com wrote: OK, how about we do this: 1. We indicate

Re: [Android] The state of WebSQL on Android 4.x

2013-09-19 Thread Joe Bowser
OK, I tried the tests included with the plugin, and they don't run. Can someone sanity check this for me? I'm going to try running this on additional devices, since it could be a weird Cyanogen thing. But yeah, if other people can try this plugin, that'd be awesome. On Thu, Sep 19, 2013 at

Re: [Android] The state of WebSQL on Android 4.x

2013-09-19 Thread Andrew Grieve
Managed to get a simpler version of my email coding to work! var ifr = document.createElement('iframe'); ifr.src = websql://foo; ifr.onload = function() { window.openDatabase = function() { return

Re: [Android] The state of WebSQL on Android 4.x

2013-09-18 Thread Jesse
Windows Phone has never supported it. I have always felt that this is more of a browser responsibility and didn't belong in the 'phonegap features' matrix. Just like we don't list querySelectorAll or SVG support. Someone needs to write a JS shim that uses the File API which IS available on all

Re: [Android] The state of WebSQL on Android 4.x

2013-09-18 Thread Andrew Grieve
If it's easy to support, then I think it's worth doing. A custom scheme would work, but I think we can do it with a less intrusive change: We came up with the following hack during our chrome-apps-on-cordova work for having CORS work when on a custom scheme. Should work for WebSQL as well