Yves Crespin wrote: > if we add a SQLITE_BUSY handle, can we use the sqlite3 .backup when > [some] application is running? > > Is it safe or is there a risk to corrumpt the database or do we need > to change some settings ?
Using the backup API is perfectly safe for your data. The only risk is that the busy timeout is not long enough, and that the application gets blocked by the backup. (However, the sqlite3 shell copies 100 pages at a time, which should never take too long.) Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
