Skip to content

feat(dashboard): SQLite migration + unified client.mjs CLI#3

Merged
epicsagas merged 5 commits into
mainfrom
worktree-orbit-sqlite-client-cli
Jun 10, 2026
Merged

feat(dashboard): SQLite migration + unified client.mjs CLI#3
epicsagas merged 5 commits into
mainfrom
worktree-orbit-sqlite-client-cli

Conversation

@epicsagas

Copy link
Copy Markdown
Owner

Summary

JSON 기반 데이터 저장소를 SQLite(sql.js)로 마이그레이션하고, 분산된 스크립트를 단일 client.mjs CLI로 통합합니다.

Changes

R1: SQLite DB layer

  • sql.js(WASM) 기반 SQLite — 네이티브 컴파일 없이 순수 npm 패키지
  • DB 경로: ~/.velith/velith.db
  • 테이블: projects, chapters, agents, scan_log

R2: Unified CLI (client.mjs)

  • node client.mjs scan [dir] — 기존 scan-project.js 대체
  • node client.mjs agents <id> <status> [task] — 기존 agent-status.js 대체
  • node client.mjs stats [dir] — SQLite에서 프로젝트 통계 조회
  • node client.mjs words <file> — 파일 단어/문자/라인 수 카운트
  • node client.mjs list — DB 내 모든 프로젝트 목록
  • node client.mjs serve — 대시보드 서버 실행

R3: Server integration

  • server.mjs / vite.config.ts → JSON 대신 getStatus()로 SQLite 읽기

R4: Skill/Agent updates

  • 7개 스킬: scan-project.jsclient.mjs scan
  • 7개 에이전트: agent-status.jsclient.mjs agents

Backward Compatibility

  • 기존 JSON 파일(status.json, projects.json) 병행 기록 유지
  • DB 비어있으면 JSON 캐시로 자동 폴백

Version

0.2.00.3.0 (MINOR: 새 기능 추가)

- Add client.mjs: unified CLI with scan/agents/stats/words/list/serve subcommands
- Replace scan-project.js + agent-status.js with SQLite-backed client.mjs
- Update server.mjs and vite.config.ts to read from SQLite via getStatus()
- Update all 7 skills to call 'node client.mjs scan' instead of scan-project.js
- Update all 7 agents to call 'node client.mjs agents' instead of agent-status.js
- Bump version 0.2.0 → 0.3.0
…tate

- Replace LIVE DATA toggle with UI_VERSION display in footer
- Show example link and no-data hint when no projects exist
- Update AGENTS.md: SQLite data layer, UI version bump instructions
- Mark agent-status.js as deprecated in plugin structure docs
@epicsagas epicsagas merged commit d1f384b into main Jun 10, 2026
@epicsagas epicsagas deleted the worktree-orbit-sqlite-client-cli branch June 10, 2026 03:41
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

1 participant