Sync SQLite DB on android app with the remote MySQL DB

Question

I am working on an android(Java) project where I want to update my SQLite database with a remote MySQL database info.

Initially I want to create the SQLite DB as exact remote MySQL database. After that Application normally deal with the SQLite DB.

Then when application shut down and start again if any modification happened to remote MySQL database I want to sync sqlite database with the MySQL database info.

Can anyone give any idea how I can accomplish this task. Thank you

Maverick · Accepted Answer · 2011-10-01 09:11:04Z

1

You can use android service API android.app.Service for achieving this.

You just have to run a service which will check the server database changes and if there is changes get the data from the server.

But to run that service you have to write a BroadcastReceiver which will tell service to run after specified time or after application started depending upon the requirement

answered Oct 1, 2011 at 9:11

Maverick

3,0536 gold badges27 silver badges31 bronze badges

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

Comments

0909EM · Accepted Answer · 2011-07-31 17:57:51Z

0

Use an Account Authenticator? Alternatively use a service API (See Google I/O talk on you tube http://www.youtube.com/watch?v=xHXn3Kg2IQE fast forward to 37:37)

answered Jul 31, 2011 at 17:57

0909EM

5,0773 gold badges32 silver badges42 bronze badges

Collectives™ on Stack Overflow

Sync SQLite DB on android app with the remote MySQL DB

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related