Hi!
Is there any support for encryption in sqlite and ios?
thx!
Depends on what you mean by support, do you mean encrypting the entire database with a password or column/row level encryption?
Off the top of my head I don’t think corona supports encrypted sqlite databases (although sqlite itself does support it).
That being said, I use row/column level encryption using openssl on sensitive fields and decrypt after i read the row etc. and encrypt on any updates/inserts.
Technically you code use this same method to encrypt the entire database “file” and just decrypt before opening it up etc.
Thank you very much for your answer Christopher,
i was looking for something like http://sqlcipher.net/ with full sqlite encryption but maybe i need to use another approach…
You could implement sqicipher but you would need the enterprise license.
Depends on what you mean by support, do you mean encrypting the entire database with a password or column/row level encryption?
Off the top of my head I don’t think corona supports encrypted sqlite databases (although sqlite itself does support it).
That being said, I use row/column level encryption using openssl on sensitive fields and decrypt after i read the row etc. and encrypt on any updates/inserts.
Technically you code use this same method to encrypt the entire database “file” and just decrypt before opening it up etc.
Thank you very much for your answer Christopher,
i was looking for something like http://sqlcipher.net/ with full sqlite encryption but maybe i need to use another approach…
You could implement sqicipher but you would need the enterprise license.