Android - create and store SQLite database for use by Javascript

Question

I have a Phonegap / Cordova application which needs to bundle a SQLite database (about 7mb). I then wish to access that database using Javascript (jQuery mobile).

How do I approach this? I don't want to use HTML5 local storage as it does not have enough capacity and will be deleted after use. It has to be the native Android SQLite plus the javascript connectivity.

Thanks in advance!

Nick

score 0 · Answer 1 · edited May 23 '17 at 12:34

0

Last time I checked several months ago, it was imposible. Here is a similar question JavaScript sqlite, and this other one might be more useful http://luthfihariz.wordpress.com/2011/10/23/android-sqlite-phonegap-jquerymobile/

edited May 23 '17 at 12:34

Community

1
1

answered Jun 20 '12 at 16:34

CarlosJ

244
3
13

Raghav · Answer 2 · 2012-06-29T11:25:57.087

0

Update I just found that it is possible to create SQLite database using phonegap, Read more here http://docs.phonegap.com/en/1.4.1/phonegap_storage_storage.md.html#Database

 window.openDatabase(name, version, display_name, size);

Hello you can make use of WebView, and use addJavascriptInterface(Object, String), this lets you use java methods from javascript. You can write methods to store, retrieve in java and later access them via javascript.

edited Jun 29 '12 at 11:25

answered Jun 20 '12 at 16:40

Raghav

4,590
1
22
32

this is not native SQLite but the WebSQL which is based on SQLite but not identical. – tkit Dec 14 '12 at 11:36

Android - create and store SQLite database for use by Javascript

2 Answers2