April 3, 2026

Schema, Workers, and Build Log Overhaul

Refactored the digest worker by extracting singletons and post-exchange hooks into dedicated modules, and consolidating cron/drift pipelines into a helper funct

Refactored the digest worker by extracting singletons and post-exchange hooks into dedicated modules, and consolidating cron/drift pipelines into a helper function.

Updated the chat history retrieval to read exclusively from SQLite using SQL-level pagination via get_paginated_history_durable(), replacing the unreliable in-memory MemoryStore.

Promoted several silent debug catches to error level to ensure failures are visible during operation.

Refined the database schema by making Migration 009 a no-op and adding four composite indexes on hot query paths.

Replaced the build log logic, moving the full pipeline to n8n, making GitHub Actions a simple trigger that POSTs to an n8n webhook.

Switched the build-log webhook to asynchronous mode to prevent Cloudflare timeouts when processing long-running Ollama calls.

Updated webhook authentication to use opaque URL tokens for greater reliability through proxies, deprecating the need for X-Webhook-Secret headers for some flows, though others remain required.

Improved build log state tracking by switching from a potentially unreliable commit-count comparison to a hash-based state file stored in the web directory.

  • Read chat history directly from SQLite instead of MemoryStore.

  • Extracted digest worker singletons and hooks for modularity.

  • Migrated build log processing pipeline to n8n/Ollama.

  • Switched build-log state detection to use hash-based state files.

  • Added four composite indexes on hot query paths.

  • Staggered webhook fires with a 5s delay to prevent Ollama overload.