News for hackers. Stuff that matters.

A comment on Using SQLite as storage for web server static content. Parent comment

Re:Using SQLite as storage for web server static content by hedgehog on Sunday October 27, 2024 @07:34PM (#41966553)
What do you do about compaction?
[ Parent | on HN ]
Re:Using SQLite as storage for web server static content by webstrand on Monday October 28, 2024 @09:50AM (#41970988)
zstd, though that only shaves off a few GB total.
[ Parent | on HN ]
Re:Using SQLite as storage for web server static content by hedgehog on Monday October 28, 2024 @07:28PM (#41977687)
Oh, I mean like with the vacuum command. As the databases get larger it can become unwieldy.
[ Parent | on HN ]
Re:Using SQLite as storage for web server static content by webstrand on Tuesday October 29, 2024 @01:02PM (#41986619)
I just tried it, it only recovered a few MB
[ Parent | on HN ]
Re:Using SQLite as storage for web server static content by hedgehog on Tuesday October 29, 2024 @02:32PM (#41987864)
Aha, so not much need. I've always avoided SQLite for larger databases due to the extra space needed to allow compaction, maybe not a real problem in most applications though.
[ Parent | on HN ]