logoalt Hacker News

andriy_kovaltoday at 3:29 PM2 repliesview on HN

I think there is no vanilla compression in SQLite.


Replies

Arcurutoday at 5:38 PM

But there's probably not encryption either, so the sqlite database file probably has a lot of duplicated data inside it that's visible externally. I'm also curious how well it compresses by just running the sqlite file through a compression tool. I don't know enough about sqlite storage internals to guess.

woadwarrior01today at 3:58 PM

There's a commercial extension that can do this.

https://sqlite.org/com/cerod.html