about summary refs log tree commit diff
diff options
context:
space:
mode:
authorgennyble <gen@nyble.dev>2025-08-20 01:23:12 -0500
committergennyble <gen@nyble.dev>2025-08-20 01:23:12 -0500
commit8df63913b741616d0ec945481450bfd143fef814 (patch)
tree7e75b91c10ca59bcfd2f2f8d91baf60929b7ecbe
parent1ad835e878acfe0164e44bb534f45957c4f8b576 (diff)
downloadcorgi-8df63913b741616d0ec945481450bfd143fef814.tar.gz
corgi-8df63913b741616d0ec945481450bfd143fef814.zip
add issue (7) todo
-rw-r--r--TODO.md9
1 files changed, 9 insertions, 0 deletions
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 :)
 =======================================================================