Is syncing two database files on same device possible?

kiddailey

I'm trying to find a solution for keeping a SQLite db in sync and have stumbled upon LiteSync as a possible solution. However, I wanted to ask about a particular implementation first.

Specifically, I would like to be able to sync between two SQLite databases on the same device, one of which is always in use by an app (the secondary) and the other (the primary) which is periodically downloaded/updated and only connected to by the app during a syncing event.

My assumption from reading the details page on the site is that this can be easily done by simply changing the connection URL for each open database (using localhost) and signifying one as the primary and the other as a secondary.

Is this correct or is this something that won't work? Thanks for your reply.

kiddailey

Also - I can't activate my account on the forums. I get an "invalid token" error message every time I try clicking the links sent via email 🙁

Bernardo

Hi!

Sorry for the late response. The forum is not sending me notifications by e-mail anymore.

Yes, it is possible to have two or even more databases in sync on the same device.

But your special requirement of one db being periodically downloaded from another place cannot be served. The databases can be modified by the applications through the modified SQLite library, but you should not replace these db files by others with other content.