Re: [sqlite] append to a column?

2010-11-18 Thread Igor Tandetnik
Yang wrote: > for a row, and one column (most likely blob type), I want to append > some value to the end of the blob, I do this many times. then I may > read up all the appended sections and write out the entire blob with a > new value BLOB API: http://www.sqlite.org/c3ref/blob_open.html --

Re: [sqlite] append to a column?

2010-11-18 Thread Kees Nuyt
On Thu, 18 Nov 2010 01:45:22 -0800, Yang wrote: >I wonder if I can do this efficiently in sqlite: > >for a row, and one column (most likely blob type), I want to append >some value to the end of the blob, I do this many times. then I may >read up all the appended sections and write out the entir

[sqlite] append to a column?

2010-11-18 Thread Yang
I wonder if I can do this efficiently in sqlite: for a row, and one column (most likely blob type), I want to append some value to the end of the blob, I do this many times. then I may read up all the appended sections and write out the entire blob with a new value without any special support,