I think many of you questions on record and database locking can be answered here:

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