infrastructure

commit dd682537d41d723a75ba64cb4dca864b5f68f877
parent c7d26917bf5b5f92ef4c9f7ac46aca2c57aeafa2
Author: Silas Brack <silasbrack@gmail.com>
Date:   Sat,  4 Jul 2026 20:37:55 +0200

feat: add manifest.csv for DuckDB httpfs log queries

The log archival script now generates a manifest.csv listing all
log files. DuckDB can read this over HTTP to query logs without
downloading them first.

Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>

Diffstat:
M
modules/simple-web-app.nix
 | 
5
+++++

1 file changed, 5 insertions(+), 0 deletions(-)
diff --git a/modules/simple-web-app.nix b/modules/simple-web-app.nix
@@ -88,6 +88,11 @@ in
           -o json | \
           ${pkgs.gzip}/bin/gzip \
           > $LOG_STORAGE_LOCATION/$(date -d "$PREVIOUS_HOUR" +%Y/%m/%d/%H).json.gz
+
+        # Rebuild manifest for DuckDB httpfs queries
+        ${pkgs.findutils}/bin/find $LOG_STORAGE_LOCATION -name '*.json.gz' -printf '%P\n' \
+          | ${pkgs.coreutils}/bin/sort \
+          > $LOG_STORAGE_LOCATION/manifest.csv
       '';
       environment = {
         SERVICE_NAME = "simple-web-app";