Sqlcipher db compression

[bharath]

I tried to compress sqlite db file (which is encrypted with sqlcipher) but size is remaining same even after gzip compression.

Is there any procedure to compress sqlcipher db file.

[developernotes]

Hi @bharath

You would likely need to compress before you encrypt, there was a previous discussion here covering a bit of this:

Transparent Compression Support

Hi, Is it possible to add transparent compression support to Sqlcipher? You know, after encrypting a database it became uncompressible. One of your developers said this to me: "You could potentially use something like zlib before/after encryption/decryption" Please clarify and explain how I can do this. I have built Sqlcipher from source code, so I am a bit familiar with the code. Thanks for your efforts.