Yuri 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.
So far, nobody except you has requested it. > 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. Neither is there a way to update a text field efficiently; for both types, you have to handle the pieces manually: UPDATE MyTable SET Field = substr(Field, 1, 10) || 'xxx' || substr(Field, 14); And handling blob values does not make much sense in a pure SQL script; binary data is usually handled in the application from which the SQLite library is accessed. > So such command can be chained with other SQL statements and make the > client code much simpler. Do you have a concrete example for such a statement? Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
