What is the best practice when closing SQLiteDatabase in Android?

Question

public SQLiteDatabase getWritableDatabase ()

...

Once opened successfully, the database is cached, so you can call this method every time you need to write to the database. (Make sure to call close() when you no longer need the database.)

As for the SQLiteOpenHelper, I implemented a singleton pattern for the only instance, but how about the SQLiteDatabase?
How effective is the cache?

Android SQLite DB When to Close I looked at this post, but there is no discussion over caching.

Thanks. Then what is the pros of caching? Should I call `close()` every time after I open it? — kenju, Aug 19 '15 at 11:33

score 0 · Accepted Answer · answered Aug 19 '15 at 13:03

0

Open and close your db before and after each operation, respectively.
Never leave it open, when not needed.

Your mantra should be: open it, use it, close it.
Repeat for every db operation.

Same goes for Cursors as well.

answered Aug 19 '15 at 13:03

Phantômaxx

37,901
21
84
115

score 0 · Answer 2 · answered Jun 29 '17 at 23:21

I always close my SQLiteDatabase after every query. For example, here's how I implement my insert methods:

public void insert(ContentValues valuesMap){
    SQLiteDatabase db = getWriteableDatabase();
    try{
       db.insert("ContactsTable", null, valuesMap);
    }catch(Exception e){
       // do someting...
    }finally{
       db.close()
    }
}

What is the best practice when closing SQLiteDatabase in Android?

2 Answers2