Re: [sqlite] Data encryption

2007-11-20 Thread Günter Greschenz
hi everybody, the magic spell worked, but onky for me, not for my server: at the moment i have problems with my (free) dyndns account. my server (a little nslu2 in my living room) was online for some hours yesterday but disappeared again this morning ... until i solved my problem here are the te

Re: [sqlite] Data encryption

2007-11-19 Thread Günter Greschenz
sorry, i have been on a business trip until this weekend (i have been some months in korea...), and my server (at home) was turned off by my wife :-) i will reenable it this evening... here is the source again (attached to this mail) cu, gg A.J.Millan wrote: Andreas: Some time ago, in respons

RE: [sqlite] Data encryption

2007-11-13 Thread Wilson, Ron
: A.J.Millan [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 13, 2007 2:58 AM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Data encryption Andreas: Some time ago, in response to a similar question, Günter Greschenz sent to this forum a email: >hi, >i've written some sqlite-functio

RE: [sqlite] Data encryption

2007-11-12 Thread A.J.Millan
Andreas: Some time ago, in response to a similar question, Günter Greschenz sent to this forum a email: hi, i've written some sqlite-functions to crypt (blowfish) or compress (bzip) data in sqlite: e.g. insert into blubs values (crypt('data','pwd')) or select from xyz where decompre

Re: [sqlite] Data encryption

2007-11-12 Thread Trevor Talbot
On 11/12/07, Andreas Volz <[EMAIL PROTECTED]> wrote: > I think about to encrypt the data in my DB. Does sqlite offer a data > encryption on a lower level? Or should I encrypt my data before putting > it into the table on a higher level in my application without involving > sqlite? Dr. Hipp sells

[sqlite] Data encryption

2007-11-12 Thread Andreas Volz
Hello, I think about to encrypt the data in my DB. Does sqlite offer a data encryption on a lower level? Or should I encrypt my data before putting it into the table on a higher level in my application without involving sqlite? regards Andreas

[sqlite] Re: [inbox] Re: [sqlite] Data encryption

2004-01-31 Thread Michael Hunley
At 11:36 AM 1/31/2004 -0600, Kurt Welgehausen wrote: You'll have to encrypt each column independently. If you use the same key and initialization vector, you should be able to search, but of course, only for exact matches. Also, the size of each field will probably grow to the next multiple of yo

Re: [sqlite] Data encryption

2004-01-31 Thread Kurt Welgehausen
You'll have to encrypt each column independently. If you use the same key and initialization vector, you should be able to search, but of course, only for exact matches. Also, the size of each field will probably grow to the next multiple of your cipher's block size, so you'll need to pad the dat

Re: [sqlite] Data encryption

2004-01-31 Thread Richard Heyes
> Has anyone ever needed to encrypt sqlite data on a record by record > basis? I'm a little stumped about this issue mainly because any search > using a reasonably securely encrypted record (such as with AES) would be > futile because it's encrypted differently even with the same passwords > being

[sqlite] Data encryption

2004-01-31 Thread Balthasar Indermuehle
Hi all, Has anyone ever needed to encrypt sqlite data on a record by record basis? I'm a little stumped about this issue mainly because any search using a reasonably securely encrypted record (such as with AES) would be futile because it's encrypted differently even with the same passwords being u