News for hackers. Stuff that matters.
Re:SQLite concurrency and why you should care about it by DANmode on Saturday November 01, 2025 @05:16PM (#45785462)
Perform the file operation, after zipping the existing db as a backup, and leaving the original where it sits.

Success, performance increase.

Failure, no change.

Re:SQLite concurrency and why you should care about it by axitanull on Sunday November 02, 2025 @01:01AM (#45787953)
Forgive my lack of knowledge, but how is simply zipping the original file would "defrag" the file?

Shouldn't the file be moved into different disk fragment first, for that to happen?

Re:SQLite concurrency and why you should care about it by DANmode on Sunday November 02, 2025 @04:07AM (#45788902)
That's "the file operation" :]

Again: zip is a backup