How to check if a Sqlite database exists in android?

Question

I'm pretty new using ORMLite with android, and I read in this question that the method onCreate() of the class OrmLiteSqliteOpenHelper is not called when the database already exists... but I'd like to confirm it by myself, does anyone know how to check if the database exists?

i haven't written a single line of android code in my whole life. here is my answer: an sqlite database is just a file. if the database file exists, the database exists. otherwise it exists not. — Michael
– Michael, Commented May 3, 2014 at 22:04
I understand your point, but I read that ORMLite creates the database in a local storage folder... and you can't access that folder without super user permissions, so... that way it's not as easy as it sounds. — amilcar-sr
– amilcar-sr, Commented May 3, 2014 at 22:09
hmm. if sqlite has readaccess there, your app should have too, no? sqlite is just an ordinary library. or are you communicating with it through some local RPC mechanism? — Michael
– Michael, Commented May 3, 2014 at 22:12
SQLite is a very light weight database which comes with Android OS. The database exists with 2 two default tables android_metadata & sqlite_sequence. — Junius L
– Junius L, Commented May 3, 2014 at 22:26

Loiathal · Accepted Answer · 2014-05-03 22:14:54Z

1

It looks like OrmLiteSqliteOpenHelper inherits the getWritableDatabase() method from SQLiteOpenHelper. If that method returns null, then the database does not exist.

answered May 3, 2014 at 22:14

Loiathal

1262 bronze badges

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

Comments

Junius L · Accepted Answer · 2014-05-03 22:30:19Z

0

You can also create a database by using SQLiteDatabase for example

SQLiteDatabase = StackOverFlowDB;
//Creating database
    StackOverFlowDB = MainActivity.this.openOrCreateDatabase("StackOverFlow", MODE_PRIVATE, null);

answered May 3, 2014 at 22:30

Junius L

16.2k6 gold badges61 silver badges105 bronze badges

Collectives™ on Stack Overflow

How to check if a Sqlite database exists in android?

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related