Re: [sqlite] how to process password

2012-07-29 Thread Robert Myers
Encryption is very hard to do right, so in general, let someone else do it. We use SEE (http://www.hwaci.com/sw/sqlite/see.html) with the key generated from a password by PBKDF2 and a high number of iterations. Previously, columns were encrypted with OS functions that made it impossible to move th

[sqlite] how to process password

2012-07-29 Thread yanhong.ye
I need insert any my bank-card information to sqlite db, so when I insert the car number like '3312' and car password like '7711', but I wanna nobody can see the password, so I create a function encode('7711','key') and decode(select from stable where carnum=3312, 'key') to see the password, the