Hello, I need to integrate an offline first type database into a multiplatform Android and desktop a...

# multiplatform

[אליהו הדס]

Hello, I need to integrate an offline first type database into a multiplatform Android and desktop application, that is to say that I want it to synchronize with my database on my server, I have understood that the best is realm but ideally I would like a fully self-hosted solution, is there a viable alternative? I haven't yet chosen what type of database to use on my server, so it could just as well be SQL or Nosql. Thank you so much.

[אליהו הדס]

Obviously, I don't want to have to download the entire database to synchronize it.
Thanks

[Kobie Botha]

Hi, shameless self-plug… I head up development here at PowerSync and here’s how we rank on your criteria:

• offline-first ✅
• multiplatform Android ✅
• multiplatform Desktop - coming soon
• fully self-hostable ✅
• sync partitions, not full database ✅
Currently we support Postgres but are working on additional ingesters.

Our KMP SDK is released under Apache 2.0 and the sync service under FSL

[Kobie Botha]

If that all sounds good, I’d recommend trying out our self-hosted demo app which has a React frontend.

Then we have a KMP demo app that uses Supabase but which you would be able to modify to connect to your self-hosted instance here.

[אליהו הדס]

Thank you very much, I will check that 🙂