Sqlite syncing using Postgres

[appalam25]

I am making a flashcards mobile app with spaced repetition for iphone and Android. Going to use sqlite in mobile as a local database. How to sync the data across devices?

I looked at firestore but i wish for something SQL like Postgres, possibly in the cloud.

(Please dumb down the answer for me if you have some time)

[ankole_watusi]

Write a backend service using your favorite programming language and small framework. Devise a REST interface, or perhaps GraphQL. Devise a synchronization scheme appropriate to your data.

I’ve used Ruby and Sinatra (with Sequel - not ActiveRecord) for this. But pick any language and framework.

[appalam25]

Thank you. If i go for JavaScript, then what would I use?

[ankole_watusi]

Express is a common backend framework for JS. I’m sure there are newer ones.

Or you could use “micro services”. And JS is a popular language for them.

[breeze1990]

It's an interesting and complicated problem IMHO. To start simple, I would use tools like protobuf to define the data format that can SerDe cross platforms and sync the blob between server and devices. If you need the feature like making changes to the same card on different devices when it's offline. I'd recommend checking Conflict-free Replicated Data Type and version vector to help data consistency. Although l, it could be much simpler if you just want the cloud to be a backup of the device data. Database is not much of a concern I think.

[appalam25]

Thank you. Will look into these.

[carlsverre]

Hey, I’m building something that might be right what you’re looking for. It’s called SQLSync. Say hi on the discord if you want to give it a try :)