android - difference between window.openDatabase() and window.sqlitePlugin.openDatabase() functions? -


using cordova version 3.x , android version 2.x 4.x.

i wondering:

  1. is understanding correct android devices default have sqlite program/interface creating sqlite database?
  2. do both above database function calls create sqlite database in device?
  3. if above answer no, type of database both above function calls create?
  4. if answer yes, window.sqlite.opendatabase() function wrapper around window.opendatabase()?
  5. are databases created call persistent? is, data available after closing , reopening cordova packaged apps?
  6. is there maximum database size can created above 2 methods?

  1. websql (window.opendatabase) deprecated web standard. available in desktop , mobile browsers. browsers implement specification using sqlite. in android, browsers , webviews support websql, along local storage , session storage first versions, , indexeddb since kitkat.

then have android independently supports sqlite used java apis 1 of main persistence mechanisms.

cordova special. app runs in webview should using websql, in android plugin overrides api , implants window object new functions might default different implementation, rather browser api.

so in cordova app, once loaded, when call opendatabase calling new function cordova has placed in windows object overriding old standard one. cordova docs:

some devices provide implementation of spec. devices, built-in support used instead of replacing cordova's implementation. devices don't have storage support, cordova's implementation should compatible w3c specification.

that quote ambiguous , no longer in docs. "built-in" meant built-in websql support in webview. docs linked old, 2.x version. in versions, cordova defaulted custom implementation if webview did not support websql (i think never happened) or if device affected bug 16175. default implementation consisted on using storage.java plugin used java api create sqlite database. i've been reading most recent sources , on newer (3.x) versions seem using websqlite always.

  1. yes both create db file path different. in fact can open same db javascript code , java code in app.

  2. same type of db. sqlite native c layer manages file structure. in fact, use native c api native android app.

  3. cordova / phonegap use sqlite built-in support if available (in android is).

  4. yes, stay there.

  5. yes, there's limit. check here more info.


Comments

Post a Comment

Popular posts from this blog

javascript - RequestAnimationFrame not working when exiting fullscreen switching space on Safari -

request animation frame stops working when exiting fullscreen clicking on original space's safari window. fine if fullscreen mode canceled escape key or calling cancelfullscreen(). steps reproduce: open https://dl.dropboxusercontent.com/u/769042/prezi/safari-fullscreen.html click "draw raf", kittie appears click "fullscreen", go fullscreen click "draw raf", kittie appears go space original safari was, showing "click exit fullscreen mode", click anywhere, out fullscreen click "draw raf", nothing happens what handling click calling: window.requestanimationframe(draw); which draws on canvas context: function draw() { ctx.drawimage(img, math.random()*500|0, math.random()*400|0, 100, 100); } i checked .hidden , .visibilitystate, updated correctly. tested on osx 10.9.3, safari 7.0.4 (9537.76.4). has workaround/solution other switching old settimeout? this sounds webkit bug 88940 : using reque
Read more

Python ctypes access violation with const pointer arguments -

i have api i'm trying wrap in python (2.7.6 on win7) code using ctypes. here's api: client_dllfunc bool clientapi search_exporttoclipcopy(clienthsearch handle, int channel, lpctstr filename, const time_t& from, const time_t& to, const bool* cameras, int length, bool usepassword, lpctstr password, bool includetextin = false, bool excludeplayer = false); the issue i'm having cameras argument; , i've had issue other const pointer arguments well. here's how i'm wrapping api: def search_exporttoclipcopy(self, hsearch, csearch, filename, tfrom, tto, cameras, length, usepassword, password, includetextin=true, excludeplayer=false): exporttoclipcopy = self.sdkdll.search_exporttoclipcopy exporttoclipcopy.argtypes = [c_int, c_int, c_wchar_p, c_long, c_long, pointer(c_bool), c_int, c_bool, c_wchar_p, c_bool, c_bool] exporttoclipcopy.restype = c_bool exporttoclipcopy(hsearch, csearch, filename, tfrom, tto, cameras, length, usepassword, pass
Read more