Missing snapshot API

[RichardVesely]

I can't seem to find sqlite3_snapshot object or any of the related sqlite3_snapshot_* functions (cmp/free/get/open/recover). SQLITE_BUSY_SNAPSHOT constant is exposed already, but SQLITE_ERROR_SNAPSHOT is missing. There's also no mention in the todo.txt file.

Would it be possible to add these or is there some technical reason for this particular omission? Thank you for your consideration.

[ericsink]

I don't see any technical reason why this couldn't be done.

I'll leave this issue open as a reminder to try and give this feature some attention as soon as I can.

[RichardVesely]

Thank you, this is currently blocking our production usage of SQLite so I appreciate your help. I was actually surprised that no one has asked for this before, because it is impossible to share a consistent view of the database across multiple transactions without this API.

[RichardVesely]

I'm sorry to bother you by bringing this up again, but I'm still hoping it will make the cut someday soon. Thank you for your time.

[ericsink]

Sorry for the delay on this. :-(

[RichardVesely]

Thank you very much for filling this API gap!