Bundling sqlite can cause data corruption on Android N and later about sqlite-android HOT 7 OPEN

Could you share what about Android N causes an issue? this library doesn't link against the system sqlite version, instead it contains its own separate version. There is a another issue mentioned that is maybe more relevant about multiple sqlite instances linked to an app, I think that is true you should avoid using the Android OS sqlite APIs and this libraries APIs on the same db file at the same time but that is true for any Android OS version. Is that the issue you think you were seeing ?

from sqlite-android.

Please see here for what I know, which is not much, unfortunately:

https://github.com/M66B/FairEmail/blob/master/FAQ.md#redmi

I am not 100% sure if this is the issue, though. With the data gone, debugging and error reporting become hard, not to say impossible.

I can say it is happening more often than before, possibly because the number of people using Android N or later is increasing.

I also know that, for example, the Android work manager uses sqlite as well.

from sqlite-android.

There is some more information here:

https://ericsink.com/entries/multiple_sqlite_problem.html

from sqlite-android.

Linking two sqlite libraries (requery's and Android's) is known to result in occasional corruption:

https://sqlite.org/howtocorrupt.html#multiple_copies_of_sqlite_linked_into_the_same_application

There is a proof of concept here:

https://github.com/jeremysheeley/Android_N_SQLite_Corruption

from sqlite-android.

For those cases the two instances have to be operating on the same database file. As long as you ensure you are not using both apis concurrently on the same database file there should be no issue.

from sqlite-android.

That was my thought too, but in practice I am still seeing more database corruption than expected.

I will respond here after a while if I see changes.

from sqlite-android.

I haven't seen any case of data loss anymore since removing this library from the app. That can't be coincidence.

from sqlite-android.