Re: [sqlite] Is it safe to use backup at shell level when an application is running

On 7 Nov 2014, at 10:33am, Yves Crespin wrote: > We use sqlite3_open_v2() with > SQLITE_OPEN_READWRITE|SQLITE_OPEN_FULLMUTEX flags and all the > transactions are exclusive. > > > So, if we add a SQLITE_BUSY handle, can we use the sqlite3 .backup > when the

Re: [sqlite] Is it safe to use backup at shell level when an application is running

Great ! Thanks a lot regards, yves yves crespin t. +33.(0)6.86.42.86.81 yvescrespin 2014-11-07 12:21 GMT+01:00 Clemens Ladisch : > Yves Crespin wrote: >> if we add a SQLITE_BUSY handle, can we use the sqlite3 .backup when >> [some] application is running? >> >> Is it safe

Re: [sqlite] Is it safe to use backup at shell level when an application is running

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

[sqlite] Is it safe to use backup at shell level when an application is running

Hi, We use SQLite3 in a multi-threaded application. Now we must provide a 24/7 service and we don't want to change this legacy application. We use sqlite3_open_v2() with SQLITE_OPEN_READWRITE|SQLITE_OPEN_FULLMUTEX flags and all the transactions are exclusive. So, if we add a SQLITE_BUSY