You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cordova.apache.org by Joe Bowser <bo...@gmail.com> on 2013/02/21 01:06:58 UTC
Which database do we use on Cordova for WebSQL?
While investigating this irritating issue
(https://issues.apache.org/jira/browse/CB-2085), I found that when we
first open the database, we are using the built-in WebKit Database,
but once I go into child browser and go back, we start to use the
Storage plugin. Does anyone remember which scenarios we use our
Storage Plugin, and which scenarios we use the built in storage,
because this is unclear based on the example provided.
Joe
Re: Which database do we use on Cordova for WebSQL?
Posted by Joe Bowser <bo...@gmail.com>.
It depends on if the platform has another way of storing data. I do
agree that the solution that requires the least amount of effort is
the right one in this case. I just made sure that we turn off WebSQL
on WebKit and just use our own version on Android.
On Thu, Feb 21, 2013 at 3:20 PM, Jesse <pu...@gmail.com> wrote:
> I am suggesting do not resuscitate, or at least no heroic measures. If it
> can be easily fixed, then I would do it, but otherwise, advise of other
> ways of storing data.
>
> Something like LawnChair might make sense.
> http://brian.io/lawnchair/adapters/
>
>
>
> On Thu, Feb 21, 2013 at 2:50 PM, Giorgio Natili <g....@gnstudio.com>wrote:
>
>> So your are suggesting to remove it from Cordova in favor of IndexDB?
>>
>> On 2/21/13 9:26 PM, "Jesse" <pu...@gmail.com> wrote:
>>
>> >As an aside, WebSQL is a deprecated storage spec, and is not supported on
>> >WP7, WP8, or Windows 8.
>> >WP8 and Win8 do however support IndexedDB, and apparently BB10 does too.
>> >
>> >On Thu, Feb 21, 2013 at 11:27 AM, Joe Bowser <bo...@gmail.com> wrote:
>>
>>
>>
>
>
> --
> @purplecabbage
> risingj.com
Re: Which database do we use on Cordova for WebSQL?
Posted by Jesse <pu...@gmail.com>.
I am suggesting do not resuscitate, or at least no heroic measures. If it
can be easily fixed, then I would do it, but otherwise, advise of other
ways of storing data.
Something like LawnChair might make sense.
http://brian.io/lawnchair/adapters/
On Thu, Feb 21, 2013 at 2:50 PM, Giorgio Natili <g....@gnstudio.com>wrote:
> So your are suggesting to remove it from Cordova in favor of IndexDB?
>
> On 2/21/13 9:26 PM, "Jesse" <pu...@gmail.com> wrote:
>
> >As an aside, WebSQL is a deprecated storage spec, and is not supported on
> >WP7, WP8, or Windows 8.
> >WP8 and Win8 do however support IndexedDB, and apparently BB10 does too.
> >
> >On Thu, Feb 21, 2013 at 11:27 AM, Joe Bowser <bo...@gmail.com> wrote:
>
>
>
--
@purplecabbage
risingj.com
Re: Which database do we use on Cordova for WebSQL?
Posted by Giorgio Natili <g....@gnstudio.com>.
I understand your point and the dependencies from the onboard browser.
Even more I agree is not an high priority but I'm also with Jesse about
"don't resuscitate".
Giorgio
On 2/22/13 12:23 AM, "Brian LeRoux" <b...@brian.io> wrote:
>We will not be adding new databases or removing old ones. The priority
>for WebSQL is super low. We will just continue to allow whatever the
>onboard browser allows.
Re: Which database do we use on Cordova for WebSQL?
Posted by Brian LeRoux <b...@brian.io>.
We will not be adding new databases or removing old ones. The priority
for WebSQL is super low. We will just continue to allow whatever the
onboard browser allows.
On Thu, Feb 21, 2013 at 2:50 PM, Giorgio Natili <g....@gnstudio.com> wrote:
> So your are suggesting to remove it from Cordova in favor of IndexDB?
>
> On 2/21/13 9:26 PM, "Jesse" <pu...@gmail.com> wrote:
>
>>As an aside, WebSQL is a deprecated storage spec, and is not supported on
>>WP7, WP8, or Windows 8.
>>WP8 and Win8 do however support IndexedDB, and apparently BB10 does too.
>>
>>On Thu, Feb 21, 2013 at 11:27 AM, Joe Bowser <bo...@gmail.com> wrote:
>
>
Re: Which database do we use on Cordova for WebSQL?
Posted by Giorgio Natili <g....@gnstudio.com>.
So your are suggesting to remove it from Cordova in favor of IndexDB?
On 2/21/13 9:26 PM, "Jesse" <pu...@gmail.com> wrote:
>As an aside, WebSQL is a deprecated storage spec, and is not supported on
>WP7, WP8, or Windows 8.
>WP8 and Win8 do however support IndexedDB, and apparently BB10 does too.
>
>On Thu, Feb 21, 2013 at 11:27 AM, Joe Bowser <bo...@gmail.com> wrote:
Re: Which database do we use on Cordova for WebSQL?
Posted by Jesse <pu...@gmail.com>.
As an aside, WebSQL is a deprecated storage spec, and is not supported on
WP7, WP8, or Windows 8.
WP8 and Win8 do however support IndexedDB, and apparently BB10 does too.
On Thu, Feb 21, 2013 at 11:27 AM, Joe Bowser <bo...@gmail.com> wrote:
> OK, here's some annoying crap that the Android team did to the
> browser. Back in Honeycomb, file:// was no longer allowed to use the
> WebSQL database because of security reasons. I have no idea what
> those security reasons are, but this is the same case all the way up
> to Jellybean. Therefore, we use or Storage shim instead. The problem
> is that we enable web storage on Cordova, which is a major problem.
> So, I'm trying to disable this for 3.0+ now and I'll see how that
> works.
>
> So, a technical workaround because the Android team doesn't believe
> that Cordova should have access to WebSQL. :(
>
> On Thu, Feb 21, 2013 at 11:13 AM, Simon MacDonald
> <si...@gmail.com> wrote:
> > There is no reason why we should do that. It seems like a 0 day bug to
> me.
> >
> > Simon Mac Donald
> > http://hi.im/simonmacdonald
> >
> >
> > On Thu, Feb 21, 2013 at 2:05 PM, Filip Maj <fi...@adobe.com> wrote:
> >> I want to say that we needed this to polyfill on some older Androids..
> But
> >> this is speculation :s
> >>
> >> On 2/20/13 4:06 PM, "Joe Bowser" <bo...@gmail.com> wrote:
> >>
> >>>While investigating this irritating issue
> >>>(https://issues.apache.org/jira/browse/CB-2085), I found that when we
> >>>first open the database, we are using the built-in WebKit Database,
> >>>but once I go into child browser and go back, we start to use the
> >>>Storage plugin. Does anyone remember which scenarios we use our
> >>>Storage Plugin, and which scenarios we use the built in storage,
> >>>because this is unclear based on the example provided.
> >>>
> >>>Joe
> >>
>
--
@purplecabbage
risingj.com
Re: Which database do we use on Cordova for WebSQL?
Posted by Joe Bowser <bo...@gmail.com>.
OK, here's some annoying crap that the Android team did to the
browser. Back in Honeycomb, file:// was no longer allowed to use the
WebSQL database because of security reasons. I have no idea what
those security reasons are, but this is the same case all the way up
to Jellybean. Therefore, we use or Storage shim instead. The problem
is that we enable web storage on Cordova, which is a major problem.
So, I'm trying to disable this for 3.0+ now and I'll see how that
works.
So, a technical workaround because the Android team doesn't believe
that Cordova should have access to WebSQL. :(
On Thu, Feb 21, 2013 at 11:13 AM, Simon MacDonald
<si...@gmail.com> wrote:
> There is no reason why we should do that. It seems like a 0 day bug to me.
>
> Simon Mac Donald
> http://hi.im/simonmacdonald
>
>
> On Thu, Feb 21, 2013 at 2:05 PM, Filip Maj <fi...@adobe.com> wrote:
>> I want to say that we needed this to polyfill on some older Androids.. But
>> this is speculation :s
>>
>> On 2/20/13 4:06 PM, "Joe Bowser" <bo...@gmail.com> wrote:
>>
>>>While investigating this irritating issue
>>>(https://issues.apache.org/jira/browse/CB-2085), I found that when we
>>>first open the database, we are using the built-in WebKit Database,
>>>but once I go into child browser and go back, we start to use the
>>>Storage plugin. Does anyone remember which scenarios we use our
>>>Storage Plugin, and which scenarios we use the built in storage,
>>>because this is unclear based on the example provided.
>>>
>>>Joe
>>
Re: Which database do we use on Cordova for WebSQL?
Posted by Simon MacDonald <si...@gmail.com>.
There is no reason why we should do that. It seems like a 0 day bug to me.
Simon Mac Donald
http://hi.im/simonmacdonald
On Thu, Feb 21, 2013 at 2:05 PM, Filip Maj <fi...@adobe.com> wrote:
> I want to say that we needed this to polyfill on some older Androids.. But
> this is speculation :s
>
> On 2/20/13 4:06 PM, "Joe Bowser" <bo...@gmail.com> wrote:
>
>>While investigating this irritating issue
>>(https://issues.apache.org/jira/browse/CB-2085), I found that when we
>>first open the database, we are using the built-in WebKit Database,
>>but once I go into child browser and go back, we start to use the
>>Storage plugin. Does anyone remember which scenarios we use our
>>Storage Plugin, and which scenarios we use the built in storage,
>>because this is unclear based on the example provided.
>>
>>Joe
>
Re: Which database do we use on Cordova for WebSQL?
Posted by Filip Maj <fi...@adobe.com>.
I want to say that we needed this to polyfill on some older Androids.. But
this is speculation :s
On 2/20/13 4:06 PM, "Joe Bowser" <bo...@gmail.com> wrote:
>While investigating this irritating issue
>(https://issues.apache.org/jira/browse/CB-2085), I found that when we
>first open the database, we are using the built-in WebKit Database,
>but once I go into child browser and go back, we start to use the
>Storage plugin. Does anyone remember which scenarios we use our
>Storage Plugin, and which scenarios we use the built in storage,
>because this is unclear based on the example provided.
>
>Joe