sqlite wal policy is steal & force and has undo and no redo ?
(1) By Lewis (baiwfg2) on 2021-11-26 02:53:45 [source]
Hi, all I wonder what sqlite wal policy is. From some materials, I guess sqlite wal policy has 'steal', meaning there's undo log (the rollback jounal), and has 'force', meaning no redo log. Is that correct ?
(2) By Simon Slavin (slavin) on 2021-11-26 16:02:13 in reply to 1 [link] [source]
SQLite's journal modes are a picky detail of the internal workings of SQLite. Switching from one journal mode to another does not change what commands a programmer can give SQLite, or what SQL commands SQLite can implement unless the programmer disables journalling entirely.
To find out SQLite's abilities relating to 'undo' and 'redo', read these two pages in the order I give them: