Re: [sqlite] reg:blob data reading

2006-09-19 Thread Dennis Jenkins
Dennis Jenkins wrote: Teg wrote: Hello Dennis, I'm, probably going to be offering optional encryption too. Why did you chose to use the SQLite encryption extensions versus just encrypting the blobs after you read them back in and before you write them out? 1) We wanted the entire database

Re: [sqlite] reg:blob data reading

2006-09-19 Thread Dennis Jenkins
Teg wrote: Hello Dennis, I'm, probably going to be offering optional encryption too. Why did you chose to use the SQLite encryption extensions versus just encrypting the blobs after you read them back in and before you write them out? 1) We wanted the entire database encrypted. There is

Re: [sqlite] reg:blob data reading

2006-09-18 Thread Dennis Jenkins
Jay Sprenkle wrote: On 9/18/06, Teg <[EMAIL PROTECTED]> wrote: Hello Jay, The whole reason I store files in the DB in the first place is to have a single "package" to move around and backup when needed. My application is storing whole series of PNG and JPG files in the DB with meta data describ

Re: [sqlite] reg:blob data reading

2006-09-18 Thread sandhya
hya R - Original Message - From: <[EMAIL PROTECTED]> To: ; "Teg" <[EMAIL PROTECTED]> Sent: Monday, September 18, 2006 7:32 PM Subject: Re: [sqlite] reg:blob data reading > SQLite does not (at this time) have the ability to incrementally > read or write BLOBs. You have

Re: [sqlite] reg:blob data reading

2006-09-18 Thread drh
SQLite does not (at this time) have the ability to incrementally read or write BLOBs. You have to read and write the whole blob all at once. -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL

Re: [sqlite] reg:blob data reading

2006-09-18 Thread Jay Sprenkle
On 9/18/06, sandhya <[EMAIL PROTECTED]> wrote: 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? Store the path to the file in the database ( C:\somefile.dat or /tmp/somefile.dat ). Then open

Re: [sqlite] reg:blob data reading

2006-09-18 Thread sandhya
thinking is wrong? Help me Thank you Sandhya - Original Message - From: "Jay Sprenkle" <[EMAIL PROTECTED]> To: Sent: Monday, September 18, 2006 6:53 PM Subject: Re: [sqlite] reg:blob data reading > On 9/18/06, sandhya <[EMAIL PROTECTED]> wrote: >