> I have a problem with BLOB writing. I need to write > some binary stream into sqlite table. As I understood, incremental > BLOB I/O requires space of constant size to be preallocated > with zeroblob, but I don't know the size of stream in advance. > And sqlite doesn't allow to change the size of BLOB field. > The stream can be large, so I don't want to preload all the data > from it to memory. > So, is there a way to organize streamed output in my case?
Here's what I do: Split the blob into multiple pieces, stored in a table with their sequence number as the primary key. For sequential writes, this shouldn't be any hard. For random I/O, however, I needed to make quite some changes. What's your usage scenario like? - Sherief _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users