> Multiple processes write to foo.db. What method of journaling do you use? WAL?
> Multiple processes read foo.db (no writes at all). Do they open a connection, read, then close the connection, or do you open a connection, read, read, read, read, until the process is terminated, THEN close the connection? (ie, is the connection open all the time) Thanks, Chris On Wed, Mar 6, 2019 at 11:33 AM Anton Polonskiy <anton.polons...@gmail.com> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
