SQLite has an option to use a different commit/rollback mechanism called the Write-Ahead-Log. It can alleviate some of the concurrency issues in certain workloads. https://www.sqlite.org/wal.html