Threaded and Queued Heavy R/W For Android Databases

MyDatabaseService.java

/**
Android service skeleton that performs intensive off main thread database operations.
This example uses a HandlerThread which will queue up requests rather than parallelize
them, which is good for database operations.
*/
public class MyDatabaseService extends Service {

  private HandlerThread databaseThread;
  private Handler databaseHandler;
  private MyDatabaseHelper dbHelper;
  
  public void onCreate(){
    databaseThread = new HandlerThread("Database");
    databaseThread.start();

    databaseHandler = new Handler(databaseThread.getLooper());
    dbHelper = new MyDataBaseHelper(geApplicationContext);
  }

  /*
  Great pattern for heavy r/w operations that might require some post processing.
  This allows us to synchronize on the Service Class that maintains the SQLite DB
  so we block here until the r/w portion is done, then we unblock and allow for
  post processing while another thread can perform r/w again.
  */
  public void someQueuedOffThreadDatabaseOperation(){
  databaseHandler.post(new Runnable() {
            @Override
            public void run() {
                synchronized (MyDatabaseService.this){
                    try{
                        dbHelper.doMyBidding(<my-params>);
                    }
                    catch (Exception e){
                        Log.e(TAG, e.getMessage());
                    }
                    finally{
                        dbHelper.close();
                    }
                }//End synchronized
            }//End run
        });//End Runnable
    }//End Method
    
}//End Class