Possible Feature: Compression

[nappy]

Problem with encrypted data: You cannot compress it efficiently.

In my case, I have a 50 MB database which is only like 10 MB zipped. Obviously this is no longer possible if the database is encrypted.

My suggestion is to add an compression layer which can compress the unencrypted chunks and encrypt it afterwards.

[pushpinsapp]

Were you able to figure out a workaround for this? I'm having the same issue.

[developernotes]

Nappy/pushpinsapp,

You could try to running the vacuum command:

http://sqlite.org/lang_vacuum.html

[developernotes]

Hello Nappy/pushpinsapp,,

Were you able to try the vacuum command?

[Behrouz-m]

I have the same problem and vacuum does not help! is it possible to compress database ?

[cnting]

I have the same problem.Anything new?

[developernotes]

Hello @nappy, @cnting,

The compression topic has been discussed on our SQLCipher discuss site here. This is not something that we have planned as a community offering, however you are welcome to reach out to [email protected] to discuss a commercial engagement for your organization's needs. Thanks!