[sqlite] Backup API and WAL

2015-02-23 Thread R.Smith
On 2015-02-23 04:54 AM, Donald Shepherd wrote: > On Mon Feb 23 2015 at 1:41:31 PM Simon Slavin wrote: > >> On 22 Feb 2015, at 11:15pm, Donald Shepherd >> wrote: >> >>> If I use the backup API to create a copy of an SQLite database that uses >>> Write-Ahead Logging, will the resulting copy

[sqlite] Backup API and WAL

2015-02-23 Thread Igor Tandetnik
On 2/22/2015 6:15 PM, Donald Shepherd wrote: > If I use the backup API to create a copy of an SQLite database that uses > Write-Ahead Logging, will the resulting copy reflect the contents of both > the base database file and the -wal file? The data that a particular sqlite3_backup_step sees is

[sqlite] Backup API and WAL

2015-02-23 Thread Donald Shepherd
On Mon Feb 23 2015 at 1:41:31 PM Simon Slavin wrote: > > On 22 Feb 2015, at 11:15pm, Donald Shepherd > wrote: > > > If I use the backup API to create a copy of an SQLite database that uses > > Write-Ahead Logging, will the resulting copy reflect the contents of both > > the base database file

[sqlite] Backup API and WAL

2015-02-23 Thread Simon Slavin
On 22 Feb 2015, at 11:15pm, Donald Shepherd wrote: > If I use the backup API to create a copy of an SQLite database that uses > Write-Ahead Logging, will the resulting copy reflect the contents of both > the base database file and the -wal file? Until a transaction is COMMITted, it's not part

[sqlite] Backup API and WAL

2015-02-22 Thread Donald Shepherd
If I use the backup API to create a copy of an SQLite database that uses Write-Ahead Logging, will the resulting copy reflect the contents of both the base database file and the -wal file? Regards, Donald Shepherd.