Can anyone tell me if SQLite's incremental blob reading API is supported by System.Data.SQLite?
http://www.sqlite.org/capi3ref.html#sqlite3_blob_open
I've found it mentioned here back in 2007...
http://sqlite.phxsoftware.com/forums/p/780/3438.aspx#3438
And this thread mentions it, but doesn't say whether it's supported or not....
http://sqlite.phxsoftware.com/forums/t/1692.aspx
What I'm after is the ability to read a portion of a blob via random access.
Thanks!
Looks like SQLiteDataReader.GetBytes is what I'm after.
At least, I assume using GetBytes to read 100k of a 50mb blob will NOT load the full 50mb off disk first.
Can anyone confirm this?