Hi, I’ve been trying for a while now to use an SQL database on Android (with 5.1) to cache downloaded data. Everything about my DB setup works perfectly on Win64, all creation, opening, writing, reading, queries, work perfectly. But when I swap to an Android build I just seem to hit obstacles at every turn.
Just today I finally navigated past the actual creation of the database by using GInternalFilePath (to bypass any permissions wrangling) instead of ProjectSavedDir(). Finally,
Database->Open(*(SessionPath / DatabaseFileName), ESQLiteDatabaseOpenMode::ReadWriteCreate)
actually executes successfully. However the next step I call
Database->PerformQuickIntegrityCheck()
and it falls right over again deep inside sqlite3 with an SQLITE_IOERR error.
From what I can tell this means that the database is read only, but…but…but… I’ve just created it using ReadWriteCreate. What? NNnggghhhh.
So long story short, I’m at a loss as to how to do this properly on Android, has anyone got any pointers as I don’t know where to look next.
(Min SDK : 26, Target SDK : 28)
TIA.