On 20-Apr-06, at 9:10 AM, Jay Sprenkle wrote:
Just out of curiosity why is this data in the database?
I've seen very few applications where the blob is indexed or
operated upon
by the database and it's always a pain to deal with it. We always just
left binary data in the file system and
On 4/20/06, Dennis Jenkins <[EMAIL PROTECTED]> wrote:
> Jay Sprenkle wrote:
> > Just out of curiosity why is this data in the database?
> > I've seen very few applications where the blob is indexed or operated upon
> > by the database and it's always a pain to deal with it. We always just
> > left
Jay Sprenkle wrote:
> Just out of curiosity why is this data in the database?
> I've seen very few applications where the blob is indexed or operated upon
> by the database and it's always a pain to deal with it. We always just
> left binary data in the file system and stored references to it in
> >
> > sqlite3BtreeData() actually reads a prefix of the data.
> > Because of the way large blobs are stored (as a linked list
> > of disk pages) you have to start reading at the beginning
> > and read everything up to the point of interest.
>
> Random access for blobs would be ideal, but even a
On Wed, 19 Apr 2006, Joe Wilson wrote:
>--- [EMAIL PROTECTED] wrote:
>> Joe Wilson <[EMAIL PROTECTED]> wrote:
>> >
>> > If you read the blob all in at once, true.
>> > But doesn't sqlite3BtreeData() allows you to read a partial chunk of
>> > data from the blob at an arbitrary offset? This could
Am 19.04.2006 um 15:31 schrieb [EMAIL PROTECTED]:
Felix Schwarz <[EMAIL PROTECTED]> wrote:
Hi,
I have just discovered these old message on the SQLite Yahoo! Group:
http://groups.yahoo.com/group/sqlite/message/2115
http://groups.yahoo.com/group/sqlite/message/2117
This does sound very
--- [EMAIL PROTECTED] wrote:
> Joe Wilson <[EMAIL PROTECTED]> wrote:
> >
> > If you read the blob all in at once, true.
> > But doesn't sqlite3BtreeData() allows you to read a partial chunk of
> > data from the blob at an arbitrary offset? This could be advantageous
> > if you are dealing with
[EMAIL PROTECTED] wrote:
> Maybe I'm missing something here, but there should be an interface to page a
> blob into memory. Especially for large blobs, this would make sense to me to
> not load them into memory at once.
>
> If sqlite doesn't provide this already, it would probably make a lot of
Maybe I'm missing something here, but there should be an interface to page a
blob into memory. Especially for large blobs, this would make sense to me to
not load them into memory at once.
If sqlite doesn't provide this already, it would probably make a lot of sense
to include this
Joe Wilson <[EMAIL PROTECTED]> wrote:
>
> If you read the blob all in at once, true.
> But doesn't sqlite3BtreeData() allows you to read a partial chunk of
> data from the blob at an arbitrary offset? This could be advantageous
> if you are dealing with multi-megabyte blobs and do not
--- [EMAIL PROTECTED] wrote:
> Felix Schwarz <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > I have just discovered these old message on the SQLite Yahoo! Group:
> >
> > http://groups.yahoo.com/group/sqlite/message/2115
> > http://groups.yahoo.com/group/sqlite/message/2117
> >
> > This does sound
Felix Schwarz <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have just discovered these old message on the SQLite Yahoo! Group:
>
> http://groups.yahoo.com/group/sqlite/message/2115
> http://groups.yahoo.com/group/sqlite/message/2117
>
> This does sound very interesting! If I simply want to store
Hi,
I have just discovered these old message on the SQLite Yahoo! Group:
http://groups.yahoo.com/group/sqlite/message/2115
http://groups.yahoo.com/group/sqlite/message/2117
This does sound very interesting! If I simply want to store binary
data that I want to access via an index number again
13 matches
Mail list logo