Android SQLite DB When to Close

by

i would keep it open the whole time, and close it in some lifecycle method such as onStop or onDestroy. that way, you can easily check if the database is already in use by calling isDbLockedByCurrentThread or isDbLockedByOtherThreads on the single SQLiteDatabase object every time before you use it. this will prevent multiple manipulations to the database and save your application from a potential crash

so in your singleton, you might have a method like this to get your single SQLiteOpenHelper object:

private SQLiteDatabase db;
private MyDBOpenHelper mySingletonHelperField;
public MyDBOpenHelper getDbHelper() {
    db = mySingletonHelperField.getDatabase();//returns the already created database object in my MyDBOpenHelper class(which extends `SQLiteOpenHelper`)
    while(db.isDbLockedByCurrentThread() || db.isDbLockedByOtherThreads()) {
        //db is locked, keep looping
    }
    return mySingletonHelperField;
}

so whenever you want to use your open helper object, call this getter method(make sure it’s threaded)

another method in your singleton may be(called EVERY TIME before you try to call the getter above):

public void setDbHelper(MyDBOpenHelper mySingletonHelperField) {
    if(null == this.mySingletonHelperField) {
        this.mySingletonHelperField = mySingletonHelperField;
        this.mySingletonHelperField.setDb(this.mySingletonHelperField.getWritableDatabase());//creates and sets the database object in the MyDBOpenHelper class
    }
}

you may want to close the database in the singleton as well:

public void finalize() throws Throwable {
    if(null != mySingletonHelperField)
        mySingletonHelperField.close();
    if(null != db)
        db.close();
    super.finalize();
}

if the users of your application have the ability to create many database interactions very quickly, you should use something like i have demonstrated above. but if there is minimal database interactions, i wouldn’t worry about it, and just create and close the database every time.

More Related Contents:

  1. How to add multiple edit text and spinner data into SQLite database?
  2. Hindi font not displying correctly in android [closed]
  3. Share SQLite database between 2 android apps?
  4. Location of sqlite database on the device
  5. Android: upgrading DB version and adding new table
  6. Android P – ‘SQLite: No Such Table Error’ after copying database from assets
  7. Deleting Row in SQLite in Android
  8. Best place to close database connection
  9. Store Android SQLite
  10. Permission Denial: this requires android.permission.INTERACT_ACROSS_USERS_FULL
  11. How to split comma-separated value in SQLite?
  12. Why do I get a “sqlite3: not found” error on a rooted Nexus One when I try to open a database using the adb shell?
  13. Cursor adapter and sqlite example [closed]
  14. Android sqlite how to check if a record exists
  15. Android Persistence room: “Cannot figure out how to read this field from a cursor”
  16. SQLite Exception no such column when trying to select
  17. android java.lang.IllegalStateException: Couldn’t read row 0, col 0 from CursorWindow
  18. Android: column ‘_id’ does not exist
  19. How can I insert image in a sqlite database
  20. Android Cursor with ORMLite to use in CursorAdapter
  21. Is it possible to apply primary key on the text fields in android database
  22. What is The use of moveToFirst () in SQLite Cursors
  23. How to store sqlite database directly on sdcard
  24. sqlite example program in android [closed]
  25. How to check database on not rooted android device
  26. SQLite android column not found
  27. SQlite – Android – Foreign key syntax
  28. Inserting values to SQLite table in Android
  29. Queries with prepared statements in Android?
  30. SQLiteOpenHelper onUpgrade() Confusion Android

Leave a Comment