[ISSUE] Reliable offline storage

[zs-dima]

👟 Reproduction steps

Support ACID support when it is possible.
Access data from different isolates.

👍 Expected behavior

Thanks a lot for implementing so useful feature.
It could be nice to use the most relible local storage for every platform.
For example, the same as Drift library: https://drift.simonbinder.eu/web/
Mobile: SQLite (ACID + https://www.sqlite.org/testing.html)
Web: SQLite+Wasm when browser support it or IndexDB in other case.

Firebase use SQLite for mobile and IndexDB for web for example, that makes it relible and very fast.

👎 Actual Behavior

sembast leads to multiple issues, for example:
https://github.com/tekartik/sembast.dart/issues?q=is%3Aissue+isolate
moreover fixes issues rate to low for this library to account it as a good solution to access local storage: https://github.com/tekartik/sembast.dart/issues

Yes, they have warning in documentation, but it is not a solution:

sembast_sqflite should be used from the main isolate only

You can see how Drift solves all this issues or mabe even use Drift instead Sembast

[joeyouss]

Hi @zs-dima , would it be okay if I close this issue in favor of #67 since they are duplicates?

Also, it would be great if you could upvote the linked issue!

[zs-dima]

@joeyouss thanks fot reply, but it is completely different issue.
I mention !Reliable! offline storage, while current Sembast based solution can miss Reliability.

[ChiragAgg5k]

Appwrite now supports offline support with the help of rxdb, check out more about it here:

1. https://rxdb.info/replication-appwrite.html
2. https://appwrite.io/blog/post/offline-first-journal

Feel free to ask any more queries you might have!