David direction — heavy breadcrumbs so next session starts where we left off. Separate from handoff. Documents every decision, build, problem, and solution.

build-diary-03.md as primary continuity document

Old JS codeTemplate functions cannot be stored in SQLite. Replaced with plain text {{KEY}} placeholders. inputs_json stores field definitions. Simple find/replace at generate time.

Script template format — {{VAR}} placeholders

Separate from 30-sys.db following Health pattern (70-sys + 70-app). Tables: scripts/qa_log/shortcuts/commands. One DB for all Tech programs.

30-app.db as separate app database

frontend/30-Tech/ for users looking things up. systems/30-tech/ for build tools. Script builders moved to backend. Rule: build tools never on frontend.

Frontend vs backend split — user-facing vs controller tools

v1.5 → v1.8 migration complete. Server authoritative. config.json active. EXEC_OPEN deployed. Package A.

Tech [03] UP HERE v1.8 — 07/06/26