Re: [sqlite] Query on database back-up:

Thanks.All cases clear except below What happen if other process is not able to complete operation within timeout duration? Cheers - Techi On Fri, Aug 2, 2013 at 2:28 PM, Clemens Ladisch wrote: > > techi eth wrote: > >> 1. "Any database clients wishing to write to the

Re: [sqlite] Query on database back-up:

> techi eth wrote: >> 1. "Any database clients wishing to write to the database file while a >> backup is being created must wait until the shared lock is >> relinquished." > > Example 1: Loading and Saving In-Memory Databases will not fulfill > this shortcoming. In-memory databases cannot be

Re: [sqlite] Query on database back-up:

Appreciate if I will get clarification. If any of the point out of the scope of mailing list then please mark. Thanks a lot!!! On Wed, Jul 31, 2013 at 6:53 PM, techi eth wrote: > Thanks for answer. > > Let me put my query on point mentioned by comparing historic way of >

Re: [sqlite] Query on database back-up:

On 07/31/2013 07:33 PM, Simon Slavin wrote: On 31 Jul 2013, at 12:56pm, techi eth wrote: I have followed below link for details. It say “If another thread or process writes to the source database while this function is sleeping, then SQLite detects this and usually

Re: [sqlite] Query on database back-up:

Thanks for answer. Let me put my query on point mentioned by comparing historic way of doing copy at the start of link. 1. "Any database clients wishing to write to the database file while a backup is being created must wait until the shared lock is relinquished." Example 1: Loading and Saving

Re: [sqlite] Query on database back-up:

On 31 Jul 2013, at 12:56pm, techi eth wrote: > I have followed below link for details. It say “If another thread or > process writes to the source database while this function is sleeping, then > SQLite detects this and usually restarts the backup process when >

[sqlite] Query on database back-up:

Hi, Case: “I copied first five pages from database using online backup api & during sleep time other process write to database which is actually part of first copied five pages, In that case at the end of backup can I assure I will have my database backed up with latest changes. (Changes done