about summary refs log tree commit diff
path: root/TODO.md
diff options
context:
space:
mode:
Diffstat (limited to 'TODO.md')
-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 :)
 =======================================================================