I'm looking to start a project using SQLite to handle some database transactions. I have question about how SQLite handles Concurrency. I read up on SQLite.org about the file locking and concurrency but I didn't really get the info I wanted (at least I didn't walk away with an answer in the terms I wanted it).
My question is the following: If I have 2 separate processes, 1 of which will attempt to Read and Write a Database (Process A) and the 2nd which will only Read the database (Process B), then if Process A is in the middle of a Write when Process B tries to read what will happen? Will the Read request be blocked and Process B will wait or will SQLite return some kind of Busy Error Code to process B and it is up to Process B to try again later? And Vice versa, What happens if Process B is reading while A tries to write? Same answer as above? I'm very much a newbie to SQLite so patience is requested. Thanks in advance -- View this message in context: http://www.nabble.com/Concurrency-Question-tp24867278p24867278.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
