SQLite - reading and writing in the same time without WAL mode

Question

In my application I do multi-threads to perform different operations in the background. I know that I can solve it by making the Data-base SingleTon and use the WRITE_AHEAD_LOGGING privilege, but this only supported from API 16 and higher. I have a lot of users that use lower APIs.

Is there another way to solve this problem?

score 0 · Accepted Answer · edited May 23 '17 at 12:05

0

No.

According to the SQLite docs:

Beginning with version 3.7.0, a new "Write-Ahead Log" option (hereafter referred to as "WAL") is available.

Before that, SQLite used an exclusive locking mechanism as described here.

Problem is, according to this SO answer, SQLite v3.7.x was added to Android in Honeycomb.

edited May 23 '17 at 12:05

Community

1
1

answered Nov 20 '13 at 16:53

Mister Smith

27,417
21
110
193

What is your advice? Should I use the WAL and prevent the less API or what? – Sami Eltamawy Nov 20 '13 at 17:03
I Have solved it by using the method `enableWriteAheadLog()`. This is enabled starting from API 11. Thank you – Sami Eltamawy Nov 20 '13 at 17:14

SQLite - reading and writing in the same time without WAL mode

1 Answers1