On 21 Feb 2011, at 9:46pm, Frank Chang wrote:

> I was wondering why other selects who need to only read from a sqlite 
> database need to use the sqlite3_busy_handlers. Is it because database 
> connection which are writing to the sqlite database have a higher priority 
> then database connections which are reading from the sqlite database?

Correct.  You cannot read from a database while something is making changes in 
it.  You might get part of a batch of changes.  For instance, you might get a 
new transaction, but not the updated account balance.

Simon.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to