CODEWITHSUNDEEP
androidsqlite
user3794853
user3794853

Reputation: 55

How to make changes to sqlite database for app that is installed in multiple devices?

I started developing an app that uses sqlite that is to be installed on multiple devices and any updates done on sqlite database from any device are to be reflected in other devices as well. I have researched a little and found that Sqlite DB is local to a device and changes done in one device are not reflected in others and for that I have to use external server. Is there any way around it? Is it optimal to directly store data in external server or use sqlite and sync it regularly with external database? Thanks in advance

Upvotes: 0

Views: 145

Answers (2)

lewkka
lewkka

Reputation: 1055

You will achieve your goal using external server. It's not necessary to create your own server, just use data store services like Parse. For more look here.

You can use data directly from external server or cache them on your device first (sqlite, prefs, json etc.) – it's up to you.

Upvotes: 0

Bona Fide
Bona Fide

Reputation: 1067

As far as I know, there isn't a way without an external database. I would recommend you to sync it regularly with an external database.

Checkout this question for more information how to do that:

Answer of Andrew White

Create a webservice (REST is probably best) and serialize your SQLite/MySQL data and PUT/POST/GET it to/from your web service. This will give you a nice layer of abstraction in case you decide to switch from MySQL to something else server side.

Upvotes: 1

Related Questions