Re: [sqlite] sqlite_blob

[sandhya]

I think too, if they are Big-Blobs, it is better to store only a Reference
to a File.
May i know litlle more clearly about this?What it mean actually?

Right now what i am doing is, I have a directory in which somany files are
there and i have loaded all the files into database and the data(ie content
of files as blob).
But my application is reading only 512 bytes at a time..If that is the case
how can i perform / handle this data .
Please suggest me your views.
Thanks a lot
Sandhya R




- Original Message - 
From: <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Monday, September 18, 2006 12:51 PM
Subject: Re: [sqlite] sqlite_blob


> Hello
>
> sandhya wrote:
> > Hi,
> > Is there any way of reading Blob data for the given no.of bytes?
> > I mean is there any lseek kind of  function call in sqlite to handle
> > reading BLOB data.
>
> http://www.sqlite.org/capi3ref.html says:
> "If the result is a BLOB then the sqlite3_column_bytes() routine returns
> the number of bytes in that BLOB."
>
> If you fetch the Blob into RAM, you can do with it with your given number
> of Bytes whatever you want
>
> I think too, if they are Big-Blobs, it is better to store only a
> Reference to a File.
>
> Best Regards
> Thomas
>
> -- 
> www.thlu.de
>
>
> --
---
> To unsubscribe, send email to [EMAIL PROTECTED]
> --
---
>



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] sqlite_blob

[thomas . l]

Hello

sandhya wrote:
> Hi,
> Is there any way of reading Blob data for the given no.of bytes?
> I mean is there any lseek kind of  function call in sqlite to handle
> reading BLOB data.

http://www.sqlite.org/capi3ref.html says:
"If the result is a BLOB then the sqlite3_column_bytes() routine returns
the number of bytes in that BLOB."

If you fetch the Blob into RAM, you can do with it with your given number
of Bytes whatever you want

I think too, if they are Big-Blobs, it is better to store only a
Reference to a File.

Best Regards
Thomas

-- 
www.thlu.de


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] sqlite_blob

[Roger Binns]

sandhya wrote:
>Is there any way of reading Blob data for the given no.of bytes?
>  I mean is there any lseek kind of  function call in sqlite to handle
> reading BLOB data.

This topic is covered fairly frequently - check the group archives.  In
general the advice is that if you have concerns like that then you
should store the data in a file and store the filename in the database.

Roger

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] sqlite_blob

[sandhya]

Hi,
   Is there any way of reading Blob data for the given no.of bytes?
 I mean is there any lseek kind of  function call in sqlite to handle
reading BLOB data.

Thank you all,
Sandhya R



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] sqlite_blob

[sandhya]

Hi,
Is there any way of reading Blob data for the given no.of bytes?
I mean is there any lseek kind of  function call here to handle BLOB data.
Thank you all,
Sandhya R



-
To unsubscribe, send email to [EMAIL PROTECTED]
-