5 ms·

Yeah but your app doesn't have control over the filesystem. Usually an sqlite db is bundled with an application or created by it. That said, it looks like you

Yeah but your app doesn't have control over the filesystem. Usually an sqlite db is bundled with an application or created by it. That said, it looks like you could get the same results by doing client side compression and decompression of data yourself, and storing compressed blobs in sqlite. It only compresses text column data, not entire pages.

Gehinnn 4y ago
But it uses a shared zstd dictionary among rows! The details are described here: https://phiresky.github.io/blog/2022/sqlite-zstd/ https://phiresky.github.io/blog/2022/sqlite-zstd/
d1l 4y ago
https://www.sqlite.org/vfs.html https://www.sqlite.org/vfs.html