sqliteandroid-sqlitejournaling

function to check if SQLite is using journal_mode=WAL or journal_mode=DELETE

I was looking for function which would help me to see which journaling mode is enabled.. I looked here too list of function
There was function to check database status sqlite3_db_status(....) but status parameter didn't have option for check journaling mode

Is there a function or any way to find if sqlite db is using WAL-mode or normal journaling mode ..!!

Solution

  • To query the journal mode of a connection, execute PRAGMA journal_mode and read the result.