You issue `pragma journal_mode=wal` once after creating the database. The change is persistent.

https://www.sqlite.org/wal.html#persistence_of_wal_mode