Re: [sqlite] any plans for out-of-row blobs?

2005-09-13 Thread Robert Simpson
- Original Message - From: "Kurt Welgehausen" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Tuesday, September 13, 2005 12:46 PM Subject: Re: [sqlite] any plans for out-of-row blobs? There is no way to retrieve part of a blob value in SQLite. From

Re: [sqlite] any plans for out-of-row blobs?

2005-09-13 Thread Kurt Welgehausen
> There is no way to retrieve part of a > blob value in SQLite. > > From my understanding, most databases store > blob values separate from the rest of the row. The common way to handle this in SQLite is to store the blob in a file and store the file name in the db. Regards

[sqlite] any plans for out-of-row blobs?

2005-09-13 Thread Kervin L. Pierre
I need to retrieve parts of the Blob column value. The blob may simply be to large for memory at runtime. There is no way to retrieve part of a blob value in SQLite. From my understanding, most databases store blob values separate from the rest of the row. Would that be a possibility for