Reputation: 1328
Is there any way for securing data in SQLite; Can we apply encryption or decryption for our sensitive data in SQLite? I want it for my iOS App; It contains some sensitive data. If any one make this type of work then please guide; Your help will give me some direction; Many thanks
Upvotes: 4
Views: 6575
Reputation: 1
If you need to put secure data on iOS, Android, Windows, Mac OS X or Linux check out InterBase from Embarcadero: http://www.embarcadero.com/products/interbase. I think it is the only DB with strong encryption across all those platforms. It uses the same data storage across all of these platforms so one could simply copy the .gdb file between any platform.
Upvotes: 0
Reputation: 18470
Just FYI you cannot secure the client 100%, it is better to put your sensitive data on a server, or you can do more security for the application itself, because if the hacker can physically access you device he will find his way to get the data.
For your question a good thing you can do is encrypting the data with the user's password and save this encrypted data in SQLLite, then save this password in the keychain.
I suggest to read below SO questions:
Encrypting SQLite Database file in iPhone OS
How Should I Secure a SQLite Database in iOS?
Upvotes: 3