We am looking at two applications that use some "shared" data. One of the applications sync's, and maintains this data while the other just needs to read it. They run at the same time. We have been experiencing the occasional database lock, and are wondering what steps could be taken to avoid this. It is no issue to wait out the lock from the reading application, but the concern occurs when the sync is blocked. Please let me know of any ideas, or experience others have had with this.
PS Our current solution is to write a copy of the database to a temp database and have the reading application look at it instead of the one being sync'ed, and then refresh it.
It's impossible, at least on iOS. Each app has it's own sandbox, the database lives in the app sandbox, there is no access to any common filesystem directory, and reaching across into another app's sandbox is impossible.