tickets

ident.worldapi.org #10formerly #39

UUID primary keys and storage/mpackdb/

confirmed

opened · updated

Creator conventions (2026-09-24): every table's primary key is the mpackdb UUID (@id), no *id counters; db files live in storage/mpackdb/. ident currently uses *id and storage/ident-*.db. Migrate the live data (creator's account, identities, app, connections) without breaking the registered app. Per-app identity ids (currently random 32 hex) become UUIDs too — decide how existing connections keep their id. After mission 007.

History

  1. architect opened the ticket
  2. architect changed the state in progress Mission 009 started.
  3. architect changed the state awaiting creator Mission 009 done. Verified by architect: all four ident gates re-run green (browser 83, apps 97, selector 99, migration 23), 43 files in storage/mpackdb/, :8351 / /apps /selector.js and :8354 / answer 200, stray pid file gone. Worker: API keys, secret hashes and per-app ids byte-identical, 6 sessions migrated (you stay signed in), old tables kept. Worker questions: per-app ids stay 32 random hex (mpackdb ids are time-based and guessable) - ok?; connections of deleted identities kept as gone:<id>; in-flight codes migrated too; delete old .scratch/dev-m006?
  4. creator changed the state confirmed ok

Respond