absurd-sql icon indicating copy to clipboard operation
absurd-sql copied to clipboard

Encryption - is this possible?

Open cuuupid opened this issue 2 years ago • 3 comments

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.

cuuupid avatar Sep 21 '21 21:09 cuuupid

@pshah123 Have you managed to set it up?

kukagg avatar Oct 23 '21 17:10 kukagg

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.

michaelpeterlee avatar Nov 01 '21 20:11 michaelpeterlee

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.

imannms avatar Nov 09 '21 06:11 imannms