How do you workaround the fact that SQLite only supports a single writer? For example, your app could be blocked when you run a long operation like creating an index.
From the link you shared: "However, since there is only one WAL file, there can only be one writer at a time".