none
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 !!!

    Thanks.


    sumitk

    Monday, June 17, 2013 3:32 AM

Answers

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

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

    http://www.sqlite.org/lockingv3.html

    "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