This content has been marked as final. Show 5 replies
No, replacing the built-in copy of SQLite is not possible.
You can directly store encrypted data using the Encrypted Local Store feature. You can also encrypted the data first and then store it in the database.
Oliver Goldman | Adobe AIR Engineering
Slightly off-topic... is it possible to load sqlite extensions?
Thanks for the information. I actually have more data to store than 10MB which is the limit for Encrypted Local Store because I looked into that first. I wanted a solution that didn't require me to write an encryption/decryption each time I wrote to the database, but it seems like that is what is needed. So, I'll probably go down that route...
I had read where someone mentioned encrypting the SQLite file when the AIR app is not in use and just decrypting the entire database during usage (via the Encrypted Local Store). Does anyone have any thoughts on this method? I would assume that this means the database would need to stay before 10MB. What about performance considerations? Is there some other way to secure the SQLite database?
SQLite uses temporary files that may contain database fields, so using the ELS to store the database when the application isn't running may still leave some information unencrypted on disk. As far as performance is concerned, it would depend on how often you wrote the database back to the ELS.