> PRAGMA journal_mode = WAL

Pretty sure this is a persistent setting. Don't need to set it per-connection.