The SQLite documentation indicates that it can handle multiple simultaneous read connections. It only allows one writer at a time, locking the database during the write. If it cannot lock the database, it returns a "database is locked" error.

I'm testing this on a local disk (no NFS shenanigans involved), so the locking mechanism should work.