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 the same data that a regular SELECT issued on the same connection would see; it reflects all changes made by any committed transactions. Some of that data may be physically located in the main DB file, and some of it in the WAL file. -- Igor Tandetnik
