As a testimony to the value of SQLite, previous versions of our software used ADO on the desktop and ADOCE on the PocketPC. The ADO database was stored in an Access format and we had users that would use Access to directly browse or modify the database. That wasn't good. In addition, copying to the device required a DesktopToDevice call which then converted the desktop Access database to a Pocket Access format. It took several minutes depending on the number of records. With SQLite the database is smaller (saving over 2MB on the device), faster (nearly twice as fast), and we can directly copy the file to the device in 15 or 20 seconds as opposed to 5 minutes. SQLite is simply an awesome product.
Joey.
At 08:46 AM 9/10/2004, you wrote:
In theory, ( have not tried this with SQLite) you caould make 2 add-in functions, encrypt(str) and decript(str) then use it as such:
Select decrypt(sensitive_column) from table where id=3; Insert into table (sensitive_column) values (encrypt('3434 3434 3434 3434'))
To provide field-level 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 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 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 to reading, we just perform a simple mangle of the > > read/written data. A byte NOT or XOR works pretty well and does not > > cause an extreme performance hit. Again, no real encryption, but it > > hides the data from casual viewing. > > > > Joey. > > > > At 05:34 AM 9/9/2004, you wrote: > > > >> Hello sqlite users, > >> Hello Dr. Hipp, > >> > >> 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 string' > >> > >> but, when the sqlite database is opened in a file viewer, 'some > >> string' would not be visible but only it's encrypted form. > >> > >> Regards, > >> George Ionescu > > > > > > >
__________________________________________________________________________________________
This electronic message may contain proprietary and confidential information of Verint Systems Inc., its affiliates and/or subsidiaries.
The information is intended to be for the use of the individual(s) or
entity(ies) named above. If you are not the intended recipient (or authorized to receive this e-mail for the intended recipient), you may not use, copy, disclose or distribute to anyone this message or any information contained in this message. If you have received this electronic message in error, please notify us by replying to this e-mail. (1)
