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

Community · Accepted Answer · 2017-05-23 12:34:11Z

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, 2017 at 12:34

CommunityBot

11 silver badge

answered Jun 20, 2012 at 16:34

CarlosJ

2443 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Raghav · Accepted Answer · 2012-06-29 11:25:57Z

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, 2012 at 11:25

answered Jun 20, 2012 at 16:40

Raghav

4,6381 gold badge24 silver badges33 bronze badges

1 Comment

tkit Over a year ago

this is not native SQLite but the WebSQL which is based on SQLite but not identical.

Collectives™ on Stack Overflow

Android - create and store SQLite database for use by Javascript

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related