> On 6 Jun 2019, at 9:11am, Wout Mertens <[hidden email]> wrote:
> > I'd like to create a database in WAL mode if it doesn't exist
> Create it without the flag then execute
> PRAGMA journal_mode=WAL
Ah no, you see, the problem is that I can have multiple processes creating
the file at the same time, and then it gets ugly with SQLITE_CANTOPEN and
SQLITE_BUSY. I'd like to avoid that.
Thinking about it, I have to handle these cases anyway when opening an
existing DB that's not in WAL mode, but still, it's cleaner to start it in
WAL mode from the get-go.