Scenario 1: Multiple processes write to foo.db. I want to do some periodic snapshots. What is the best way to do this without interrupting/blocking writers? sqlite3 foo.db '.backup snapshot.db' ?
Scenario 2: Multiple processes read foo.db (no writes at all). I need to update foo.db without readers interruption and blocking. What is the best way to do this? mv foo-new.db foo.db ? _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users