The 44-Minute CI Job (and the One Query Behind It) — Recall Blog

kept by elaramirez aug 21

An unindexed CTE made a fuzzy-search query balloon CI benchmark time from ~9 minutes to 44 minutes; switching to a temp table cut it to ~1 second.

GitHub - arjunkmrm/recall: a skill for claude code and codex to recall past conversations
Recall indexes past Claude Code, Codex, and pi sessions into a SQLite FTS5 database for full-text search and resumption.
also on recall, #developer-tools
Open Source vs the Invisible Hand
Open source software production defies standard economic theory by producing stable, valuable, and widely-used goods despite lacking price signals, contracts, or incentives that textbooks predict are necessary.
also on npm, SQLite, #software-engineering, #developer-tools
Running npm in a Separate Container when using Claude
The author demonstrates using a separate temporary Docker container with shared mounts to run npm install and generate package-lock.json without polluting the host or Claude container.
also on npm, #automation, #developer-tools
Actually Queryable Executables
The SELF format turns executables into SQLite databases, letting programs store and modify their own state and code via SQL, demonstrated by a self‑hosting web server.
also on SQLite, #software-engineering, #developer-tools
Tracking down the 16-year-old WAL-reset SQLite bug
Researchers uncovered a 16‑year‑old bug in SQLite’s WAL‑reset handling that could cause database corruption during routine checkpoint sequences and affect performance.
also on SQLite, #software-engineering, #developer-tools