не видит сессии opencode на windows

[govard108]

не видит сессии opencode на windows

[govard108]

Problem

On Windows, CodeDash may show no OpenCode sessions even when OpenCode has many sessions in opencode.db.

Environment

• OS: Windows
• Package: codedash-app (latest)
• OpenCode DB exists (example): C:\Users\<user>\.local\share\opencode\opencode.db
• sqlite3 CLI is not installed in PATH (common Windows setup)

Reproduction

1. Install codedash-app globally.
2. Ensure OpenCode has existing sessions.
3. Run codedash list (or open dashboard).

Actual behavior

OpenCode sessions are missing.
Internally, SQLite queries fail and are swallowed by broad catch {} blocks.

Expected behavior

OpenCode sessions should still load on Windows even without external sqlite3 binary.

Root cause

In src/data.js, OpenCode/Kiro/Cursor SQLite reads rely on execFileSync('sqlite3', ...).
On Windows, sqlite3 is often unavailable, causing ENOENT and silent fallback to empty results.
Also one query used bash-specific separator syntax ($'\t') which is not shell-portable.

Proposed fix

1. Add shared SQLite helper:
   • try sqlite3 CLI first;
   • if command is missing, fallback to Python stdlib sqlite3 (python -c ..., UTF-8 output).
2. Replace direct sqlite3 invocations in session scan/detail/cost paths with helper.
3. Improve OpenCode DB path detection on Windows:
   • prefer existing file among:
     • ~/.local/share/opencode/opencode.db
     • ~/AppData/Local/opencode/opencode.db
4. Remove bash-specific SQLite command construction and use uniform query execution API.

Why this is safe

• No behavior change when sqlite3 is installed.
• Improves cross-platform behavior.
• No new npm dependency required.

Validation done locally

• Before patch: codedash list returned only a small subset of sessions (OpenCode missing).
• After patch: OpenCode sessions loaded correctly (thousands visible), including codedash show <ses_...> details.

[vakovalskii]

What version of codedash are you running? (codedash version)

OpenCode on Windows stores its database at %LOCALAPPDATA%\opencode\opencode.db. Can you check if this file exists?

dir %LOCALAPPDATA%\opencode\opencode.db

Also — do you have sqlite3 CLI available? CodeDash uses it to read OpenCode/Kiro sessions:

sqlite3 --version

If sqlite3 is missing, that's likely the issue. You can install it via sqlite.org/download or scoop install sqlite.

[govard108]

Thanks, confirmed.

• codedash --version: 6.15.10
• %LOCALAPPDATA%\opencode\opencode.db: missing on my setup
• %USERPROFILE%\.local\share\opencode\opencode.db: exists
• sqlite3 --version: now installed and working (3.52.0)
  After installing sqlite3, OpenCode sessions are visible again (2000+), so this resolves it without local patching.
  Small suggestions:

1. show a clear warning if sqlite3 is missing (instead of silent OpenCode disappearance),
2. document both possible OpenCode DB paths on Windows,
3. there is still a stderr warning from one query: bad JSON path: '\$.type' (likely escaping issue, should be $.type).

[govard108]

Hi! I found a reproducible Windows issue with OpenCode sessions.

Environment

• OS: Windows 10
• codedash: 6.15.10
• sqlite3 installed and available in PATH (sqlite3 --version works)
• OpenCode DB exists and contains sessions

Problem

OpenCode sessions sometimes disappear from codedash list / UI after app start.

Root cause

In src/data.js (scanOpenCodeSessions) the main OpenCode query is executed with timeout: 5000:

execFileSync('sqlite3', [...], { timeout: 5000, ... })

On my machine this query often takes >5s, so it throws ETIMEDOUT.
The error is swallowed by catch {}, so users see missing OpenCode sessions with no warning.
Evidence

• Direct query via sqlite3 can exceed 5s.
• After changing timeout from 5000 to 30000 locally, sessions appear reliably every start.
• codedash list then consistently shows all OpenCode sessions.
  Suggested fix

1. Increase OpenCode scan timeout (e.g. 20-30s).
2. Do not silently swallow this error; at least log a warning that OpenCode scan timed out.
3. (Optional but recommended) add fallback if sqlite3 is missing (Python stdlib sqlite3).
4. (Optional) document both Windows OpenCode DB locations:
   • %LOCALAPPDATA%\opencode\opencode.db
   • %USERPROFILE%.local\share\opencode\opencode.db (some setups)

[vakovalskii]

OpenCode on Windows needs sqlite3 CLI available. Please update to latest and check if the issue persists.