Skip to content

v1.3.0 - Power Optimization & Single-Pass SQLite Batching

Latest

Choose a tag to compare

@m24ih m24ih released this 13 Oct 18:50
· 3 commits to main since this release

Highlights in v1.3.0

Added

  • Live Status Badge in WebUI: Added an animated, Nothing OS styled status pill (Idle, Waiting AI, Syncing) in the WebUI header reporting real-time execution state via status.json.
  • Doze & Power-Aware Daemon (service.sh): Added is_screen_on helper (checking dumpsys window / display / power) relaxing background checks to 600s during screen-off/Doze to eliminate battery wake locks.
  • Database Modification Guard (is_db_modified): Added high-efficiency mtime checking against last_sync_time.txt to avoid spawning subprocesses when database files have not changed.

Performance & Optimization

  • Single-Pass SQLite Batch Processing: Eliminated the N+1 query bottleneck in sync.sh (where ~20 separate sqlite3 CLI processes were executed per card). All cards, media resources, tasks (card_events), and AI analyses are now extracted in a single consolidated SQL query with an ultra-lightweight stream demuxer, reducing sync times from seconds to sub-100 milliseconds.
  • Incremental WebUI Log Reader: Switched WebUI log fetching to tail -n 100 to prevent IPC bloat and WebView lags as logs grow.

Modernization

  • English-First Standardization: Standardized all internal code comments, daemon/sync engine terminal logs, and WebUI strings to English while preserving localized Obsidian note template dictionaries (tr, de, fr, es, en).