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 1:

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 wrote: > Managed to get a simpler version of my email coding to work! > >

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 > ifr.contentWindow.openDatabase.apply(ifr

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 10:12

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 wrote: > yup. > > > On Thu, Sep 19, 2013 at 5:42 PM, Joe Bowser wrote: > > > OK, how about we do this: > > > > 1. We indicate that we no longer su

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 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 even belongs in

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 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 it's > appropr

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

2013-09-19 Thread Parashuram Narasimhan (MS OPEN TECH)
AM To: dev; bows...@apache.org Cc: Braden Shepherdson Subject: Re: [Android] The state of WebSQL on Android 4.x +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

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 wrote: > > 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

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 cool)

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 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 >

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 expect

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 do

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 ac

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 pro

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

2013-09-19 Thread Brian LeRoux
Deprecated. On Sep 19, 2013 5:04 AM, "Andrew Grieve" wrote: > 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

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 though.

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 th

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

2013-09-18 Thread Joe Bowser
Ok, We've been ignoring this for quite a while, but it's not going away: There's still people who want to use WebSQL, and WebSQL is still totally broken. Part of the reason it's broken is the fact that Android prevents us from using the official WebSQL API on file URIs, and that we have a nasty c