I have an In-Memory DB that is written and read from connections of the same process. All good with shared cache, but I found that TableLock occur more often on In-Memory than on disk DB, probably because in memory we can't use WAL.
Anyway I found the PRAGMA read_uncommitted that from documentation seams a way to read without the problem of table lock. The question is about this sentence "This can lead to inconsistent query results if another database connection modifies a table while it is being read". "inconsistent" means just "out of date"? or there can be some other type of inconsistent data?
