Hey everyone,
I am working on a project where I need to secure my app’s data using SQLCipher. I have gone through the documentation & some community threads but I am still struggling with a few parts. My main confusion is about how to properly set up the key management when creating or opening the encrypted database. I am not sure whether the password needs to be stored somewhere in the code; or if there is a recommended approach to keep it safe.
I want to know about potential performance trade-offs. Since SQLCipher uses encryption, I want to know if there are best practices to avoid slowdown in queries for apps that require frequent database reads & writes.
Has anyone here worked with SQLCipher in a real-world app & can share tips or common mistakes to avoid? I am even comparing it to how I studied about a Workday Course where security of data was also a major concern.
Thank you…