I made an application that stores data to SQLite database. What I wanna do now is to send (via Bluetooth or Share-It or any other alternatives) the data from one device to another device so that the data will be used by the same application from another device. I have searched many times but I always get irrelevant results. Please help thanks!
SQLite is probably not the best solution. However, you could do this with SQLite two ways.
One way would be to copy the entire database from the source and then overwrite the file at the destination. This method has the drawback that there is little, if any, protection of the data (e.g. say user 2 has an empty database and sends it to user 1 who loads it, all data lost).
The other way would be to extract the data via a query, format it it appropriately (make is CSV or perhaps JSON etc), send it, and then use an update/insert query to load the new data. Obviously this would entail having a methodology to prevent duplication/ outdated updates.
Alternative solutions would be to have a centralised database, Firebase being Google's offering.