System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: e38eb0faa83c9206dbc8abe970958e91a33af546
Title: Open DB from given IStream (or something more clever?)
Status: Deferred Type: Feature_Request
Severity: Important Priority: Medium
Subsystem: Connection Resolution: Under_Review
Last Modified: 2017-08-11 21:02:11
Version Found In:
User Comments:
anonymous added on 2017-08-11 17:55:25:
I am trying to build a Windows Shell ThumbnailHandler. I have a sqlite3 file in which I store a thumbnail in a particular table.

https://msdn.microsoft.com/en-us/library/windows/desktop/bb774614(v=vs.85).aspx

For security reasons Windows only provides a stream to the file, not the file name and path. I am currently copying the stream to a temporary file, then opening that file with sqlite. This is an unsustainable solution, however, as these files will be accessed over the network and can be up to gigabytes in size.

As I unable to open the file directly, I need to be able to open a connection using the provided stream or come up with something more clever (and dangerous...). A brief look at the file format doesn't indicate that there is any provision for user data in the file as (presumably) the response to such a request would be "just store it in the database, crazy".

Do the oracles at system.data.sqlite.org have any suggestions?

mistachkin added on 2017-08-11 21:02:03:
There is currently no way to open a SQLite database from a managed stream.

mistachkin added on 2017-08-11 21:02:11:
Duplicate of [0fced13729ff1c68cf5e].