Jeff, I'm not sure if I completely understand your intended work flow, but in these cases I'd generally try to work with data like this via a memory-mapped mechanism, especially relevant when you know the size of the data object in question ahead of time, as you apparently do, once a streaming episode is (temporarily) complete. Memory mapped file I/O is available on common platform environments (Linux, MacOS X, and Win32), though is implemented differently on these platforms; but they all expose a view of a collection of (bytes) as a random access 'file' such that buffered I/O calls (fseek(), fread(), fwrite()) or unbuffered calls (write(),read(),etcl) all work. Just an idea anyway.
best, Joe On Tue, Sep 1, 2009 at 7:30 AM, Jeff Godfrey <jeffgodfre...@gmail.com>wrote: > Hi All, > > I have a C# application that uses the System.Data.SQLite assembly for > SQLite access. The ultimate goal is to access the SQLite data as an > in-memory DB. Prior to access though, the database file itself has to > be retrieved from a "container storage mechanism", as it's not stored > independently on disk. Currently, that's being done by streaming the DB > file from the container into a C# byte-array. > > From there, I can write the byte-array to the disk and then take the > necessary steps to open it as an in-memory database, though I'd like to > avoid the "write to disk" step if possible. Ideally, I'd like access > the already-in-memory byte array as the in-memory SQLite db. Is that at > all possible? I assume no, but thought I'd ask. > > Thanks for any input. > > Jeff Godfrey > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- ----------------------------------------------------------------------- Joseph Glassy Lead Software Engineer (contractor) NASA Measures (Freeze/Thaw),Rm CFC 424 College of Forestry and Conservation Univ. Montana, Missoula, MT 59812 Tel: 406-243-6318 Cellular: 406-544-3315 and: Research Analyst/Programmer University of Montana NSF EPSCoR Program Davidson Honors College Room 013 Missoula, MT 59812 um.gla...@gmail.com Campus phone 243-6337 Cell(406) 544-3315 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
