Hacker News Reader

SQLite supports concurrent reads and writes since 2010 with the introduction of the "write ahead log"

Yes, but with a single writer at a time.

From the link you shared: "However, since there is only one WAL file, there can only be one writer at a time".