Re: [sqlite] Encrypting data stored in database

2004-09-10 Thread Joey Blankenship
No argument here. We're targeting x86 and xScale architectures so we're able to reference DWORD objects on non-DWORD boundaries. I never really meant to distribute this code so we only tried to get it working for our purposes. I just hope someone can get some use from it. Joey. At 04:11 PM

RE: [sqlite] Encrypting data stored in database

2004-09-10 Thread Joey Blankenship
PROTECTED] Subject: RE: [sqlite] Encrypting data stored in database I'm including the routines that we modified. I hate to send the whole file around the entire list. The ppdbuffer and ppdbuffersize are set initially when the database is opened and closed. The current implementation may not be threadsafe

Re: [sqlite] Encrypting data stored in database

2004-09-10 Thread Derrell . Lipman
Joey Blankenship <[EMAIL PROTECTED]> writes: > if( !ReadFile(id->h, pBuf, amt, , 0) ){ > got = 0; > } > > // PPD - XOR the buffer with a pattern so the disk file contents are not > in plain text > for (i = 0; i < got/4; i++) > { > *((DWORD *)((DWORD *)pBuf + i)) = (*((DWORD

RE: [sqlite] Encrypting data stored in database

2004-09-10 Thread Bob Dankert
, but I'm stuck in a C#.Net world and don't have to deal with this stuff. Thanks! Bob -Original Message- From: Joey Blankenship [mailto:[EMAIL PROTECTED] Sent: Friday, September 10, 2004 2:48 PM To: [EMAIL PROTECTED] Subject: RE: [sqlite] Encrypting data stored in database I'm including

RE: [sqlite] Encrypting data stored in database

2004-09-10 Thread Joey Blankenship
I'm including the routines that we modified. I hate to send the whole file around the entire list. The ppdbuffer and ppdbuffersize are set initially when the database is opened and closed. The current implementation may not be threadsafe, but we are single threaded. extern int

RE: [sqlite] Encrypting data stored in database

2004-09-10 Thread Bob Dankert
, 2004 8:00 AM To: [EMAIL PROTECTED] Subject: Re: [sqlite] Encrypting data stored in database We made the mods in os_win.c, in the read and write routines, after the read and before the write. A more robust solution would have been to modify the code in os_mac.c and os_unix.c as well, but we

Re: [sqlite] Encrypting data stored in database

2004-09-10 Thread Raymond Irving
Man this sounds great! I would really like to know where exactly I can make the changes to encrypt the database. I would even add a passkey feature (or xor string) that would be used to offer minor database obfuscation. Why don't the development group add something like this to the source? Is it

RE: [sqlite] Encrypting data stored in database

2004-09-10 Thread Joey Blankenship
EzTools Support [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 09, 2004 5:12 PM > To: [EMAIL PROTECTED] > Subject: Re: [sqlite] Encrypting data stored in database > > Joey, > > Where in the code did you do that? Was it easy to put in one or two > places? > > -br

Re: [sqlite] Encrypting data stored in database

2004-09-10 Thread Joey Blankenship
We made the mods in os_win.c, in the read and write routines, after the read and before the write. A more robust solution would have been to modify the code in os_mac.c and os_unix.c as well, but we didn't need that. It was very easy and the only caveat is that once you modify it, it will no

RE: [sqlite] Encrypting data stored in database

2004-09-10 Thread Hihn, Jason
encryption. > -Original Message- > From: EzTools Support [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 09, 2004 5:12 PM > To: [EMAIL PROTECTED] > Subject: Re: [sqlite] Encrypting data stored in database > > Joey, > > Where in the code did you do that? Was i

Re: [sqlite] Encrypting data stored in database

2004-09-10 Thread EzTools Support
Joey, Where in the code did you do that? Was it easy to put in one or two places? -brett try IeToolbox Passwords & Notes Keeper, Form Filler and much more www.ietoolbox.com Joey Blankenship wrote: Not to respond out of turn here, but we had a need to obfuscate the plain text (due to some users

Re: [sqlite] Encrypting data stored in database

2004-09-09 Thread Joey Blankenship
Not to respond out of turn here, but we had a need to obfuscate the plain text (due to some users that are a little too curious for their own good) that was stored but did not want the performance burden that encryption/decryption would place on the PocketPC. Prior to writing and subsequent

Re: [sqlite] Encrypting data stored in database

2004-09-09 Thread D. Richard Hipp
George Ionescu wrote: > > I would like to know if there is a way to encrpyt the data stored in the > database but to still be able to use SQL queries with plain text, something > like > > CREATE TABLE TEST (fld) > INSERT INTO Test VALUES ('some string')] > SELECT * FROM Test WHERE fld = 'some