On 30 Jun 2011, at 6:16pm, Cecil Westerhof wrote:

> As long as the application is
> running, I want to be sure that nobody writes to the database.

This may be sensible if the application never waits for any input.  Some sort 
of bulk-update application, for example, or an overnight batch run.  But if the 
application pauses for input, aren't you giving a user power over the database 
?  They could just start up the application then leave it in the background 
while they browse the web.

Anyway, you do it the way we've already discussed.  Use BEGIN EXCLUSIVE.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to