SQLite Forum

Switching pragma synchronous to upgrade durability
Login
If a transaction on a connection previously committed with pragma synchronous set to NORMAL (in WAL mode), but then I need to ensure the transaction is durable, can I switch pragma synchronous to FULL and commit another transaction to force durability for the previous transaction? Or is there some other way to ensure the database is in a fully-durable state?

If yes, would I need to use the same connection as the previous transaction, or would a new connection also produce the same effect?

Thanks,

David