And to make sure the original question is answered in full, this new single transaction with PRAGMA synchronous=FULL doesn't need to originate from the same connection, or the same process even. As Richard said, it will fsync() the WAL file, thus any prior transaction originating from any connection in any process will now be persisted on disk