What happens if two separated threads on the same android application try to access the same table in SQLite database? May I have conflict?
Asked
Active
Viewed 2,702 times
2
-
Please make your question more clear by posting code snippets. – Rajesh Rajaram Sep 13 '12 at 13:34
-
2Not an exact duplicate, but this may well answer your question: http://stackoverflow.com/questions/6675240/is-sqlite-database-instance-thread-safe – Egor Sep 13 '12 at 13:35
-
Please be clear . Provide more details. – URAndroid Sep 13 '12 at 13:46
-
1This question may also be helpful: http://stackoverflow.com/questions/2493331/what-are-the-best-practices-for-sqlite-on-android – wsanville Sep 13 '12 at 13:54
1 Answers
3
The SQLite faq states, that SQLite is thread safe with some (important) caveats. One point above it also states, that concurrent writes are prohibited even from multiple processes, and the write lock is file level. A similar question: Locking a row with SQLite (read lock ?) with a similar answer.
EDIT:
Don't want to steal from others, but the accepted answer in wsanville's question also answers your question perfectly... What are the best practices for SQLite on Android? (copied just in case if the comment's got deleted)
