Roadmap 0.11, SuperCad Studio

SCF.6 Move notes, tasks, time, calendar and communications onto the file director and the account database (work_* tables)

  • Feature
  • Built · in the lab
  • SuperCad Studio

They still keep JSON files under Data/<plugin>/ with sequence ids. Needs uuid rows, server tables and endpoints from the spec, and a migration that reads the old files through.

super-file-11 2026-11-20: Notes, tasks, time, calendar and communications are rows through the file director (super-rowdoc.js: the plug-ins' data.js rules are unchanged; each store.js reads and writes its document as work_* rows). A file saved today migrates on first use, the old file is left as it was and then kept current beside the rows (both until the owner says). Migration tested per plug-in from a file the previous build wrote: bin/test-super-rowdoc.mjs 147/0; the real page: tools/super-test/work-rows.mjs. work_attendee and work_comm_file stay inside their event / entry.

scf-built-11 2026-11-21: BUILT, in the lab. The account database now serves the work rows: schema 5 of the account SQLite (UserDb::WORK_TABLES work_note, work_task, work_time, work_event, work_comm: uuid, id, n, updated_at, deleted_at, gone, entry), service UserWork (newest wins, a tie by content, a clock 5 minutes ahead refused, tombstones kept, 256 KB a row), thin endpoint /api/v1/account/work (GET ?since / ?stats, POST merge; sync tokens), named by /api/v1/account/database as the `work` dataset. Page: every plug-in's director hears the account's datasets (one key, cc-super-datasets; the host asks once a session when signed in), the host door allows /api/v1/account/work, and rows written before the server named the table are sent once by a batched backfill. bin/test-user-work.php 29/0; tools/super-test/work-sync-live.mjs 12/0 against the real server (a note written before the server answered arrives by the backfill, one after at once, no duplicates, a second device reads both, /account/super-teams counts them); work-rows.mjs 16/0, test-super-director 102/0, test-super-rowdoc 147/0, test-super-teams 321/0, test-super-plugins 83/0, test-super-core 309/0.

Add a comment

Community comments

No comments yet

Add detail as we go: how you would use it, files or steps that show the problem, what other programs do. The team reads every comment.

Sign in or create a free account to add a comment.