Nope! That’s what the write-ahead log (WAL) is for: https://www.sqlite.org/wal.html

Of course, if you experience scaling issues there (you probably won’t if it’s anything less than enterprise-level usage), you can always just add a second db file!