Which database to use for android application?

Question

I need some database on my phonegap android application. I read about WebSQL and tried it, and I don't know if it stays after I close the app or it must be made every time i open the app. I need to keep data when app closes so i can use it when i open it again. What database should I use?

P.S. If u have some tutorial it would be nice. Thanks

use sqlite [1]: http://stackoverflow.com/questions/6647474/how-to-implement-a-sqlite-database-in-phonegap — , Mar 28 '14 at 19:40

score 2 · Accepted Answer · edited May 23 '17 at 12:11

2

The best option to store data in database for an Android Application using PhoneGap must be SQLite:

Android Storage Options

but you can use too WebSQL: SQLite database on PhoneGap

See this question suggested by sajad:

How to implement an SQLite database in Phonegap?

and a Tutorial: Create Android App with SQLite using Phonegap

edited May 23 '17 at 12:11

Community

1
1

answered Mar 28 '14 at 19:44

Jorgesys

124,308
23
334
268

score 0 · Answer 2 · answered Mar 28 '14 at 19:44

Follow this tutorial to learn how to use/create SQLite database in phonegrap (from official doc).

var db = window.openDatabase("test", "1.0", "Test DB", 1000000);

This method will create a new SQL Lite Database and return a Database object. Use the Database Object to manipulate the data.

Syntax + Tutorial:

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

Example from the page:

function populateDB(tx) {
     tx.executeSql('DROP TABLE IF EXISTS DEMO');
     tx.executeSql('CREATE TABLE IF NOT EXISTS DEMO (id unique, data)');
     tx.executeSql('INSERT INTO DEMO (id, data) VALUES (1, "First row")');
     tx.executeSql('INSERT INTO DEMO (id, data) VALUES (2, "Second row")');
}

function errorCB(err) {
    alert("Error processing SQL: "+err.code);
}

function successCB() {
    alert("success!");
}

var db = window.openDatabase("Database", "1.0", "PhoneGap Demo", 200000);
db.transaction(populateDB, errorCB, successCB);

I found this tutorial too.

I've seen that and the only problem is where does he put the database. I tried to create db, fill it, close app, and when i opened it I couldn't get data. — JaSamSale, Mar 28 '14 at 19:48

score 0 · Answer 3 · answered Mar 29 '14 at 07:16

To view the data stored in the database, follow these steps:

Click on Windows > Open Perspective > DDMS. Go to File Explorer.
Then /data/data/package_name/databases.But here we cannot see the tables and table data.
For viewing the table details Eclipse has a plugin. Download it from http://androidcode-sqlite.blogspot.in/2013/04/sqlitemanager-plugin-for-eclipse-android.html.
Now put the jar in the folder eclipse/dropins/.
Click on Java Build Path > Libraries > Add External JARs > Choose Your Path to the SQLite JAR File! Add it.
Restart the eclipse and now you can see the SQLite Manager plugin on the top right of the File Explorer window.
Click on (database name), then click on “open file in SQLite Manager...”.

Here, click on “Questoid SQLite Manager” tab and you can see your table in “Database Structure” tab. Then, click on “Browse Data” tab to view your table data.

Which database to use for android application?

3 Answers3