How to enable WAL (write ahead log) in a C++ program?

Question

I currently have two different processes, one process writes into a database and the other one reads and updates the records in the database that were inserted by the first process. Every time I try to start both processes concurrently the database gets locked, makes sense. Due to simultaneous read and write. I came across WAL, but haven't been able to come across any example as to how to enable WAL in a c++ code. Any help would be appreciated. Thanks.

Answer 1

To activate it, as per the documentation you just need to run the following statement:

PRAGMA journal_mode=WAL

This is persistent and only needs to be applied once.