From 8df63913b741616d0ec945481450bfd143fef814 Mon Sep 17 00:00:00 2001 From: gennyble Date: Wed, 20 Aug 2025 01:23:12 -0500 Subject: add issue (7) todo --- TODO.md | 9 +++++++++ 1 file changed, 9 insertions(+) diff --git a/TODO.md b/TODO.md index 47f455e..198fddf 100644 --- a/TODO.md +++ b/TODO.md @@ -19,6 +19,15 @@ been bad! Being able to see what corgi-stats was returning would've been very helpful. +(7) Investigate Compressing the SQLite Stats DB + Looking at the below project. It's in Rust and easily integrated, + I think, so we should use it to explore how things work. I think it + could be good; I imagine the data we store compresses great. The IP + addresses, user agents, paths, script names. Like, in the 11 million + row production database we store the script name of almost certainly + mostly "cgit", so that could get dramatically reduced. + https://github.com/phiresky/sqlite-zstd + DONE :) DONE :) DONE :) DONE :) DONE :) DONE :) DONE :) DONE :) DONE :) ======================================================================= -- cgit 1.4.1-3-g733a5