Transparent SQLite Data Compression
I am looking for an existing solution for transparent SQLite 3 zlib compression using a custom VFS implementation and a custom IO methods implementation.
Is anyone aware of an existing project that already does that, or will I have to r开发者_如何学Pythonoll my own? I vaguely remember seeing something similar a year ago, but can't find it anymore.
The Compressed and Encrypted Read-Only Database (CEROD) SQLite extension does compression, and is available from the authors of SQLite. It is a commercial add-on.
You could also use a compressed filesystem via FUSE, such as FuseCompress or compFUSEd, which transparently compresses the sqlite file using zlib, lzo, or bzip2.
Edit: There is also a separate solution that you can load as an extension, sqlitecompress.
精彩评论