On: SQLite: Wal2 Mode

[runiq]

Hmm, I don't think I follow—what is the third buffer?

[stavros → runiq]

The main database file, the WAL, and the second WAL. Though I do agree with you that I also think about this as double-buffering, as I think of the database file as the screen.

[masklinn → runiq]

Database actual?

The buffering analogy doesn’t really work tho, because all three sources (db file, wal being flushed, and wal being written to) are read sources.