3 ms·
You can use sqlite with zstd compression (which can be extremely efficient with a shared compression dictionary).
by seppel 6y ago
You can use sqlite with zstd compression (which can be extremely efficient with a shared compression dictionary).
- phiresky 6y agoI'm actually working on a sqlite addon right now that allows to transparently compress tables in sqlite using zstd dictionaries and the preliminary results are really promising! One DB I have compresses down from 1GB to 80MB and random SELECTs are faster in the compressed DB when the cache is cold and only somewhat slower when it is hot :) https://github.com/phiresky/sqlite-zstd https://github.com/phiresky/sqlite-zstd