How to prevent SQLite from blocking while using R?
I solved the problem by opening the database from sqlitebrowser and typing the following query there: pragma journal_mode=wal;

for more info: https://www.sqlite.org/wal.html