SQLiteBrowserUtility icon indicating copy to clipboard operation
SQLiteBrowserUtility copied to clipboard

Can you add sqlite compression feature?

Open watersoft123 opened this issue 2 years ago • 1 comments

Surprisingly, few people pay attention to such a good project. I am working on an offline web storage project, and your project has been very helpful to me. I have an idea. Can you add a dictionary level compression feature for sqlite? I learned from the following project that using the zstd method can significantly compress sqlite:

sqlite-zstd sqlite_zstd_vfs

watersoft123 avatar Apr 22 '24 03:04 watersoft123

Surprisingly, few people pay attention to such a good project. I am working on an offline web storage project, and your project has been very helpful to me. I have an idea. Can you add a dictionary level compression feature for sqlite? I learned from the following project that using the zstd method can significantly compress sqlite:

sqlite-zstd sqlite_zstd_vfs

Hey there! Apologies for an extremely overdue response and thanks for compliment (: Have tried playing with zstd on its own and yes, the compression factor is stellar, but it can only be run on server-side sadly. The use-case for this pet project was for offline (server-free) standalone use. Can't guarantee I will implement this specific feature. Next release probably will include 'import CSV file' functionality (present on my personal laptop only). Thanks for the suggestion 😆

incubated-geek-cc avatar Jul 25 '25 11:07 incubated-geek-cc