Data synchronization between sqlite and mysql android

Question

Currently I'm working on an app in which, I use sqlite database when there is no internet connection on device and use web services when internet is available.

I have to ask that what, is the best method for synchronization?

Is it possible by setting flags and check for updates and then synchronize.
or any tool is available which takes care of that.
or any other method available.

I want to sync SQLite database with MySQL whenever internet connection is found. — Pratik Butani
– Pratik Butani, Commented Apr 22, 2013 at 5:22

Deepanker Chaudhary · Accepted Answer · 2012-12-24 06:00:02Z

2

I think make a boolean function just like:-

public static boolean isNetworkAvailable(Context context) {
    ConnectivityManager connectivityManager = (ConnectivityManager) context
            .getSystemService(Context.CONNECTIVITY_SERVICE);
    NetworkInfo info = connectivityManager.getActiveNetworkInfo();
    if (info == null)
        return false;

    return info.isConnected();
}

& Check if Network is available :-- Call Web Services otherwise Call Your SQLite Database.

answered Dec 24, 2012 at 6:00

Deepanker Chaudhary

1,7043 gold badges15 silver badges36 bronze badges

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

Comments

Paresh Mayani · Accepted Answer · 2012-12-24 06:26:34Z

2

You can do one thing:

Whenever you make a web call, return one field value "LastSyncedDate", store this date value in Android app.

So whenever you make a web call next time, send this stored value inside web call.

Note: This answer is for checking last synced made in android app.

edited Dec 24, 2012 at 6:26

answered Dec 24, 2012 at 5:56

Paresh Mayani

129k71 gold badges244 silver badges297 bronze badges

1 Comment

Sumedh Tambat Over a year ago

thanks for your answer....but is there any ready tool available which take care of synchronization.

Austin Brougher · Accepted Answer · 2012-12-26 17:56:30Z

1

SymmetricDS Pro is a tool designed to synchronize SQLite databases on Android.

SymmetricDS now has its web-enabled, fault-tolerant, database synchronization software available on the Android mobile computing platform. The Android client follows all of the same concepts and brings to Android all of the same core SymmetricDS features as the full-featured, Java-based SymmetricDS client. The client is designed to be referenced as a library to run in-process with an Android application requiring synchronization for its SQLite database.

Synchronizing Android Applications

answered Dec 26, 2012 at 17:56

Austin Brougher

5262 silver badges9 bronze badges

Collectives™ on Stack Overflow

Data synchronization between sqlite and mysql android

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related