Yuri wrote: > I have to call sqlite3_blob_write to partially modify blobs. > > Wouldn't it have been better if there was a function, for example, > writeblob(tbl.blob_fld, offset, portion_data)? SQLite could do the > same that sqlite3_blob_write is doing when writeblob result is > assigned to the same row/column that is supplied as the argument, and > rewrite the whole blob otherwise?
The sqlite3_blob* interface is just an optimization, and it looks as if it was included for some specific application. It would certainly be possible to add your own user-defined SQL function to call sqlite3_blob_write(). > Also, do sqlite3_blob_write calls participate in transactions? Of course they do. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users