1 Reply Latest reply on Feb 5, 2014 5:05 PM by Jon Tara

    Can you have two applications accessing the same SQLite database?

    Mark Bauer

      Hello,

       

      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. 

       

      Thanks,

       

      MAB

       

      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.