On Fri, Mar 3, 2017 at 3:58 PM, Yuri <y...@rawbw.com> wrote: > On 03/01/2017 23:41, Clemens Ladisch wrote: > > It would certainly be possible to add your own user-defined SQL function >> to call sqlite3_blob_write(). >> > > > I think this should be added to sqlite itself. Writing a portion of blob > is very much like updating a field. There is currently no way to do this in > SQL fashion in an efficient way. So such command can be chained with other > SQL statements and make the client code much simpler. > > All blobs I've used in SQL are themselves atomic and partial updates would never be useful. (images, fingerprints, etc.) If you're updating parts of blobs then probably you mean that blob to be in multiple parts or broken into separate fields.
> Yuri > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users