absurd-sql
absurd-sql copied to clipboard
Encryption - is this possible?
Normal SQLite has extensions/Pager support for adding encryption to the entire DB file i.e. AES ciphers. I was wondering if this project had similar capabilities.
Looking at how the DB is read/parsed, this may be as easy as encrypting/decryption on read/write of chunks.
@pshah123 Have you managed to set it up?
I recommend applying encryption at the application-level, storing data as blob/string and exposing indexes, as required. Encryption at lower-levels of the stack are a bonus and whilst they add layers around the onion, your application won't be dependent on them.
Someone has done this https://github.com/wireapp/websql He uses sql.js with encryption enabled.
I've tried this and it worked.
It would be nice if this was also implemented in absurd-sql.