Does calling PRAGMA wal_checkpoint guarantee a sync for the WAL file even if the connection is set to synchronous = 0 ? If yes then great! But if not, is there a way to guarantee a sync from a connection with synchronous = 0? Other than setting it to 2, writing something and setting it back to 0? Also, what about the WAL2 branch? Does a checkpoint guarantee a sync there?