Comment by wolttam

You accept downtime. That's the limitation of SQLite.

Or you use some distributed SQLite tool like rqlite, etc