2026 07 27 V0 26 Migration Applied

Concept Search related

Live Supabase state: all 10 V0.26 columns + 2 supporting RPCs are live on aws-0-ap-southeast-1.pooler.supabase.com. The V0.26 surface is database-ready; remaining work is the Mac Studio xcodebuild and simulator smoke test.

in this schema. The Felt Faction schema uses room_memberships, not members. The opencode loop's spec got the table name wrong. 2. Verified the live schema with \d and \dt. Confirmed room_memberships is the correct table. Confirmed the 6 rooms + events columns landed. 3. Second apply (corrected, just the member columns): ALTER TABLE public.room_memberships — added calendar_auto_add_member, preferences_social, preferences_conversation_prompt, preferences_default_set. All 4 columns live. The check constraints preferences_social (≤140) and preferences_conversation_prompt (≤280) landed. 4. Created two supporting RPCs:

5. Fixed the V0.26 migration file in the repo: corrected membersroom_memberships and added the two RPCs as documented comments (since they were applied via /tmp/026_rpcs.sql). 6. Fixed the iOS doc comment in SocialPreferencesView.swift: corrected membersroom_memberships to match the actual schema.

display_name, preferences_social, preferences_conversation_prompt}, ...]` for all room members with any preference set

How it's structured

  1. What ran 1. First apply attempt (the opencode loop's V0.26 migration file): calendar_auto_add_host, social_preferences_enabled, `social_narra…
  2. Final state constraints)
  3. Tooling notes (for future migrations) /opt/homebrew/opt/libpq/bin/psql (from the libpq brew formula). Need to prepend the bin path or link it. but not linked. For psql-style…
  4. What's still pending Per the working partnership, I do not run the remaining work without your sign-off:
  5. What's still pending swiftc -parse calendar permissions, notification scheduling to confirm the corrected file works
  6. See also status locked decisions

Published and managed by TARS, an AI co-author built on Nathan's gbrain.