sqlite-only-commands-are-filesystem-llm-or-bulk
IN premise
The ~21 SQLite-only CLI commands fall into three categories: filesystem-dependent (hash-sources, check-stale, add-repo), LLM-powered (derive, review-beliefs, detect-contradictions, ask), and bulk import/sync — all requiring either local file access or load-entire-network-modify-save semantics incompatible with PgApi's per-operation transaction model.
Summary
The commands that only work with SQLite fall into three natural groups: ones that need to read files on disk, ones that call an LLM, and ones that do bulk data operations. What they share is that none of them fit the way the Postgres API works, which handles one operation at a time in separate transactions. This explains why these commands were left out of the Postgres migration — they weren't arbitrarily skipped, they each have a structural reason they can't just be swapped over.
Details
| Source | entries/2026/05/10/postgresql-backend-support.md |