News Score: Score the News, Sort the News, Rewrite the Headlines

SQLite: Wal2 Mode Notes

Activating/Deactivating Wal2 Mode "Wal2" mode is very similar to "wal" mode. To change a database to wal2 mode, use the command: PRAGMA journal_mode = wal2; It is not possible to change a database directly from "wal" mode to "wal2" mode. Instead, it must first be changed to rollback mode. So, to change a wal mode database to wal2 mode, the following two commands may be used: PRAGMA journal_mode = delete; PRAGMA journal_mode = wal2; A database in wal2 mode may only be accessed by versions of SQLi...

Read more at sqlite.org

© News Score  score the news, sort the news, rewrite the headlines