HowTo: Provide notification to Android app whenever SQLite table updates

Issue

I am in process of developing an Android tablet app using sqllite 3.7.4 which would perform following:

1. Fetches information from the UI

2. Performs some logic and store related information to the sqlite database

3. The stored information has to be send immediately OR at schedule interval (ex. at 5:00 on xyz date) over the network

Currently, we have developed a dispacher mechanism (thread ), which constantly polls the database for new information inserted in the database. The thread fetches the information and send to the network module.

But, I feel this is not the correct approach as Polling every time is a overhead. There can be times when there is nothing to execute It is not real time , because we poll after every 5 seconds

So

Is there a way to send a trigger to my network module as soon as information is updated in database?

Or any better way to achieve this task?

Thanks in advance.

Solution

hope so this will help you

 private Handler h;
    // in create time
        h = new Handler();


// call where you want
h.postDelayed(myRunnable2, 1000); // after 1000 millisecond this function call automatically 

// this function 
private Runnable myRunnable2 = new Runnable() {
        public void run() {
                              // do some thing

                h.postDelayed(myRunnable2, 1000);

        }
    };

Answered By - mohsin raza