Read-only on an SQLite database which is being modified by another program
You are looking for WAL Mode.


  WAL provides more concurrency as readers do not block writers and a
  writer does not block readers. Reading and writing can proceed
  concurrently.