Android Question Disabling WAL for SQLite database on Android 9

nickkat · Nov 18, 2018

It seems android 9 is enabling by default SQLite databases to use journal mode WAL.
How can I disable this?

I have tried the following but it doesn't seem to do work.

B4X:

 Dim c As Cursor
c = SQL.ExecQuery("pragma journal_mode=delete")
c.Close

Erel · Nov 18, 2018

Please use [code]code here...[/code] tags when posting code.

B4X:

If p.SdkVersion >= 26 Then
   Dim r As Reflector
   r.Target = sql
   r.Target = r.GetField("db")
   r.RunMethod("disableWriteAheadLogging")
End If

Android Question Disabling WAL for SQLite database on Android 9

nickkat

New Member

Erel

B4X founder

Similar Threads

Android Question Disabling WAL for SQLite database on Android 9

nickkat

New Member

Erel

B4X founder

Similar Threads

Privacy & Transparency

Privacy & Transparency