Turning on WAL is the cheapest SQLite change you can make

Set journal_mode to WAL and write contention drops without touching any business code.

The cost is that -wal and -shm files appear next to the database, so backups have to grab them too. Long-running processes should not open and close the connection repeatedly.