search

ericsink / SQLitePCL.raw

A Portable Class Library (PCL) for low-level (raw) access to SQLite
Apache License 2.0
525 stars 109 forks source link

Missing snapshot API #333

Closed RichardVesely closed 3 years ago

RichardVesely commented 4 years ago

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 commented 4 years ago

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 commented 4 years ago

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 commented 3 years ago

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 commented 3 years ago

Sorry for the delay on this. :-(

RichardVesely commented 3 years ago

Thank you very much for filling this API gap!