-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 ??????? ???????? wrote: > As I understood, incremental > BLOB I/O requires space of constant size to be preallocated > with zeroblob,
That is correct. > but I don't know the size of stream in advance. Then you can't use the incremental I/O for writing. (Although you could hack by allocating far too large a zero blob and then once finished writing to it, copy the portion of it to another row and delete the original.) > So, is there a way to organize streamed output in my case? Write it to a randomly generated file name and then store the file name in the database. Once the file is whole you can copy it into the database if you want. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkkKylcACgkQmOOfHg372QTUKwCfeMcZKmO8JYpKRh59wM6w44O9 9U4AoI5uhsOOBAbxWRpJGVzxp9WgdHXd =fBcJ -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users