I have some experience with different databases and system designs. In one of my last projects I used SQLite. However, I used only one dedicated process for wri

I have some experience with different databases and system designs. In one of my last projects I used SQLite. However, I used only one dedicated process for writing and other processes for read only. This might help.