Can multiple applications or multiple instances of the same application access a single database file at the same time? RRS feed

  • Question

  • Hi all,

    How can we maintain concurrency in SQlite database(Version-3) which is accessing by multiple threads /Apps.

    and if we cannot maintain concurrency in SQlite then which database is useful for my app?

    Please Help !!!



    Monday, June 17, 2013 3:32 AM


  • You may get more responses for this issue at SQLite specific sites.

    For the problem itself, you may refer to this link:

    "this document continues to serve as an authoritative reference to how database file locking works in SQLite version 3."

    Based on this document, I think that multiple clients can read the database at the same time. However, only one client can write the database at a time.

    Monday, June 17, 2013 1:24 PM