Made a discovery today that Cordova's Quota logic was wrong. Filed this as https://issues.apache.org/jira/browse/CB-5193 and fixed it :). Multiple databases should work fine starting in 3.2 / 2.9.1.
On Thu, Oct 10, 2013 at 3:09 PM, Dick Van den Brink < d_vandenbr...@outlook.com> wrote: > Hi Andrew, > > Thanks for the input, hadn’t figured that out yet! I might try it tomorrow > if I have the time. Going on a vacation next week and got lots of work to > do. > > Again thanks for looking in to it! > > Regards, > > Dick van den Brink > > > From: agri...@chromium.org > > Date: Thu, 10 Oct 2013 14:45:45 -0400 > > Subject: Re: So, what to do about storage issues? > > To: dev@cordova.apache.org > > > > Tried out your sample. Certainly shows the problem well. > > > > After more playing, I know more about the problem than I think I'd like > :P. > > > > It's not that you can't open multiple databases, it's that you can create > > only one database. What I mean is, if you ever restart the app and use a > > different name for the database, it will fail as well. > > > > The only way I could get it to work was to use sqlite3 on the native side > > to pre-create a second database. If you do that, then you can open > multiple > > at a time. I did it by changing the db path to /sdcard/dbs and using adb > to > > move the files back and forth to my computer. > > > > So... I don't think I'm going to invest any more time into this. I just > > added caveats to the websql README about not being able to open multiple > > databases. If you really can't live without this feature, you might try > > writing a plugin that pre-creates a database for you so that you can > later > > open it with openDatabase() > > > > > > On Thu, Oct 10, 2013 at 5:02 AM, Dick Van den Brink < > > d_vandenbr...@outlook.com> wrote: > > > >> Not sure what the namespace issue is, but I created a quick example > >> project. > >> It might not be the best code but that doesn't really matter. :-)Code is > >> on: https://github.com/DickvdBrink/cordova-websql/ > >> after the checkout you might need to run "android update project --path > >> platforms/android"It always opens one db, with the name "firstDb" in the > >> deviceready event.When you click the the text: "Click here to load db > with > >> name "secondDb" I get a security error in the javascript alert box.If > you > >> don't get the error it changes the text to "Second db loaded". > >>> Date: Wed, 9 Oct 2013 08:44:08 -0700 > >>> Subject: Re: So, what to do about storage issues? > >>> From: bows...@gmail.com > >>> To: dev@cordova.apache.org > >>> > >>> I think this is the namespace issue. We need to make sure the plugin > >>> always overrides the default namespace. > >>> On Oct 9, 2013 8:00 AM, "Andrew Grieve" <agri...@chromium.org> wrote: > >>> > >>>> Example project would be great! > >>>> > >>>> > >>>> On Wed, Oct 9, 2013 at 10:27 AM, Dick Van den Brink < > >>>> d_vandenbr...@outlook.com> wrote: > >>>> > >>>>> I don't think it is fixed with the org.apache.cordova.websql plugin.I > >>>>> still can open only one database. The second one is giving me a > >> security > >>>>> error on Android 4.1.2. > >>>>> I'm on Cordova 3.0 btw. I added some logging to the websql plugin > >> code to > >>>>> make sure it was using it and that seems to be the case. I can > >> create an > >>>>> example project if you want. > >>>>> > >>>>>> From: agri...@chromium.org > >>>>>> Date: Wed, 9 Oct 2013 10:04:14 -0400 > >>>>>> Subject: Re: So, what to do about storage issues? > >>>>>> To: dev@cordova.apache.org > >>>>>> > >>>>>> I think let's document the quirks (CB-4760), and close the other > >> two as > >>>>>> fixed (via org.apache.cordova.websql plugin) > >>>>>> > >>>>>> > >>>>>> On Tue, Oct 8, 2013 at 5:55 PM, Shazron <shaz...@gmail.com> wrote: > >>>>>> > >>>>>>> Not sure you guys got Ray's message below if you were on Gmail -- > >>>>> since it > >>>>>>> filtered it out as spam (confirmed with another committer/Gmail > >> user) > >>>>> :/ > >>>>>>> > >>>>>>> > >>>>>>> On Tue, Oct 8, 2013 at 2:30 PM, Ray Camden <rayca...@adobe.com> > >>>> wrote: > >>>>>>> > >>>>>>>> Hmm, from CB-4760: > >>>>>>>> > >>>>>>>> "The problem is that the Storage Guide documentation > >>>>>>>> ( > >>>>>>>> > >>>>>>> > >>>>> > >>>> > >> > http://cordova.apache.org/docs/en/3.0.0/cordova_storage_storage.md.html#St > >>>>>>>> orage) currently doesn't mention any Android Quirks at all, so > >> as > >>>>> far as > >>>>>>>> user knows it should all work OK as per the API guide." > >>>>>>>> > >>>>>>>> Yeah - this is what worries me the most. Couldn't the docs be > >>>> updated > >>>>>>>> pretty quickly to let folks know about issues? > >>>>>>>> > >>>>>>>> > >>>>>>>> On 10/8/13 4:05 PM, "Joe Bowser" <bows...@gmail.com> wrote: > >>>>>>>> > >>>>>>>>>What should we do for Storage Plugin issues on Android? > >> Should we > >>>>> just > >>>>>>>>>close them as "Won't Fix" and tell people to use the > >> cordova-labs > >>>>>>>>>plugins? Currently, we don't have a plugin repo for the > >> storage > >>>>>>>>>plugin, and it's been ripped out in 3.x. > >>>>>>>>> > >>>>>>>>>What should we do with these issues?? > >>>>>>>>>https://issues.apache.org/jira/browse/CB-4506 > >>>>>>>>>https://issues.apache.org/jira/browse/CB-4505 > >>>>>>>>>https://issues.apache.org/jira/browse/CB-4760 > >>>>>>>>> > >>>>>>>>>Thoughts? > >>>>>>>>> > >>>>>>>>>Joe > >>>>>>>> > >>>>>>>> > >>>>>>> > >>>>> > >>>>> > >>>> > >> > >> >