Senior engineer croovies demonstrates a working loop orchestrator (Lloyd) that manages 1,200+ tickets in a self-managed SQLite table with compounding tribal knowledge, claiming this pattern is replicable for long-running agent autonomy.
state: seedheat: lowuncertainty: mediumconvergesscott: highagent-orchestration persistent-memory loop-orchestratorscroovies
What is this?
A Reddit user u/croovies (self-described 20+ year senior engineer/designer) posted a working loop orchestrator called "Lloyd" on r/ClaudeAI that manages 1,200+ tickets in a self-managed SQLite table, framing the ticket table as "a database of tribal knowledge that can be passed to any model" β a concrete from-the-wild demonstration of the loop engineering pattern that explainx.ai's guides describe as a target to build toward. The explainx.ai teardown notes SQLite beats markdown scratch files at scale (which fail well before 600 items) and highlights the compounding tribal knowledge claim as the useful framing. The Reddit post had ~431 upvotes as of August 14, 2026. The engineer's identity and credentials are self-reported on Reddit; no independent verification found in the supplied snippets.
Why it matters to Scott
A from-the-wild, working loop orchestrator (1,200+ tickets over months in SQLite) that independently implements the exact long-running agent architecture Scott's frameworks prescribe: stateless workers + durable external kernel (the ticket table), compounding tribal knowledge as the kernel flywheel, checkpoint/handover discipline as the operational contract, and a deterministic control plane outside the model. This is not a toy or a design sketch β it is a dated receipt validating the loop-engineering posture, the SQLite-over-markdown substrate choice at scale, and the earned-autonomy progression. Publishing opportunity: a concrete case study Scott can cite against the 'agents need bigger context' narrative.
ip:framework.long-running-agentsip:framework.agent-loopip:framework.five-surface-loop-anatomyip:source.designing-loops-not-prompts-ebookip:concept.durable-external-stateip:concept.kernelip:concept.kernel-flywheelip:concept.compounding-learningip:concept.checkpoint-disciplineip:concept.handover-note-disciplineip:dev:concept.resumable-agent-job-control-planeip:dev:concept.deterministic-agent-control-planeip:framework.markdown-osip:framework.rag-wiki-substrate-ruleip:concept.earned-autonomyip:framework.three-ingredients-frameworkip:dev:project.synthetic-futuresip:dev:project.all-in-one-softwareradar:devcake-ticket-driven-software-factoryradar:ticket-thread-coding-agentsradar:pullboard-agentic-institutional-knowledgeradar:memtether-symlink-shared-agent-memoryradar:groundtrack-team-agent-memoryradar:repo-memory-vault-practiceradar:longhorizon-harness-validationradar:supervice-agent-process-supervisorradar:keel-modular-agent-conductorradar:headlong-persistent-agent-microharnessradar:gantree-chat-independent-long-horizon-harnessradar:operator-parallel-coding-agent-orchestrationradar:rig-shared-state-agent-runtime
queries asked of Scott's wikis
- loop orchestrator persistent memory SQLite
- compounding tribal knowledge cross-session memory injection
- long-running agent autonomy verification patterns
- loop engineering discipline agent orchestration frameworks
- self-managed ticket systems agent state management
- SQLite vs markdown agent memory substrate
Measured heat
now 0 pts/hpeak 19 pts/hcomments 0/hpeers p33momentum: steady2 platformsage 1442h
points/hour across evidence Β· reading as of 2026-10-12 02:59:37.977291+11:00 Β· deterministic, not a model opinion
How the heat travelled
Evidence (2) β β canonical anchor
Interpretation history
2026-10-10T04:59:19Z
origin walked (opencode/cheap-glm, conf 0.85): anchor reddit.post.1x25sbw -> echo.reddit.24c240d010 by croovies (u/croovies)
2026-10-10T04:52:22Z
grounded: converges/high β A from-the-wild, working loop orchestrator (1,200+ tickets over months in SQLite) that independently implements the exact long-running agent architecture Scott'
2026-10-10T04:40:36Z
case created β Single Reddit post by a senior engineer showing a concrete, working loop orchestrator artifact with 1,200+ managed tickets in SQLite β a plausible first demonstration of the pattern.
Decision trace
- 10-11 05:37sensor_dirtycomment_update
- 10-10 23:30sensor_dirtycomment_update
- 10-10 20:31sensor_dirtyvelocity_spike
- 10-10 17:31sensor_dirtycomment_update
- 10-10 17:04attention_communicatedA 20-year senior engineer (croovies) shared a working loop orchestrator called Lloyd that manages 1,200+ tickets in a self-managed SQLite table with compounding tribal knowledge. The system implements
- 10-10 17:04attention_routeDirectly validates multiple load-bearing frameworks (long-running agents, durable external state, kernel flywheel, earned autonomy, SQLite-over-markdown substrate) with a from-the-wild working example
- 10-10 16:00attention_routeDirectly validates multiple load-bearing frameworks (long-running agents, durable external state, kernel flywheel, earned autonomy, SQLite-over-markdown substrate) with a from-the-wild working example
- 10-10 15:59attention_candidatecreate
- 10-10 15:59promote_anchororigin walk conf 0.85
- 10-10 15:52groundA from-the-wild, working loop orchestrator (1,200+ tickets over months in SQLite) that independently implements the exact long-running agent architecture Scott's frameworks prescribe: stateless w
- 10-10 15:40createSingle Reddit post by a senior engineer showing a concrete, working loop orchestrator artifact with 1,200+ managed tickets in SQLite β a plausible first demonstration of the pattern.