[P3.5] TUI dashboard blocks the event loop with synchronous DB loads every 2s

[frankbria]

Severity: low | Category: infra | Phase: P3.5

Problem

_refresh_data runs 5 synchronous SQLite queries directly on Textual's event loop every 2s, freezing input/rendering on larger workspaces.

Evidence

codeframe/tui/app.py:157

Acceptance criteria

Refresh runs in a thread worker (@work(thread=True)); results posted back to the UI thread; single connection reused.

Dependencies

None

---

_{Filed from the SaaS launch-readiness audit. Atomic: one developer, one session. Work order: strictly P0.1 → P3.12 (no forward dependencies).}

[coderabbitai]

🔗 Related PRs

#686 - fix(core): add busy_timeout + WAL to workspace SQLite connections (#648) [closed]

---

📝 Issue Planner

_{Check the box below or use the @coderabbitai plan command to generate an implementation plan and prompts that you can use with your favorite coding assistant.}

• Create Plan

---

🧪 Issue enrichment is currently in open beta.

To disable automatic issue enrichment, add the following to your .coderabbit.yaml:

issue_enrichment:
  auto_enrich:
    enabled: false

💬 Have feedback or questions? Drop into our discord!