[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] BLOB Incremental IO
From:       "Sherief N. Farouk" <sherief () mganin ! com>
Date:       2008-10-31 22:55:51
Message-ID: 000101c93bab$d6dc0680$84941380$ () com
[Download RAW message or body]

> I have a problem with BLOB writing. I need to write
> some binary stream into sqlite table. As I understood, incremental
> BLOB I/O requires space of constant size to be preallocated
> with zeroblob, but I don't know the size of stream in advance.
> And sqlite doesn't allow to change the size of BLOB field.
> The stream can be large, so I don't want to preload all the data
> from it to memory.
> So, is there a way to organize streamed output in my case?

Here's what I do: Split the blob into multiple pieces, stored in a table
with their sequence number as the primary key. For sequential writes, this
shouldn't be any hard. For random I/O, however, I needed to make quite some
changes. What's your usage scenario like?

- Sherief

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[prev in list] [next in list] [prev in thread] [next in thread]