I don't know enough about the FS access for WASI, I will only state that IMO, it should include enough support in order for multiple processes to be able to use SQLite against the same DB without clobbering each other.