sqlite journal file location

Question

Curently sqlite is writing journal file in the same directory where is placed database file. It makes a problem with the directory permission (it has to be writable). Is there any method to force sqlite to write journal files in other directory?

Answer 1

No, but you can use PRAGMA journal_mode = PERSIST.