-1

I plan to make a meditation journal app which stores all the user's data offline on the user's device, but also offers an option to sync this data to the cloud.

Firebase isn't really a good solution for this as it generally expects that the device will sync to the cloud as its primary source of data.

What is the best database solution which works 100% offline, but which can also be easily synced to the cloud to share the data across multiple devices? To narrow it down further, the cheapest option would also be preferred.

Mustafa Özçetin
  • 1,893
  • 1
  • 14
  • 16
Adam
  • 2,167
  • 5
  • 19
  • 33
  • Opinion questions and sugestions for libraries and services are off topic – Gabe Sechan Jun 08 '23 at 23:22
  • @GabeSechan it's a question with a specific answer. What solutions allow this (not many) and then narrow it down to one answer by being the cheapest. – Adam Jun 09 '23 at 18:55
  • No it isn't. You're asking for opinions on libraries and programs. That's off topic. And I know of over a dozen packages that could answer this. Any question that can be worded as "what software should I use" is pretty much always off topic here. – Gabe Sechan Jun 10 '23 at 13:50
  • @GabeSechan you know over a dozen yet you haven't provided one. I'm glad this is how you spend your time. – Adam Jun 10 '23 at 14:37

2 Answers2

1

You can use Sqlite link for offline and SqlServer for online, when the user is offline use Sqlite and online SqlServer, just synchronize it when is online, but you need a good way to manage structured data in both sides or cases, see the link.

alonso
  • 146
  • 6
0

use Room DB with kotlin coroutines, so you can call queries asyncronously. and it is more easy to use

for more: https://amitshekhar.me/blog/room-database-with-kotlin-coroutines

Begmyrat Mammedov
  • 86
  • 6