René's URL Explorer Experiment


Title: feat(tables): live collaboration — cell-selection presence + live mutation propagation by waleedlatif1 · Pull Request #5957 · simstudioai/sim · GitHub

Open Graph Title: feat(tables): live collaboration — cell-selection presence + live mutation propagation by waleedlatif1 · Pull Request #5957 · simstudioai/sim

X Title: feat(tables): live collaboration — cell-selection presence + live mutation propagation by waleedlatif1 · Pull Request #5957 · simstudioai/sim

Description: Google-Sheets-style live collaboration for the Tables grid, in two layers over the realtime-rooms infrastructure: 1. Cell-selection presence (Socket.IO, mode A) Each collaborator's selection is outlined in their color, darkens while they're editing, shows their name on hover, and a presence-avatar stack appears in the header. Protocol @sim/realtime-protocol/table-presence: centralized events + TableCellSelection {anchor, focus, editing}; the selection delta carries only { socketId, cell } (identity comes from the roster). Room + authz: ROOM_TYPES.TABLE + resolveTableWorkspace in ROOM_WORKSPACE_RESOLVERS (tableId→workspace, honoring archivedAt); roomName/presenceEventName/disconnect-cleanup/authorizeRoom derive automatically. Server handlers/tables.ts: join/leave (mirrors workspace-files) + a validated table-cell-selection relay (untrusted cell is shape/size-checked before store + rebroadcast). UserPresence gains a cell field threaded through the memory + Redis managers. Client use-table-room.ts + RemoteSelectionOverlay: broadcasts stable (rowId, columnId) (indices aren't portable); draws each remote selection from live cell rects in the content wrapper's space (scrolls with the grid), hidden off-window, pointer-events-none (name-on-hover via pointer hit-test, CSS.escaped selector). Scoped to the dedicated tables page (embedded/mothership passes no id). 2. Live mutation propagation (durable log, mode B — last-write-wins) Every user mutation now shows live for collaborators, via two value-less durable signals (peers refetch in their own wire format; last-write-wins = the DB's committed order — the model confirmed by research on Sheets): edit → rows refetch: cell edit, single/batch row create, update, batch update, delete (id/filter), upsert. schema → definition + rows + list refetch: column add/update/delete, workflow-group add/update/delete, table rename, CSV import. Execution paths (column run, cancel) and async jobs (delete/import-async) already propagate via cell/dispatch/job events. Table archive is a deliberate follow-up (needs a redirect event, not a refetch signal). Quality Ran /simplify + /cleanup (14 agents total) + a holistic security/best-practice audit over the whole PR — findings applied (notably a peer-controlled-querySelector crash vector, and dropping a dead identity payload from the hot selection channel). realtime + table tests, all packages tsc, biome, check:api-validation — green. Needs a live 2-browser pass before the eventual staging ship: selection color/position under scroll+virtualization, editing-darken, name-on-hover, and live convergence of cell/row/column mutations.

Open Graph Description: Google-Sheets-style live collaboration for the Tables grid, in two layers over the realtime-rooms infrastructure: 1. Cell-selection presence (Socket.IO, mode A) Each collaborator's selection is...

X Description: Google-Sheets-style live collaboration for the Tables grid, in two layers over the realtime-rooms infrastructure: 1. Cell-selection presence (Socket.IO, mode A) Each collaborator's selectio...

Opengraph URL: https://github.com/simstudioai/sim/pull/5957

X: @github

direct link

Domain: github.com

react-profiling0
react-import-mapreact,react-dom,react-dom/client,react-dom/profiling,react-is,react-reconciler,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@d5750093facf
route-pattern/:user_id/:repository/pull/:id/files(.:format)
route-controllerpull_requests
route-actionfiles
fetch-noncev2:f7c37870-b731-d80f-b543-05ceb17c184d
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-id9E96:AE1F3:263FAA:35D18D:6AFB5236
html-safe-nonce7c1a9b56e98432fd558c8a22859ddc3e75fd72982cc595b187f49fa88c64c32b
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI5RTk2OkFFMUYzOjI2M0ZBQTozNUQxOEQ6NkFGQjUyMzYiLCJ2aXNpdG9yX2lkIjoiMzQ1OTY0OTA5ODQ4OTc0NTk3NCIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmac440f1fdad4087104e35f2764fef0f419fde008ab307b34c1c4b01800b1839b15
hovercard-subject-tagpull_request:4130737687
github-keyboard-shortcutsrepository,pull-request-list,pull-request-conversation,pull-request-files-changed,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///pull_requests/show/files
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/simstudioai/sim/pull/5957/files
twitter:imagehttps://avatars.githubusercontent.com/u/40672544?s=400&v=4
twitter:cardsummary_large_image
og:imagehttps://avatars.githubusercontent.com/u/40672544?s=400&v=4
og:image:altGoogle-Sheets-style live collaboration for the Tables grid, in two layers over the realtime-rooms infrastructure: 1. Cell-selection presence (Socket.IO, mode A) Each collaborator's selection is...
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
None7122bb414b542dba14d71a3f0b9f6fd2abce715b9f5912d082800563e6c806d1
turbo-cache-controlno-preview
diff-viewunified
go-importgithub.com/simstudioai/sim git https://github.com/simstudioai/sim.git
octolytics-dimension-user_id199344406
octolytics-dimension-user_loginsimstudioai
octolytics-dimension-repository_id912559512
octolytics-dimension-repository_nwosimstudioai/sim
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id912559512
octolytics-dimension-repository_network_root_nwosimstudioai/sim
turbo-body-classeslogged-out env-production page-responsive full-width
disable-turbotrue
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
releasecbf66c024bb6d10e6955baa7413c54cf13a201bb
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/simstudioai/sim/pull/5957/files#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F5957%2Ffiles
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://github.com/security/advanced-security
Copilot for businessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F5957%2Ffiles
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fpull_requests%2Fshow%2Ffiles&source=header-repo&source_repo=simstudioai%2Fsim
Reloadhttps://github.com/simstudioai/sim/pull/5957/files
Reloadhttps://github.com/simstudioai/sim/pull/5957/files
Reloadhttps://github.com/simstudioai/sim/pull/5957/files
simstudioaihttps://github.com/simstudioai
simhttps://github.com/simstudioai/sim
Codehttps://github.com/simstudioai/sim
Issues129 (129)https://github.com/simstudioai/sim/issues
Pull requests197 (197)https://github.com/simstudioai/sim/pulls
Actionshttps://github.com/simstudioai/sim/actions
Projectshttps://github.com/simstudioai/sim/projects
Security and qualityhttps://github.com/simstudioai/sim/security
Insightshttps://github.com/simstudioai/sim/pulse
Sign up for GitHub https://github.com/signup?return_to=%2Fsimstudioai%2Fsim%2Fissues%2Fnew%2Fchoose
terms of servicehttps://docs.github.com/terms
privacy statementhttps://docs.github.com/privacy
Sign inhttps://github.com/login?return_to=%2Fsimstudioai%2Fsim%2Fissues%2Fnew%2Fchoose
waleedlatif1https://github.com/waleedlatif1
realtime-roomshttps://github.com/simstudioai/sim/tree/realtime-rooms
realtime-rooms-tables-presencehttps://github.com/simstudioai/sim/tree/realtime-rooms-tables-presence
Conversation 45 https://github.com/simstudioai/sim/pull/5957
Commits 16 https://github.com/simstudioai/sim/pull/5957/commits
Checks 4 https://github.com/simstudioai/sim/pull/5957/checks
Files changed https://github.com/simstudioai/sim/pull/5957/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/5957/files
feat(tables): live collaboration — cell-selection presence + live mutation propagation https://github.com/simstudioai/sim/pull/5957/files#top
Show all changes 16 commits https://github.com/simstudioai/sim/pull/5957/files
35fbcf9 feat(tables): live cell-selection presence — protocol + server + clie… waleedlatif1 Jul 25, 2026 https://github.com/simstudioai/sim/pull/5957/commits/35fbcf947d397d6b2c85d67ee50cc1241fb6989d
bce9a85 feat(tables): render live cell-selection presence in the grid waleedlatif1 Jul 25, 2026 https://github.com/simstudioai/sim/pull/5957/commits/bce9a85a2bcfbf13f133ef4a747c5e6f04783b75
87d6930 test(tables): cover the table presence handler waleedlatif1 Jul 25, 2026 https://github.com/simstudioai/sim/pull/5957/commits/87d6930407dad2c4c24b00b4336e6860f808f0f2
2c95796 feat(tables): propagate manual cell edits live (last-write-wins) waleedlatif1 Jul 25, 2026 https://github.com/simstudioai/sim/pull/5957/commits/2c95796815019f87188cc595e9510d944ba2f15a
7ba5afd refactor(tables): apply /simplify findings waleedlatif1 Jul 25, 2026 https://github.com/simstudioai/sim/pull/5957/commits/7ba5afd1312a93cc7a12396e5b73eaa077292768
c75aada refactor(tables): apply /cleanup findings waleedlatif1 Jul 25, 2026 https://github.com/simstudioai/sim/pull/5957/commits/c75aada5400d0b2520a7a78c42aa4d1e95647646
61d1e98 feat(tables): propagate every table mutation live (edit + schema sign… waleedlatif1 Jul 25, 2026 https://github.com/simstudioai/sim/pull/5957/commits/61d1e982172e18e27abf31e97cfe2790c6b41065
aa4872f refactor(tables): apply comprehensive /cleanup audit findings waleedlatif1 Jul 25, 2026 https://github.com/simstudioai/sim/pull/5957/commits/aa4872f1ba2830af7fd05011657cd1be0b227e7d
672c200 fix(tables): broadcast single-cell selections (focus falls back to an… waleedlatif1 Jul 25, 2026 https://github.com/simstudioai/sim/pull/5957/commits/672c200449b38d4661246a0b9d97656a002035dd
b8f28b0 fix(tables): reviewer + regression + per-LOC audit findings waleedlatif1 Jul 25, 2026 https://github.com/simstudioai/sim/pull/5957/commits/b8f28b04bfce3574f3f07629e60200178b5dbd2e
9f7ca8b fix(tables): drop ineffective metadata propagation + re-measure overl… waleedlatif1 Jul 25, 2026 https://github.com/simstudioai/sim/pull/5957/commits/9f7ca8be725353c435163408b8baf4c7d09c8985
a56ffe6 fix(tables): re-broadcast local selection on (re)join waleedlatif1 Jul 25, 2026 https://github.com/simstudioai/sim/pull/5957/commits/a56ffe62bf33d799ce6905357a072b38e72cdaa4
cdc8796 fix(tables): re-broadcast selection when a peer's row change shifts it waleedlatif1 Jul 25, 2026 https://github.com/simstudioai/sim/pull/5957/commits/cdc8796b8f484b234920c3d01d811039799913be
8ba7476 fix(tables): schema invalidates run-state/enrichment + guard stale join waleedlatif1 Jul 25, 2026 https://github.com/simstudioai/sim/pull/5957/commits/8ba7476bba3e17c7e5226f70d552edd86b5d51b2
7098893 feat(tables): live column width/pin/order sync waleedlatif1 Jul 25, 2026 https://github.com/simstudioai/sim/pull/5957/commits/7098893d7e8934a75987f68ff920933845cb84a9
c7c98d2 fix(tables): escalate to schema signal when a reorder scrubs group deps waleedlatif1 Jul 25, 2026 https://github.com/simstudioai/sim/pull/5957/commits/c7c98d2d4d35c86132a011f71e1b3a57a5edb1f3
Clear filters https://github.com/simstudioai/sim/pull/5957/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/5957/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/5957/files
avatar.ts https://github.com/simstudioai/sim/pull/5957/files#diff-a186060e96a05a480403f66d92ecc6ee97f8c90736d82458794b36d2b298d7f1
index.ts https://github.com/simstudioai/sim/pull/5957/files#diff-d75833a2f129b649d1250577a473393fadbee1f55f24ed607a0b7d77b511af59
tables.test.ts https://github.com/simstudioai/sim/pull/5957/files#diff-7380acf3cf859e96f0d7311c038ba0a0e021b8751418c11effa22c880b75ce92
tables.ts https://github.com/simstudioai/sim/pull/5957/files#diff-00b228ce8901bae9761e81272e244e9746ef76267178fed37fbb35eb2d81aa43
workspace-files.ts https://github.com/simstudioai/sim/pull/5957/files#diff-084fa627c9e97a3928b4a3f7142e5f07cd55343416f5d15b1786afe432f6f5ca
memory-manager.ts https://github.com/simstudioai/sim/pull/5957/files#diff-fd4524b447cea106543b9d60a692cb02949ec4d758b8b5bba30c6b9d661659a3
redis-manager.ts https://github.com/simstudioai/sim/pull/5957/files#diff-2b2899aa21a13f2664744c7a87b257a22ab9c68b8a29422f0c733af16ee9b897
types.ts https://github.com/simstudioai/sim/pull/5957/files#diff-731dbe0d0091b1ff63c25da26d7f6c0444b9666dcb619d8b31bda8208bea7882
route.ts https://github.com/simstudioai/sim/pull/5957/files#diff-058ce452846cca33dfbc1301fa472e0b7adccb0eced2c918e09c9aead8c2d6b5
route.ts https://github.com/simstudioai/sim/pull/5957/files#diff-f96881cb5433f69f90def52fae7a7541c941283deca971d6ba08d6d0d89ef8a7
route.ts https://github.com/simstudioai/sim/pull/5957/files#diff-3948f2e8bbf44ed8af36b5ca1a2032e7d929920e8faa2eba83eff0cdbaa16da2
route.ts https://github.com/simstudioai/sim/pull/5957/files#diff-67a17b19d3de9d0eda1ffd25a6f4cd39bc942e3af42d1df69b0346adfd790450
route.ts https://github.com/simstudioai/sim/pull/5957/files#diff-af63fb1520039c1507662bda0884649d85c7878f621acd42d59a04643d76579e
route.ts https://github.com/simstudioai/sim/pull/5957/files#diff-645eb9cb737e88d528c2fa56a12f66b9a1195ab8f139fe7ccd8a288593533f38
route.ts https://github.com/simstudioai/sim/pull/5957/files#diff-1d524d6cc0249dc92450d77e6a2572ddeebca5658f48b15a06026fefe7c8713e
route.ts https://github.com/simstudioai/sim/pull/5957/files#diff-0f0b09ebc40935db7a10eaf876c152b022cb3c6274986c64cc713e2441c65db9
remote-selection-overlay.tsx https://github.com/simstudioai/sim/pull/5957/files#diff-72afc81eb1251e22984e6bfacce6bd5ba4429ec12c0dd3ead584ad40257c73c6
table-grid.tsx https://github.com/simstudioai/sim/pull/5957/files#diff-264141b75a0ee2c4464df4bb6f5722cd982587470cf162e5aae9de04c84fbc0e
index.ts https://github.com/simstudioai/sim/pull/5957/files#diff-c3745820ea293c17482404a5d09f4fb44e383c34fa150ea932b3c385d16e3e18
use-table-event-stream.ts https://github.com/simstudioai/sim/pull/5957/files#diff-c60c72baa945552c031a0f8e07bd9ed12985b66f2c59e482419816966baee8e6
use-table-room.ts https://github.com/simstudioai/sim/pull/5957/files#diff-d2898c331331ceb85dc100627db436eb6f65bcd3725a4af44bf59c8d04f4f3e9
table.tsx https://github.com/simstudioai/sim/pull/5957/files#diff-5a65d49f1fb75a42db9178db41caa5cb9bf776a547ab82822e99a13bd51a1669
events.ts https://github.com/simstudioai/sim/pull/5957/files#diff-f4db8c424928e747aaffb7c0352fdb9690e85dd886cf357a8deca0cdaf29e6e3
service.ts https://github.com/simstudioai/sim/pull/5957/files#diff-691e9b1dc59be0015a1be5ea6189899b241d4e979a8b40e088dd7d722cfaadb6
rooms.ts https://github.com/simstudioai/sim/pull/5957/files#diff-05f26eaeb2d1596cf6c5007742b214592bdd2594198be30f698a0729fbc65980
package.json https://github.com/simstudioai/sim/pull/5957/files#diff-d75b24dd1f8c9a9d138e3f71a6574e78b00e204d868d9ea4dd4016b98304d914
rooms.ts https://github.com/simstudioai/sim/pull/5957/files#diff-2181e75fbfa18756e11f5f4c076b8220f2e3f28caf19e54074609003a6685800
table-presence.ts https://github.com/simstudioai/sim/pull/5957/files#diff-4942f5db3ecd6f100e534bd2ac25b76ca5cb208012d0f44a79ad1236d79cde43
apps/realtime/src/handlers/avatar.tshttps://github.com/simstudioai/sim/pull/5957/files#diff-a186060e96a05a480403f66d92ecc6ee97f8c90736d82458794b36d2b298d7f1
View file https://github.com/simstudioai/sim/blob/c7c98d2d4d35c86132a011f71e1b3a57a5edb1f3/apps/realtime/src/handlers/avatar.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/5957/{{ revealButtonHref }}
apps/realtime/src/handlers/index.tshttps://github.com/simstudioai/sim/pull/5957/files#diff-d75833a2f129b649d1250577a473393fadbee1f55f24ed607a0b7d77b511af59
View file https://github.com/simstudioai/sim/blob/c7c98d2d4d35c86132a011f71e1b3a57a5edb1f3/apps/realtime/src/handlers/index.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/5957/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/5957/files#diff-d75833a2f129b649d1250577a473393fadbee1f55f24ed607a0b7d77b511af59
https://github.com/simstudioai/sim/pull/5957/files#diff-d75833a2f129b649d1250577a473393fadbee1f55f24ed607a0b7d77b511af59
apps/realtime/src/handlers/tables.test.tshttps://github.com/simstudioai/sim/pull/5957/files#diff-7380acf3cf859e96f0d7311c038ba0a0e021b8751418c11effa22c880b75ce92
View file https://github.com/simstudioai/sim/blob/c7c98d2d4d35c86132a011f71e1b3a57a5edb1f3/apps/realtime/src/handlers/tables.test.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/5957/{{ revealButtonHref }}
Please reload this pagehttps://github.com/simstudioai/sim/pull/5957/files
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.