SQLite transparent data compression

Question

I am looking for an existing solution for transparently compressing SQLite 3 zlib using a custom VFS implementation and an implementation of custom I / O methods .

Does anyone know of an existing project that is already doing this, or will I have to minimize it myself? I vaguely remember that I saw something like this a year ago, but I can no longer find it.

Answer 1

You can also use a compressed file system through FUSE, such as FuseCompress or compFUSEd , which transparently compresses a sqlite file using zlib, lzo or bzip2.

Edit: There is also a separate solution that you can download as an extension, sqlitecompress .

Answer 2

Compressed and Read-Only Encrypted Database (CEROD) The SQLite extension makes compression available to SQLite authors. This is a commercial addition.