SQL database in Android

Question

I read about SQLite. I found information about making database in Android but I am wondering about opening existing database written somewhere else. Is there a possibility to open and read database from .sql file which I prepared earlier?

you can use http://sqlitebrowser.org/ – Aditya Vyas-Lakhan Mar 07 '17 at 09:23 — Aditya Vyas-Lakhan, Mar 07 '17 at 09:23

Marcos Holgado Molina · Accepted Answer · 2017-03-07T09:15:16.333

1

I guess you could use SQLiteDatabase db = SQLiteDatabase.openDatabase(pathToYourDatabase, null, SQLiteDatabase.OPEN_READWRITE));

Otherwise you would probably need to open/read the .sql file and use it to create the database + data.

edited Mar 07 '17 at 09:15

answered Mar 07 '17 at 09:03

Marcos Holgado Molina

416
3
10

score 1 · Answer 2 · answered Mar 07 '17 at 09:05

1

Perhaps SQLiteDatabase.openOrCreateDatabase(dbfile, null); is what you want .But only .db file works.

answered Mar 07 '17 at 09:05

xiaoyuan

423
4
13

Thanks for this additional information about .db. :) – Halep Mar 07 '17 at 09:32

score 0 · Answer 3 · answered Mar 07 '17 at 09:11

0

Yes, You can open and read from the existing database file if your app has access to the .DB file. If the .DB file is in another app memory, you will not be able to access it. But if the .DB file is on external storage you can open and read from it.

answered Mar 07 '17 at 09:11

AbhishekB

2,111
3
18
23

SQL database in Android

3 Answers3